Forum Discussion
SharePoint REST: The attempted operation is prohibited because it exceeds the list view threshold
Help!!! REST API request data in SharePoint Online list. The list data more than 5k data, but the result of request don't more than 5k. SharePoint REST API return error as below: test-web-part...
Hi Linyu001
The first filter condition (ItemType eq '1') is likely returning more than 5000 items. This needs to always return less than 5000 items and only after that the other filter queries are applied.
Also, you may already be aware, but $top will only be applied after the filter so it does not prevent the list view threshold error
Thanks for your reply.
I know that your reply, but I want to find if there is any other solution for the filter.
I want to know if we can search the first filter more than 5000 but the hole filter less than 5000 items.
Thanks again!
I know that your reply, but I want to find if there is any other solution for the filter.
I want to know if we can search the first filter more than 5000 but the hole filter less than 5000 items.
Thanks again!
- Sorry the late reply, missed the notification from your reply.
Unfortunately this will cause an error and the first condition needs to return less than 5000 itemsJoel Rodrigues Is there still no way to avoid this error?
if I filter by text, 2 elements are returned to me and everything is ok, but if I search by date, it finds more than 5000 elements and I also get an error:- {"error":{"code":"-2147024860, Microsoft.SharePoint.SPQueryThrottledException","message":"The attempted operation is prohibited because it exceeds the list view threshold."}}