0

Just want to know what is the Limits and Boundaries of SharePoint Online for Bulk operations. Is there any authentic document I can refer? I am trying to insert 20,000 items with 5 text fields in a batch of 100. sometimes it throws Error "The Operation has timed out" I am using jquery + rest api to perform this bulk operation

  • Are you doing this by physically copy and pasting into the list, or are you scripting this? – lazoDev May 3 '18 at 11:26
  • I am using JSOM Script – Vikas Sharma May 6 '18 at 7:24
1

This does not give you the limits but maybe a solution for your problem.

The bulk limits for SharePoint 2013 is 100 items per operation so i guess it is around that number in Online aswell. SharePoint 2013 Software boundaries

enter image description here

But to resolve your problem try extending the RequestTimeout for your context.

MSDN article explaining RequestTimeout.

But as you are using jQuery and the rest api try setting the timeout property on the ajax call. jQuery ajax documentation

  • will try it and revert about the results – Vikas Sharma May 6 '18 at 7:32
  • This is the correct answer. You need to reset the browser threads which are causing the timeout on the browser. Use the setTimeout(function(){}, 100); to break up the upload. I would also put some type of modal wait function to lock the page because it will take some time to load everything. – lazoDev May 7 '18 at 10:55
  • @VikasSharma did you have any success trying out my suggested answer? Also I have updated my answer with a bit more information. – Johan Brännmar May 9 '18 at 9:49
  • For Jquery it did not work. Tried time out function but sometimes it gives the same error – Vikas Sharma May 21 '18 at 11:33
0

Are you doing real bulk requests, or do you make a request per item?

If it is the later, try to schedule your requests and give SP some time. I don't think there are official hard numbers, since there are a lot of relevant factors that are not limited to the service for a timeout to occur.

Had the same problem with general CRUD operations. I would suggest to leave some time between any two requests and don't bulk transfer anything.

(real bulk (batch) requests are possible and shouldn't have this problem. They are available in newer SP installations, but I don't know about their limits. Didn't find a lot of documentation, although that might have been improved.)

  • I agreed with your answer. I didn't understand the meaning of real bulk batch ? What do you mean by this ? Synchronous code? – Vikas Sharma May 6 '18 at 7:30
  • The "normal" rest operation targets just a single item with a specific itemID. So to update a list with n items, you would have to send n requests. A single bulk request would allow you to create, update or delete n items within a single request. That has the advantage, that there are no further timeouts required. All the payload of the operations for many items is contained in that single request. – Anonymous May 7 '18 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.