SharePoint Document Integration

This application integrates with SharePoint to retrieve documents from a library and display them for download. Below, you can see the retrieved documents from the "Documents" library in the "AuthDemoSite" SharePoint site.

Screenshot of the SharePoint "Documents" library from the AuthDemoSite.

How the Code Works

The application uses the SharePoint REST API and Azure AD authentication to retrieve files. Here’s a high-level overview of the process:

1. Authentication: The application uses an Azure AD app registration and an X.509 certificate to authenticate with SharePoint.
2. Access Token Retrieval: The application retrieves an OAuth access token using the Azure AD credentials.
3. Document Retrieval: A request is sent to SharePoint's REST API to fetch the documents in the specified library.
4. Displaying Files: The files are listed with their names and download links in the view.

Key Code Examples

Select a code example to view:

X509Certificate2 certificate = new X509Certificate2(certPath, "PASSWORD", X509KeyStorageFlags.MachineKeySet);
IConfidentialClientApplication app = ConfidentialClientApplicationBuilder
    .Create(clientId)
    .WithCertificate(certificate)
    .WithAuthority(new Uri($"https://login.microsoftonline.com/{tenantId}")) 
    .Build();
string accessToken = await app.AcquireTokenForClient(new[] { "https://lennoxfamily.sharepoint.com/.default" }).ExecuteAsync();

using (var context = new ClientContext(siteUrl))
{
    context.ExecutingWebRequest += (sender, e) =>
    {
        e.WebRequestExecutor.RequestHeaders["Authorization"] = "Bearer " + accessToken;
    };
    List documentLibrary = context.Web.Lists.GetByTitle(libraryName);
    CamlQuery query = new CamlQuery
    {
        ViewXml = "" 
    };
    ListItemCollection items = documentLibrary.GetItems(query);
    context.Load(items);
    context.ExecuteQuery();
}

FileInformation fileInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(context, serverRelativeUrl);
using (var memoryStream = new MemoryStream())
{
    fileInfo.Stream.CopyTo(memoryStream);
    memoryStream.Position = 0;
    return File(memoryStream.ToArray(), "application/octet-stream", fileName);
}

Documents