Read the data from SharePoint site programmatically & process that data in this application with the help of C# dotnet.

[BhupSyne]

What type of issue is this?

Question

What SharePoint development model, framework, SDK or API is this about?

💥 SharePoint Framework

Target SharePoint environment

SharePoint Online

What browser(s) / client(s) have you tested

• 💥 Internet Explorer
• 💥 Microsoft Edge
• 💥 Google Chrome
• 💥 FireFox
• 💥 Safari
• mobile (iOS/iPadOS)
• mobile (Android)
• not applicable
• other (enter in the "Additional environment details" area below)

Additional environment details

• C# .net
• C# .net core

Issue description

• Read the data from SharePoint site programmatically & process that data in this application with the help of C# dotnet.
• For token generation I am using Azure AD, please shared details steps for App Registration and setting configuration for the same.
• For reading data from SharePoint site I have to any configuration please provide details steps for the same.

[Ashlesha-MSFT]

Hello @BhupSyne,
Thank you for bringing this issue to our attention. We will look into it and get back to you shortly.
If you don’t receive a reply within two working days, please use this escalation form to escalate.

[Ashlesha-MSFT]

@BhupSyne,

Step 1: Register App in Microsoft Entra ID

• Create Client Secret
• API Permissions → Add Permission

1. Microsoft Graph

• Select Microsoft Graph
• Choose Application permissions
• Add: Sites.Read.All
• Click Grant Admin Consent
• Do same for sharepoint API

Step 2: Go to your SharePoint site, e.g., https://<>.sharepoint.com/sites/first.

Open the AppInv page:
https://<>sharepoint.com/sites/first/_layouts/15/appinv.aspx
Enter App ID of your Azure AD app: <<CLIENT_ID>> and click Lookup.

Fill in:
Title: TestApp
App Domain: localhost
Redirect URI: https://localhost
In Permission Request XML, paste:

<AppPermissionRequests AllowAppOnlyPolicy="true">
    <AppPermissionRequest Scope="http://sharepoint/content/sitecollection" Right="Read" />
</AppPermissionRequests>

Click Create → Trust It.

Step 3: Create the C# Project

• Open Visual Studio → Click Create a new project → Select Console App (.NET).
• Name it, e.g., SharePointAppDemo.
• Select .NET 6 or 7 as framework → Click Create.

Step 4: Install Required Packages

Open Package Manager Console in Visual Studio and run:

Install-Package Microsoft.Identity.Client
Install-Package Microsoft.Graph

These allow app-only authentication and working with SharePoint via Graph API.

Step 5: Replace Program.cs with This Code

using System;
using System.Net.Http.Headers;
using System.Threading.Tasks;
using Microsoft.Graph;
using Microsoft.Graph.Models;
using Microsoft.Identity.Client;
using Microsoft.Kiota.Abstractions.Authentication;

namespace SharePointAppOnlyDemo
{
    class Program
    {
        static async Task Main(string[] args)
        {
            // Azure AD App registration details
            string tenantId = "<<TENANT_ID>>";
            string clientId = "<<CLIENT_ID>>";
            string clientSecret = "<<SECRET>>";

            // SharePoint site info
            string siteDomain = "<<TENANT>>.sharepoint.com";
            string siteName = "first";

            try
            {
                Console.WriteLine("🔐 Authenticating with Azure AD...");

                // Get an access token using client credentials (app-only)
                IConfidentialClientApplication app = ConfidentialClientApplicationBuilder
                    .Create(clientId)
                    .WithClientSecret(clientSecret)
                    .WithAuthority($"https://login.microsoftonline.com/{tenantId}")
                    .Build();

                string[] scopes = new string[] { "https://graph.microsoft.com/.default" };
                AuthenticationResult authResult = await app.AcquireTokenForClient(scopes).ExecuteAsync();

                Console.WriteLine("✅ Authentication successful!");

                // Initialize Graph client with proper authentication provider
                var authProvider = new BaseBearerTokenAuthenticationProvider(
                    new TokenProvider(authResult.AccessToken));

                GraphServiceClient graphClient = new GraphServiceClient(authProvider);

                Console.WriteLine($"\n📍 Connecting to SharePoint site: {siteDomain}/sites/{siteName}");

                // Get SharePoint site
                var site = await graphClient
                    .Sites[$"{siteDomain}:/sites/{siteName}"]
                    .GetAsync();

                Console.WriteLine($"✅ Connected to site: {site?.DisplayName} (ID: {site?.Id})");

                // Read items from Documents library
                Console.WriteLine("\n📋 Reading items from Documents library...");

                var listItems = await graphClient
                    .Sites[site.Id]
                    .Lists["Documents"]
                    .Items
                    .GetAsync(requestConfig =>
                    {
                        requestConfig.QueryParameters.Expand = new string[] { "fields" };
                    });

                Console.WriteLine($"\n📊 Found {listItems?.Value?.Count ?? 0} items:");
                Console.WriteLine(new string('-', 80));

                if (listItems?.Value != null)
                {
                    foreach (var item in listItems.Value)
                    {
                        Console.WriteLine($"\n📄 Item ID: {item.Id}");

                        if (item.Fields?.AdditionalData != null)
                        {
                            foreach (var field in item.Fields.AdditionalData)
                            {
                                Console.WriteLine($"   {field.Key}: {field.Value}");
                            }
                        }
                        Console.WriteLine(new string('-', 80));
                    }
                }

                Console.WriteLine("\n✅ Done!");
            }
            catch (ServiceException ex)
            {
                Console.WriteLine($"\n❌ Graph API Error: {ex.ResponseStatusCode} - {ex.Message}");
            }
            catch (Exception ex)
            {
                Console.WriteLine($"\n❌ Error: {ex.Message}");
                Console.WriteLine($"Stack Trace: {ex.StackTrace}");
            }
        }
    }

    // Token provider class for authentication
    public class TokenProvider : IAccessTokenProvider
    {
        private readonly string _accessToken;

        public TokenProvider(string accessToken)
        {
            _accessToken = accessToken;
        }

        public Task<string> GetAuthorizationTokenAsync(Uri uri, Dictionary<string, object>? additionalAuthenticationContext = null, CancellationToken cancellationToken = default)
        {
            return Task.FromResult(_accessToken);
        }

        public AllowedHostsValidator AllowedHostsValidator => new AllowedHostsValidator();
    }
}

Step 6: Build and Run

• Press Ctrl+Shift+B to build → make sure no errors.
• Press F5 or Ctrl+F5 to run.

You should see console output like:

[BhupSyne]

Thank you for providing such a timely and detailed reply to my query.

[BhupSyne]

Currently, only 200 records are being returned. Could you kindly share the detailed code to fetch the entire dataset

[Ashlesha-MSFT]

@BhupSyne,
As per the official Microsoft documentation on paging in Microsoft Graph:
https://learn.microsoft.com/en-us/graph/paging

• Many GET requests return only a default number of results per page.
• If there are more items than fit in one page, the response includes @odata.nextLink.
• To retrieve the complete dataset, you must follow the URL provided in @odata.nextLink to request the next page of results. This process should be repeated until the response no longer contains @odata.nextLink.

For additional reference, you may also check:

https://community.blueprism.com/t5/Product-Forum/Microsoft-Graph-API-returns-only-200-records-for-items-within/td-p/71669
https://learn.microsoft.com/en-us/answers/questions/1649957/how-to-fetch-more-than-200-files-from-sharepoint-f

As your posted issue resolved : Please rate us:

Your feedback is important to us. Please rate us:

🤩 Excellent🙂 Good 😐 Average 🙁 Needs Improvement 😠 Poor
SharePoint framework Developer Community Feedback

[Ashlesha-MSFT]

Hi @BhupSyne,

Just checking in — were you able to resolve the original issue regarding reading and processing data from SharePoint using C# and Azure AD app-only authentication?

If the issue has been resolved based on the provided guidance (including paging with @odata.nextLink for fetching the complete dataset), could you please go ahead and close this issue?

If you encounter any further problems or have additional questions, feel free to open a new issue and we’ll be happy to assist.

Thank you!