SharePoint Online Access List Item by ID using Graph API


In this page, we will see How to access SharePoint Online List Item by ID using Graph API.

Below screenshot is from Graph Explorer (Graph Explorer | Try Microsoft Graph APIs - Microsoft Graph). 

I have formatted the Graph API url and executed from Graph Explorer and below is the output.




Graph API url:

https://graph.microsoft.com/v1.0/sites/<site-id>/lists/<list-name>/Items?expand=fields(select=Id,Column1,Column2,Column3)&filter=fields/ID eq <item-id>

we have to use header key value (highlighted in green arrow on above screenshot) as because filter works only on indexed columns

Header: Prefer 
Value: HonorNonIndexedQueriesWarningMayFailRandomly

(Replace the site-id, list-name, column name, item-id with your actual values.)

On executing above API with actual values, response will be returned with respective list item

However, instead of filter by ID, we can directly access the particular list item by passing ID like below

And this is the Microsoft Recommended Approach in terms of performance


Passing the item ID in-line with the graph API will get the respective SharePoint List Item.
And in this way we do not need to use header and value.

Graph API url:

https://graph.microsoft.com/v1.0/sites/<site-id>/lists/<list-name>/Items/<item-id>?expand=fields(select=Id,Column1,Column2,Column3)


Incase, if you want to execute in C# you can try like below

GraphServiceClient graphClient = new GraphServiceClient(authProvider);

var listItem = await graphClient.Sites[<SiteID>].Lists["<ListName>"].Items["<ItemID>"]
    .Request()
    .GetAsync();

Happy PC (Programming / Configuring)

Comments

Post a Comment

Popular posts from this blog

In C# CSOM How to Delete Folders Recursively, Sub-Folders, Files in SharePoint Online Document Library

Image
In this article we will see how to delete Root folder, sub-folders, files in SharePoint Document Library.  Here I have given snippet by hardcoding (not recommended) one folder name "TestFolder1".  However you can use loop statement and iterate list of root folder names.  var clientContext = GetClientContextWithAccessToken(siteUrl, accessToken); Web web = clientContext.Web; clientContext.Load(web); clientContext.ExecuteQuery(); //Here you can add for loop with list of root folder names and iterate //Start of for loop string folderPath = "/sites/contoso5/LibraryName/ TestFolder1 "; //Pass the folder name dynamically Folder folder = clientContext.Web.GetFolderByServerRelativeUrl(folderPath); clientContext.Load(folder, folderitem => folderitem.Properties, folderitem => folderitem.Name, folderitem => folderitem.Files); clientContext.ExecuteQuery(); DeleteFolderRecursive(folder); //Call method to delete subfolders and files. folder.DeleteObject(); clientContext.E
Read more

How Get, Set, Delete Permission on SharePoint Online Site using Graph API

Image
How to get SharePoint Site ID [GET] https://graph.microsoft.com/v1.0/sites?search=contoso5 How to set SharePoint Site Permission only to selected App (AAD App reg) [POST] https://graph.microsoft.com/v1.0/sites/demotenant.sharepoint.com,4465d2n7-e7c4-40df-abfa-364106bbc502,57836gs4-b14f-4061-ba63-fdb0c2a923b6/permissions Request Body: ============ {     "roles": [         "write"     ],     "grantedToIdentities": [         {             "application": {                 "id": "3795d2n7-fa6d-4203-9076-5c8898799cb8",                 "displayName": "DemoTenantAADApp"             }         }     ] } How to get SharePoint Site Permission [GET] https://graph.microsoft.com/v1.0/sites/demotenant.sharepoint.com,4465d2n7-e7c4-40df-abfa-364106bbc502,57836gs4-b14f-4061-ba63-fdb0c2a923b6/permissions [Delete] How to Delete Selected SharePoint Site Permission https://graph.microsoft.com/v1.0/sites/demotenant.sharepoint.
Read more

What is SharePoint online default authentication method? And which credential flow it is using to authenticate?

Image
  Here I have explained SharePoint online default authentication method and which credential flow it is using to authenticate: The default authentication method for SharePoint Online is OAuth 2.0 and it uses the authorization code grant flow to authenticate users . This means that the user first logs in through an identity provider (such as Microsoft Account or Azure Active Directory) and then receives an authorization code which is then exchanged for an access token. This access token is then used to access the SharePoint Online resources on behalf of the user. Happy PC (Programming / Configuring)
Read more