fetch particular list data from share point using dot net core web api

Still I could not find any authentic source for get SharePoint CSOM with asp.net core. however you can handle the situation in two ways.

1. use .net standard library for SharePoint Data Access and refer this class in your asp.net core

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/using-csom-for-dotnet-standard

ClientContext sample

public ClientContext GetContext(Uri web, string userPrincipalName, SecureString userPassword)
{
var context = new ClientContext(web);
context.ExecutingWebRequest += (sender, e) =>
{
string accessToken = EnsureAccessTokenAsync(new Uri($"{web.Scheme}://{web.DnsSafeHost}"), userPrincipalName, new System.Net.NetworkCredential(string.Empty, userPassword).Password).GetAwaiter().GetResult();
e.WebRequestExecutor.RequestHeaders["Authorization"] = "Bearer " + accessToken;
};
return context;
}

2. Another way is to use graph api which is available for sharepoint online and is recommended.

Retrieve items from a SharePoint list - Microsoft Graph v1.0 | Microsoft Docs

Regards

Rijwan

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
Still I could not find any authentic source for get SharePoint CSOM with asp.net core. however you can handle the situation in two ways.

1. use .net standard library for SharePoint Data Access and refer this class in your asp.net core
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/using-csom-for-dotnet-standard
ClientContext sample
public ClientContext GetContext(Uri web, string userPrincipalName, SecureString userPassword)
        {
            var context = new ClientContext(web);

            context.ExecutingWebRequest += (sender, e) =>
            {
                string accessToken = EnsureAccessTokenAsync(new Uri($"{web.Scheme}://{web.DnsSafeHost}"), userPrincipalName, new System.Net.NetworkCredential(string.Empty, userPassword).Password).GetAwaiter().GetResult();
                e.WebRequestExecutor.RequestHeaders["Authorization"] = "Bearer " + accessToken;
            };

            return context;
        }
2. Another way is to use graph api which is available for sharepoint online and is recommended.
Retrieve items from a SharePoint list - Microsoft Graph v1.0 | Microsoft Docs

Regards
Rijwan
Satya Karki5y ago
Hi, you refer to these links

https://www.c-sharpcorner.com/UploadFile/93cb27/retrieve-sharepoint-app-host-web-list-items-in-sharepoint-ho/
https://www.c-sharpcorner.com/blogs/retrieve-sharepoint-list-items-using-rest-api
Jignesh Kumar5y ago
Hi Siva nathan,

Please refer this link,
https://www.c-sharpcorner.com/blogs/retrieve-sharepoint-list-items-using-rest-api