Forum Discussion

anilalkg's avatar
anilalkg
Copper Contributor
Oct 16, 2024

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 r
ecurring activity, not same number of records sometimes it can be less or more.

No RepliesBe the first to reply

Resources