SharePoint REST limitation? – SharePoint Stack Exchange

To all SharePoint folks,

Have anyone noticed, when we apply OR operator in REST API filter having more than 5000 List items, it will throw error code 500 even if I return single item.

FYI, All columns are indexed.

For e.g.

site/_api/web/list/getbytitle(<list title>)/items?$Select=Title&$filter=Author eq <email> OR Column2 eq <some value>&$top=1

Even I checked with Microsoft team and they were surprised and said it’s part of core logic.