I have a list in SharePoint online having more than 5000 items. How to deal it with JSOM or REST API.

  • This can be done with proper filtering/indexing. What do you do with JSOM / REST api? Please add more info. – M.P. Feb 5 '20 at 11:31
  • Please refer this support.office.com/en-us/article/… – Jefin Mathew Feb 5 '20 at 11:43
  • Or just google the exact verbiage in your question. There are countless articles, posts, and advice already published over the years dealing with List View Threshold. If you need advice for a very specific scenario that has not already been published about, then you will need to give us those specifics. – willman Feb 5 '20 at 13:35

In general, any query in JSOM/CSOM can work around the List View Threshold by setting the RowLimit to some number under 5,000. If you actually need to retrieve more than 5,000 of the items, you will need to use the ListItemCollectionPosition to "page" through the results in "chunks" so that any given queryExecute never exceeds the List View Threshold.


Suggest to create index column and then use it in Rest API endpoint or Caml, please check the similiar question here:

SharePoint Online: REST API for List, calling Filters and limit the return items

Another suggestion is to check the ItemsCount in the logic and use the $top parameter in Rest to control the items returned less than 5000:

How to read more than 5000 list items in office 365/ SharePoint 2013

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.