1

I am querying list using REST.

API: siteURL = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('Test')/items?$top=5000&$filter=((BBEmail eq '"+_spPageContextInfo.userLoginName+"')or(OpexCatalystEmail eq '"+_spPageContextInfo.userLoginName+"')or(PEGLeadEmail eq '"+_spPageContextInfo.userLoginName+"'))&$orderby=Modified desc";

The fields below are indexed.

  • BBEmail
  • PEGLeadEmail
  • OpexCatalystEmail
  • Modified

Still getting the threshold error when hitting the api.

{"readyState":4,"responseText":"{\"error\":{\"code\":\"-2147024860, Microsoft.SharePoint.SPQueryThrottledException\",\"message\":{\"lang\":\"en-US\",\"value\":\"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\"}}}","responseJSON":{"error":{"code":"-2147024860, Microsoft.SharePoint.SPQueryThrottledException","message":{"lang":"en-US","value":"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."}}},"status":500,"statusText":"error"}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.