Forum Discussion
The attempted operation is prohibited because it exceeds the list view threshold
jcgonzalezmartin I tried with the search api's as well and again ran into same issue after 5000 records as api returns 500 (Internal Server Error) while applying filters.
Ankush_Daga Have you tried using PnPJS with paged items method. Please refer the below link
https://pnp.github.io/pnpjs/sp/items/#get-paged-items
Please refer the below link using Search API using PnPJS
https://pnp.github.io/pnpjs/sp/search/#paging-with-searchresultsgetpage
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...
Sudharsan K Thank for your response but this seems to be through javascript. I am making a call to search api through c# desktop application. So it would not be a feasible solution for me.
Ankush_Daga Can you refer the below links and let me know if it suits you.
https://www.codeproject.com/Articles/281693/Paging-SharePoint-List-Items
https://keepitsimplekarthik.com/sharepoint/listitemcollectionposition-and-pageinfo/
Sudharsan K I have already tried using 'ListItemCollectionPosition' . It works fine with records less than 5000 but once my document library exceeds files count then it throws the threshold error. So without removing 'Where' clause from the query or 'Filters' from the api's it throws an error (possibly due to threshold limit). If i remove this where clause or filter then it works fine with row limit as well as pagination. But this is again a perfromance hit as It will be bringing all the records rather than filtering them. So i am looking for some approach in which it works with where (caml query) or filter (Rest api's).