Forum Discussion
SharePoint Online - Large List | REST API Issue
Hi, I have a list which has around 28K items. We have a dashboard displaying data from this list. By default, we are fetching data for the past 120 days, and it perfectly worked fine. Today,...
What is the REST API end point you are using? What are the filters you are using in the API call? Are you using $top to in your API call?
Make sure your one API call returns less than 5000 records after adding filtering conditions.
Try adding indexing on list columns you are using for filtering/sorting in your API call. Follow: Add an index to a SharePoint list or library column
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.