Sharepoint Office 365 Important Bulk Operation using REST API with SPRest utility.txt

Agenda - Sharepoint Online/ Office 365Important tips for bulk operation

1. Bulk Insert Into Sharepoint List

for(var i=11;i<=20;i++){util.Utils.ListItem.Add({listName:"BulkOperation",data:{Title:"Test"+i,Department:"IT_Computer"}}).then(r=>console.log(r))}

2. Bulk Update into Sharepoint List

body=	{"itemIds":[11,12,13,14,15,16,17,18,19,20],"formValues":[{"FieldName":"Title","FieldValue":"Bulk_Update-Title"},{"FieldName":"Department","FieldValue":"HR"}]}

 var _payloadOptions = {
                method: "GET",
                body: undefined,
                headers: {
                    credentials: "include",
                    Accept: "application/json; odata=verbose",
                    "Content-Type": "application/json; odata=verbose"
                }
            };
_payloadOptions.method="POST";

//Generate Request digest and store to variable
util.Utils.getRequestDigest().then(r=>console.log(r))

_payloadOptions.headers["X-RequestDigest"]=reqDigest
	
_payloadOptions.body=JSON.stringify(body);

fetch("https://brgrp.sharepoint.com/_api/web/Lists/GetbyTitle('BulkOperation')/BulkValidateUpdateListItems()",_payloadOptions).then(r=>r.json()).then(r=>console.log(r))

3. Bulk Delete from Sharepoint List

for(var i=11;i<=20;i++){util.Utils.ListItem.Delete({ Id:i,listName:"BulkOperation"}).then(r=>console.log(r))}