Forum Discussion
Graph API - Sharepoint Bulk update - best practice ??
Hi Experts,
I am looking for best practices for implementing a project using Graph API and sharepoint
"template": "documentLibrary"
We have 40K records incoming in the below format as json,
Need to consume it and update the corresponding line-item based on the client_no.
The reason we are using the approach is, in the previous implementation
it is throwing [ 429 Too Many Requests/Throttling] errors when we try to update SP/Document template with 40k records.
Any thoughts/suggestions highly appreciated
[
{
"Client_No": "5Z39896869",
"Case_Name": "CON-ESBTest001",
"DeptName": "veteneary",
"Open_Date": "02/24/2016",
"Initial__Date": "04/12/2016"
},
{
"Client_No": "4Z40990233",
"Case_Name": "Test Test",
"DeptName": "vet",
"Open_Date": "02/16/2017",
"Initial__Date": "04/11/2017"
},
{
"Client_No": "0Z42299803",
"Case_Name": "ESBTest002",
"DeptName": "department",
"Open_Date": "07/07/2020",
"Initial__Date": "10/21/2020"
}
]
PATCH - https://graph.microsoft.com/v1.0/sites/xyz.sharepoint.com:/sites/testsplist:/lists/9b2e99d1-c067-7654-bcb5-b5b00c65432/items/1
1 = line item with "Client_No": "5Z39896869",
Note : This is a recurring activity, not same number of records sometimes it can be less or more.