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
Perfect! It worked