Access Sharepoint list using client Id and Client secret in asp.net C#

Question

Currently, I'm able to access sharepoint list using user id and password as given below. But would like to understand on how can i access the list using Client Id and Client secret ?

string siteUrl = "https://xyz.sharepoint.com/sites/MyList/";
ClientContext clientContext = new ClientContext(siteUrl);
string username = ConfigurationManager.AppSettings["username"];
string password = ConfigurationManager.AppSettings["password"];
System.Security.SecureString passWord = new System.Security.SecureString();
foreach (char c in password.ToCharArray()) 
{    
    passWord.AppendChar(c);
}

clientContext.Credentials = new SharePointOnlineCredentials(username, passWord);
Web oWebsite = clientContext.Web;
ListCollection collList = oWebsite.Lists;
clientContext.Load(collList);
clientContext.ExecuteQuery();

Solution

You can use the GetAppOnlyAuthenticatedContext method of PnP CSOM core.

After that you can use the code as below:

string siteUrl = "https://xyz.sharepoint.com/sites/MyList/";
string clientId = "<client-id>";
string clientSecret = "<client-secret>";

using (var clientContext = new AuthenticationManager().GetAppOnlyAuthenticatedContext(siteUrl,clientId,clientSecret))
{       
    Web oWebsite = clientContext.Web;
    ListCollection collList = oWebsite.Lists;
    clientContext.Load(collList);
    clientContext.ExecuteQuery();
}

To add PnP CSOM core, go to your project references > manage nuget packages.

Add the SharePointPnPCoreOnline package.

References - Authenticate SharePoint using PnP Authentication Manager

Expose on public web your SharePoint Online information

Comments

[Dnyaneshwar Suryawanshi]

I am using same code but getting below error : System.TypeInitializationException: The type initializer for 'OfficeDevPnP.Core.Utilities.TokenHelper' threw an exception. ---> System.TypeLoadException: Could not load type 'System.Web.Configuration.WebConfigurationManager' from assembly 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. at OfficeDevPnP.Core.Utilities.TokenHelper..cctor() Please help me on this.

[Steve Friedl]

FWIW, the SharePointPnPCoreOnline package seems to be retired; using PnP.Framework is the new version, and GetACSAppOnlyContext replaces GetAppOnlyAuthenticatedContext.

[Ishaan]

I am getting "The remote server returned an error: (403) Forbidden." while doing clientContext.ExecuteQuery(). Any Idea?

[HO LI Pin]

obviously SPO is complaining about access , make sure client ID have sufficient access to the site collection \ Site \ List that you are try to get data . I am not sure how to setup the client ID because is my IT setup for me , but this article shall tell you the relevant info how to setup client ID with full control access , docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/…

[zainul]

Can we get token by using Client Id, Secret and use it ?

[san]

I am getting "No such host is known. No such host is known." after ExecuteQuery(). I am sure I've given correct Url and ClientId & Secert. Any tips?