Unable to Retrieve SharePoint List Items in .NET Core using SharePoint Rest API

Question

Unable to Retrieve SharePoint List Items in .NET Core using SharePoint Rest API

ArunKumar Arumugam 60

Hi Team,

I have created a new app registration in the Azure Active Directory section and generated a client secret. I also granted the necessary API permissions for SharePoint sites with 'AllSites.FullControl' and obtained admin consent.

I used the client ID, tenant ID, and client secret in my .NET Core application to fetch SharePoint list details using the "SharePoint REST API". However, I received an 'Unauthorized' response.

Could you please review this and provide suggestions to resolve the issue using the "SharePoint REST API"?

Note: Please provide the details using the "SharePoint REST API" instead of the "Graph Client."

James Hamil 27,211 Reputation points Microsoft Employee Moderator

2024-10-16T21:03:33.8766667+00:00
Hi @ArunKumar Arumugam , please make sure you have the following permissions:

Sites.FullControl.All

Sites.ReadWrite.All

Sites.Read.All

Sites.Manage.All

If this still doesn't work please let me know.

Best,

James
ArunKumar Arumugam 60 Reputation points

2024-10-17T05:39:29.87+00:00

Hi James Hamil,

Yes, I have already granted all the mentioned permissions, but the issue still persists.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2024-10-23T09:44:30.41+00:00

Verify that your application is correctly acquiring the access token. Ensure that the token is valid and has not expired.

ArunKumar Arumugam 60

Hi Emily Du-MSFT,

Below is my code. Could you please review it and provide guidance on resolving the 'Unauthorized' response?

using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Threading.Tasks;
using Microsoft.Identity.Client;
namespace SharePointAPI
{
    class Program
    {
        private static string tenantId = "TENANT_ID";
        private static string clientId = "CLIENT_ID";
        private static string clientSecret = "CLIENT_SECRET";
		private static string domain = "https://<SharePoint_Domain>.sharepoint.com"; 
        private static string siteUrl = "https://DOMAIN.sharepoint.com/sites/SITE";
        private static string listName = "LIST_NAME";
        static async Task Main(string[] args)
        {
            var accessToken = await GetAccessTokenAsync();
            await GetSharePointListItemsAsync(accessToken);
        }
        private static async Task<string> GetAccessTokenAsync()
        {
            IConfidentialClientApplication app = ConfidentialClientApplicationBuilder.Create(clientId)
                .WithClientSecret(clientSecret)
                .WithAuthority(new Uri($"https://login.microsoftonline.com/{tenantId}"))
                .Build();
            string[] scopes = { $"{domain}/.default" };
            AuthenticationResult result = await app.AcquireTokenForClient(scopes).ExecuteAsync();
            return result.AccessToken;
        }
        private static async Task GetSharePointListItemsAsync(string accessToken)
        {
            using HttpClient httpClient = new HttpClient();
            httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", accessToken);
            var endpoint = $"{siteUrl}/_api/web/lists/getbytitle('{listName}')/items";
            HttpResponseMessage response = await httpClient.GetAsync(endpoint);
            if (response.IsSuccessStatusCode)
            {
                var content = await response.Content.ReadAsStringAsync();
                Console.WriteLine("List Items:");
                Console.WriteLine(content);
            }
            else
            {
                Console.WriteLine($"Error: {response.StatusCode}");
                Console.WriteLine(await response.Content.ReadAsStringAsync());
            }
        }
    }
}

ArunKumar Arumugam 60 Reputation points

2024-11-06T04:47:16.26+00:00

Hi Team,

Could you please share any updates?
ArunKumar Arumugam 60 Reputation points

2024-12-05T14:27:03.7966667+00:00

Hi Team,

Could you please share any updates?
ArunKumar Arumugam 60 Reputation points

2025-03-18T13:59:33.8633333+00:00

Hi Team,

Could you please share any updates on this?

Your answer

James Hamil 27,211 Reputation points Microsoft Employee Moderator

2024-10-16T21:03:33.8766667+00:00

Hi @ArunKumar Arumugam , please make sure you have the following permissions:

Sites.FullControl.All

Sites.ReadWrite.All

Sites.Read.All

Sites.Manage.All

If this still doesn't work please let me know.

Best,

James
ArunKumar Arumugam 60 Reputation points

2024-10-17T05:39:29.87+00:00

Hi James Hamil,

Yes, I have already granted all the mentioned permissions, but the issue still persists.
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2024-10-23T09:44:30.41+00:00

Verify that your application is correctly acquiring the access token. Ensure that the token is valid and has not expired.
ArunKumar Arumugam 60 Reputation points

2024-10-29T08:36:48.4733333+00:00

Hi Emily Du-MSFT,

Below is my code. Could you please review it and provide guidance on resolving the 'Unauthorized' response?

using System; using System.Net.Http; using System.Net.Http.Headers; using System.Threading.Tasks; using Microsoft.Identity.Client; namespace SharePointAPI { class Program { private static string tenantId = "TENANT_ID"; private static string clientId = "CLIENT_ID"; private static string clientSecret = "CLIENT_SECRET"; private static string domain = "https://<SharePoint_Domain>.sharepoint.com"; private static string siteUrl = "https://DOMAIN.sharepoint.com/sites/SITE"; private static string listName = "LIST_NAME"; static async Task Main(string[] args) { var accessToken = await GetAccessTokenAsync(); await GetSharePointListItemsAsync(accessToken); } private static async Task<string> GetAccessTokenAsync() { IConfidentialClientApplication app = ConfidentialClientApplicationBuilder.Create(clientId) .WithClientSecret(clientSecret) .WithAuthority(new Uri($"https://login.microsoftonline.com/{tenantId}")) .Build(); string[] scopes = { $"{domain}/.default" }; AuthenticationResult result = await app.AcquireTokenForClient(scopes).ExecuteAsync(); return result.AccessToken; } private static async Task GetSharePointListItemsAsync(string accessToken) { using HttpClient httpClient = new HttpClient(); httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", accessToken); var endpoint = $"{siteUrl}/_api/web/lists/getbytitle('{listName}')/items"; HttpResponseMessage response = await httpClient.GetAsync(endpoint); if (response.IsSuccessStatusCode) { var content = await response.Content.ReadAsStringAsync(); Console.WriteLine("List Items:"); Console.WriteLine(content); } else { Console.WriteLine($"Error: {response.StatusCode}"); Console.WriteLine(await response.Content.ReadAsStringAsync()); } } } }
ArunKumar Arumugam 60 Reputation points

2024-11-06T04:47:16.26+00:00

Hi Team,

Could you please share any updates?
ArunKumar Arumugam 60 Reputation points

2024-12-05T14:27:03.7966667+00:00

Hi Team,

Could you please share any updates?
ArunKumar Arumugam 60 Reputation points

2025-03-18T13:59:33.8633333+00:00

Hi Team,

Could you please share any updates on this?

Share via

Unable to Retrieve SharePoint List Items in .NET Core using SharePoint Rest API

Your answer