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

Question

I am using caml query as below:&nbsp;"&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;And&gt;&lt;Eq&gt;&lt;FieldRef Name = 'NumericRecordId'/&gt;&lt;Value Type = 'Integer'&gt;xxxxxxx&lt;/Value&gt;&lt;/Eq&gt;&lt;Eq&gt;&lt;FieldRef Name = 'ContextId'/&gt;&lt;Value Type = 'Integer'&gt;xxxxxx&lt;/Value&gt;&lt;/Eq&gt;&lt;/And&gt;&lt;/Where&gt;&lt;View&gt;&lt;OrderBy&gt;&lt;FieldRef Name='NumericRecordId' Ascending='False' /&gt;&lt;/View&gt;&lt;/Query&gt;&lt;ViewFields&gt;&lt;FieldRef Name='Title' /&gt;&lt;/ViewFields&gt;&lt;RowLimit&gt;100&lt;/RowLimit&gt;&lt;/View&gt;"This works fine for records less than 5000 in my document library. But once it exceeds 5000 i get threshold error.ContextId and NumericRecordId are Indexed columns. I tried many different online solutions but not able to get through this. Any help will be much appreciated. Thanks

jcgonzalezmartin · Answer

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

ankush_daga · Answer

jcgonzalezmartin&nbsp; Thanks for your suggestion . can you just provide an&nbsp; example on how to call them with multiple parameters and integrate them?&nbsp;&nbsp;

ankush_daga · Answer

jcgonzalezmartin&nbsp; 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.&nbsp;

sudharsan k · Answer

Ankush_Daga&nbsp;Have you tried using PnPJS with paged items method. Please refer the below linkhttps://pnp.github.io/pnpjs/sp/items/#get-paged-items&nbsp;Please refer the below link using Search API using PnPJShttps://pnp.github.io/pnpjs/sp/search/#paging-with-searchresultsgetpage&nbsp;Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue-Sudharsan K...

ankush_daga · Answer

Sudharsan K&nbsp; 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.

Forum Discussion

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

8 Replies

Resources