Forum Discussion

Copper Contributor

Apr 06, 2020

The attempted operation is prohibited because it exceeds the list view threshold

I am using caml query as below: "<View><Query><Where><And><Eq><FieldRef Name = 'NumericRecordId'/><Value Type = 'Integer'>xxxxxxx</Value></Eq><Eq><FieldRef Name = 'ContextId'/><Value Type = 'Inte...

developer

jcgonzalezmartin

MVP

Apr 07, 2020

Well, what I would recommend here is to use search API instead of doing a CAML Query

Ankush_Daga

Copper Contributor

Apr 12, 2020

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.

Sudharsan K
Iron Contributor
Apr 13, 2020
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...
- Ankush_Daga
  Copper Contributor
  Apr 13, 2020
  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.
  - Sudharsan K
    Iron Contributor
    Apr 13, 2020
    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/