May 20, 2017 / Last updated : May 20, 2017 Sethu REST API's

How to Get List of folders and files in SharePoint Document library using REST API in SharePoint online/Office 365?

Hello SharePointers, Below is the REST API snippet to find folders and files inside the folder url of a sharepoint document library. var folderUrl = ‘myfolder/2016’; var url = _spPageContextInfo.webServerRelativeUrl + “/_api/Web/GetFolderByServerRelativeUrl(‘” + folderUrl + “‘)?$expand=Folders,Files”; $.getJSON(url,function(data,status,xhr){ for(var i = 0; i < data.Files.length;i++){ console.log(data.Files[i].Name); } for(var i = 0; i < data.Folders.length;i++){ console.log(data.Folders[i].Name); } […]
May 20, 2017 / Last updated : May 20, 2017 Sethu Client Object Model

How to Delete SharePoint List attachements using CSOM in SharePoint Online/Office 365?

Hello SharePointers, Below is the CSOM Code snippet to delete SharePoint list attachments in SharePoint Online/Office 365. public static void DeleteAttachmentFilesfromListItem(ClientContext cc, string listName,int listItemId) { var list = cc.Web.Lists.GetByTitle(listName); var listItem = list.GetItemById(listItemId); cc.Load(listItem, li => li.AttachmentFiles); cc.ExecuteQuery(); listItem.AttachmentFiles.ToList().ForEach(a => a.DeleteObject()); context.ExecuteQuery(); } Happy SharePointing :-)(  
May 18, 2017 / Last updated : May 18, 2017 Sethu Client Object Model

How to Send email to External users in SharePoint online using CSOM?

Hello SharePointers, Below is the CSOM code to send email to External users in SharePoint online using CSOM string Url = “https://tenant.sharepoint.com/sites/comms/”; var cc = new ClientContext(Url); string passwordPlainText = “userpassword”; string currentUserLoginName = “user@tenant.onmicrosoft.com”; var passWord = new SecureString(); foreach (char c in passwordPlainText.ToCharArray()) passWord.AppendChar(c); cc.Credentials = new SharePointOnlineCredentials(currentUserLoginName, passWord); web.EnsureUser(“i:0#.f|membership|paige.turner_contoso.com#ext#@tenant.onmicrosoft.com”); clientContext.ExecuteQuery(); var emailProperties = […]
May 18, 2017 / Last updated : May 18, 2017 Sethu Client Object Model

How to get the list of external Users shared for a particular document library using CSOM?

Hello SharePointers, Below is the CSOM code to get list of external Users shared for a particular document library using CSOM. string URL = “https://yourtenant.sharepoint.com/sites/”; string userName = “user@yourtenant.onmicrosoft.com”; string userPassword = “password”; string fullDocumentUrl = “https://yourtenant.sharepoint.com/sites//Shared%20Documents/my_sample_document.xlsx”; using (var cc = new ClientContext(Url)) { var passWord = new SecureString(); foreach (char c in userPassword.ToCharArray()) passWord.AppendChar(c); cc.Credentials = new […]
May 18, 2017 / Last updated : May 18, 2017 Sethu Client Side Object Model

How to get the total number of external users of a Office 365 tenant in SharePoint online/Office 365?

Hello SharePointers, In this blog, we will see how to get the total number of external users of a Office 365 tenant in SharePoint online/Office 365. Here are the code below List<ExternalShareDetails> shares = new List<ExternalShareDetails>(); string adminRealm = TokenHelper.GetRealmFromTargetUrl(tenantAdminUri); var adminToken = TokenHelper.GetAppOnlyAccessToken(TokenHelper.SharePointPrincipal, tenantAdminUri.Authority, adminRealm).AccessToken; using (var cc = TokenHelper.GetClientContextWithAccessToken(tenantAdminUri.ToString(), adminToken)) { var tenant = new […]