Microsoft Graph returns 422 error on querying for specific SharePoint list items

Question

I am querying a SharePoint list to display all the list items using the following URL:

https://graph.microsoft.com/v1.0/sites/{site_id}/lists/{list_id}/items?expand=fields&$filter=startswith(fields/field_name,'field_value')

AND

https://graph.microsoft.com/v1.0/sites/{site_id}/lists/{list_id}/items?$filter=fields/Field_Title eq 'Field_Value'

Both these endpoints are returning the following response:
422 Unprocessable Entity

{
"error": {
"code": "notSupported",
"message": "The request is unprocessable because it uses too many resources",
"innerError": {
"code": "tooManyResources",
"date": "2022-07-01T08:26:10",
"request-id": "ddf5d7c7-b4a2-4013-b942-ae31a1676d8c",
"client-request-id": "ddf5d7c7-b4a2-4013-b942-ae31a1676d8c"
}
}
}

Could you please help me resolve this and understand why this is happening? Because just this morning the APIs were working fine and returning the required response.

Answer 1

Hi @Harshita V , We've figured out that you can add a header: prefer: HonorNonIndexedQueriesWarningMayFailRandomly to make the filter run successfully.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.