Using SharePoint REST API on large lists (over 5K data on list)‎

%3CLINGO-SUB%20id%3D%22lingo-sub-1292960%22%20slang%3D%22en-US%22%3EUsing%20SharePoint%20REST%20API%20on%20large%20lists%20(over%205K%20data%20on%20list)%E2%80%8E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1292960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20I%20have%20developed%20a%20web%20part%20that%20uses%20the%20SharePoint%20REST%20API.%20Web%20part%20was%20working%20well%20until%20the%20data%20of%20my%20list%20began%20to%20exceed%205K%20of%20data.%20I%20understand%20I%20am%20exceeding%20the%20list%20view%20threshold%20(LVT).%20I%20have%20optimized%20the%20query%20and%20I%20am%20only%20using%20indexed%20columns.%20It%20is%20my%20understanding%20that%20this%20should%20work.%20This%20is%20the%20query%3A%20https%3A%2F%2F%3CMYDOMAIN%3E%2Fsites%2F%3CMYSITE%3E%2F_api%2FWeb%2FLists%2FGetByTitle('Projects%2520Database')%2FItems%3F%24select%3DWork_x0020_Type%2CAssigned%2FTitle%2CAssigned%2FEMail%2CRemaining_x0020_Effort%26amp%3B%24expand%3DAssigned%26amp%3B%24orderby%3DAssigned%26amp%3B%24top%3D3000%26amp%3B%24filter%3D(Assigned%2520ne%2520null)%2520and%2520((Project_x0020_Status%2520ne%2520null)%2520and%2520(Project_x0020_Status%2520ne%2520%2527Submitted%2527)%2520and%2520(Project_x0020_Status%2520ne%2520%2527Complete%2527)%2520and%2520(Project_x0020_Status%2520ne%2520%2527Cancelled%2527))%3C%2FMYSITE%3E%3C%2FMYDOMAIN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I have developed a web part that uses the SharePoint REST API. Web part was working well until the data of my list began to exceed 5K of data. I understand I am exceeding the list view threshold (LVT). I have optimized the query and I am only using indexed columns. It is my understanding that this should work. This is the query: https://<mydomain>/sites/<mysite>/_api/Web/Lists/GetByTitle('Projects%20Database')/Items?$select=Work_x0020_Type,Assigned/Title,Assigned/EMail,Remaining_x0020_Effort&$expand=Assigned&$orderby=Assigned&$top=3000&$filter=(Assigned%20ne%20null)%20and%20((Project_x0020_Status%20ne%20null)%20and%20(Project_x0020_Status%20ne%20%27Submitted%27)%20and%20(Project_x0020_Status%20ne%20%27Complete%27)%20and%20(Project_x0020_Status%20ne%20%27Cancelled%27))

0 Replies