RAD to Tableau.knwf (93.1 KB)
Having an issue with trying to iterate and pull all 80k+ records from a SharePoint list. Even witt the iteration and incremental step up to large skipping of records, it seems that when you try to skip more than 40k records it times out or there is some general error with the graph API call.
Any suggestions? See attached workflow.
I am trying to implement a GetRequest instead that is pulling the first 1000 records, but the next link (odata.nextLink) that I get from that request, I am not sure how to embed it in a recurring loop. This would allow the next 1000 record to get pulled. I am also not 100% sure of how to configure the loop to know to stop – I assume once there are less than 1000 returns?
All – I found this reference and it seems to meet exactly what I need.
https://graph.microsoft.com/v1.0/sites/32a1019e-7f68-4ee9-b01c-72b7bcc77ff4/lists/a62be966-58fa-4322-85d8-ef298445be3c/items?expand=fields&top=999
Great to see you found a solution and shared it!
TL
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
