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 implmentation
it is throwing [ 429 Too Many Requests] errors when we try to update SP/Docuoment 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”,
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 implmentation it is throwing [ 429 Too Many Requests] errors when we try to update SP/Docuoment 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/11 = line item with “Client_No”: “5Z39896869”, Read More
