c# - Microsoft Graph REST API v1.0 Get listItem(10.000.000 List Item from a SharePoint list)

Question

I am using Microsoft solution(Ref. Link: https://docs.microsoft.com/en-us/graph/api/listitem-get?view=graph-rest-1.0&tabs=csharp) for our enterprise software(CSOM+C#). We have more than 10.000.000 item in our SharePoint List and we would like to retrieve all of them to do specific transactions(ex: compare items from SharePoint List with items from a CSV-File(File Server)). How we can do it?

I am asking for your valuable solutions/suggestions.

Best, Sezgin

question from:https://stackoverflow.com/questions/65843599/microsoft-graph-rest-api-v1-0-get-listitem10-000-000-list-item-from-a-sharepoin

Answer 1

First you can use Microsoft Graph API's pagination to get the good number of items in it. Then get the data, compare the SharePoint list with items from a csv file based on your business logic.