Blogs

Upload document to SharePoint from Microsoft D365 CE using C# Web API & manage SharePoint document metadata

Inkey, March 20, 2019 9759 Views

The integration of Microsoft D365 CE with SharePoint has enabled the document management in SharePoint precisely in the form of folders and subfolders, in a structured way.

Today in this blog, let’s learn how we can upload the documents in SharePoint from the D365 CE using the Dot Net c# web API code with a secured authentication using the Azure Web App.

Example: Upload the documents, which are attached with the Notes in D365 CE to the SharePoint folder.

For this, we are creating a CRM plug-in to execute on the create of Notes record in D365 CE. This will then invoke the Dot Net Web API, where we authorize and authenticate the SharePoint user in Azure and process further to upload the document in SharePoint using the metadata by a secured authentication of the Azure web App.

Below is the plug-in code that is executed on the creation of Notes record in D365 CE:

• Web App & SharePoint authentication:

//Specify the web App authentication credentials here
AuthenticationResponse authenticationResponse = Common.GetWebAPIAuthenticationResponse(clientId, resourceId, appKey, aadInstance, iTracingService);

HttpClient httpClient = new HttpClient();
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", authenticationResponse.access_token);

      //Specify the SharePoint metadata details here
      object parameters = new
      {
       SiteUrl = SharePointConnectorURL,
       ListName = documentCategoryText,
       FolderURL = SharePointDocumentURL,
       FileContent = documentBody,
       FileName = SharePointDocumentName,
       TaxonomyFields = taxonomyFields,
       StandardFields = standardFields
      };

• Send the object to the Web API hosted in Azure by converting it into JSON format:

StringContent stringContent = new StringContent(JsonConvert.SerializeObject(parameters), Encoding.UTF8, "application/json");

HttpResponseMessage httpResponseMessage = httpClient.PostAsync(string.Format("{0}/Api/UploadDocuments/Post", apiBaseAddress), stringContent).Result;

Then create a Dot Net Web API project and add the following parameters into the model class:

public class UploadDocuments
{
 public string SiteUrl { get; set; }
 public string ListName { get; set; }
 public string FolderURL { get; set; }
 public string FileContent { get; set; }
 public string FileName { get; set; }
 public Dictionary<String, String> TaxonomyFields { get; set; }
 public Dictionary<String, String> StandardFields { get; set; }
}

Next, we need to create a controller class for authenticating and getting a connection to the SharePoint site. Provide the valid credentials for the connection using “CloudConfigurationManager”.

And, don’t forget to use the proper namespaces for connecting with Azure like “Microsoft.Azure”, “Microsoft.SharePoint.Client”, “Microsoft.SharePoint.Client.Taxonomy”.

Credentials:

string UserName = CloudConfigurationManager.GetSetting("UserName");
string Password = CloudConfigurationManager.GetSetting("UserPassword");

Create an object of ClientContext with the siteUrl & credentials of SharePoint:

ClientContext clientContext = new ClientContext(parameters.SiteUrl);
clientContext.Credentials = new SharePointOnlineCredentials(UserName, ConvertToSecureString(Password));

Create an object of Web class:

Web clientWebContext = clientContext.Web;

Get the file content as below:

byte[] file = Convert.FromBase64String(parameters.FileContent);

FileCreationInformation newFile = new FileCreationInformation();
newFile.ContentStream = new MemoryStream(file);
newFile.Url = parameters.FileName;
newFile.Overwrite = true;

Upload the file to SharePoint:

List documents = clientWebContext.Lists.GetByTitle(parameters.ListName);
Microsoft.SharePoint.Client.File uploadFile;
if (string.IsNullOrWhiteSpace(parameters.FolderURL) == true)
{ 
 uploadFile = documents.RootFolder.Files.Add(newFile); 
}
else
{
 Folder targetFolder = clientWebContext.GetFolderByServerRelativeUrl(parameters.FolderURL);
 uploadFile = targetFolder.Files.Add(newFile);
}
clientContext.Load(uploadFile, uf => uf.ListItemAllFields);

clientContext.ExecuteQuery();
ListItem item = uploadFile.ListItemAllFields;
clientContext.Load(item);

I hope this helps you.

Insert data into Many-to-Many relationship in Dynamics CRM very easily & quickly, using the Drag and drop listbox.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/drag-and-drop-listbox

Comply your Lead, Contact, and User entities of D365 CRM with GDPR compliance using the GDPR add-on.
https://www.inkeysolutions.com/microsoft-dynamics-365/dynamicscrmaddons/gdpr

Create a personal / system view in Dynamics CRM with all the fields on the form/s which you select for a particular entity using the View Creator.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/view-creator