Forum Discussion
MS Graph The request is unprocessable because it uses too many resources
I have added content types to the drives and try now to find a file based on a value in the column "MARIMPBELID" via a filter Odata request
drives/{drive-id}/list/items?$filter=fields/MARIMPBELID eq 100400
At one client I get a result: {"error":{"code":"notSupported","message":"The request is unprocessable because it uses too many resources","innerError":{"code":"tooManyResources","date":"2022-09-22T11:27:32","request-id":"xxx","client-request-id":"xxx"}}} 422 GET: https://graph.microsoft.com/v1.0/drives/xxxx/list/items?$filter=fields/MARIMPBELID eq 100400
Also, try adding indexing on "MARIMPBELID" column as mentioned here: Graph query on SharePoint Library with Paging
Documentation: Add an index to a list or library column
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Did you try adding a header prefer: HonorNonIndexedQueriesWarningMayFailRandomly to your request as mentioned at: Microsoft Graph returns 422 error on querying for specific SharePoint list items
Can you try and let us know if this works for you?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- ComNeuf8871Copper Contributor
ganeshsanap Thank you. I tried to add the Prefer header, but there is no change. Thanks
Also, try adding indexing on "MARIMPBELID" column as mentioned here: Graph query on SharePoint Library with Paging
Documentation: Add an index to a list or library column
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- ComNeuf8871Copper ContributorThank you I will try this and will give feedback