Read a SharePoint list using SharePoint API

Question

Read a SharePoint list using SharePoint API

Pavithra E (CLEARWATER GROUP LLC) 0 Microsoft External Staff

1 answer

Your answer

Answer 1

RaytheonXie_MSFT 40,471 Microsoft External Staff

Hi @Pavithra E (CLEARWATER GROUP LLC),

There are two different api to get list items. Please refer to the following samples

1.Rest api

GET 
https://{site_url}/_api/web/lists/GetByTitle('Test')/items 
Authorization: "Bearer " + accessToken 
Accept: "application/json;odata=verbose"

Please refer to the document for more details

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest#working-with-list-items-by-using-rest

2.Graph api

GET /sites/{site-id}/lists/{list-id}/items

For reference

https://learn.microsoft.com/en-us/graph/api/listitem-list?view=graph-rest-1.0&tabs=http

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Pavithra E (CLEARWATER GROUP LLC) 0 Reputation points Microsoft External Staff

2023-12-13T08:16:24.5633333+00:00

I have tried using the Rest api to get the list. Getting the bearer token using the AAD client id and client secret, has sites.selected permission

But getting the below error,
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2023-12-18T06:29:53.3333333+00:00

Hi @Pavithra E (CLEARWATER GROUP LLC),

Per my research, sites.selected permission doesn't support rest api, you could only use the aad app only to call graph api. If you want to use rest api, I would recommend you to register a sharepoint app only to grant access.
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2023-12-20T06:30:20.1533333+00:00

Hi @Pavithra E (CLEARWATER GROUP LLC),

Would you tell me whether your issue has been resolved or have any update? If you have any questions or progress, you can contact me in time.

Share via

Read a SharePoint list using SharePoint API

1 answer

Your answer