How to fix MaxRequestDurationExceeded" or "gatewayTimeoutUncategorized" in microsoft graph API?

Question

Hi,

I am trying to read an excel sheet (~46 MB). When I try to read it using the api I get error code"MaxRequestDurationExceeded". I know that there are suggested ways to batch the requests, but how will you batch a request to read an excel sheet?

-Preeti

Answer 1

Hello Singh, Preeti,

Thanks for reaching out!

The errors "gatewayTimeoutUncategorized" defines service wasn’t able to complete the request within the time limit.

You can refer below screenshots.

For handling the errors like "gatewayTimeoutUncategorized" which is fall under second-level error codes, please refer the link.

JSON batching allows you to optimize your application by combining multiple requests (up to 20) into a single JSON object. Please refer the below screenshot of batch request for excel API.

POST https://graph.microsoft.com/v1.0/$batch

Please refer the below link for Json Batching.

Batching

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.

Answer 2

Hi @Singh, Preeti , I can reproduce your problem locally, I think the error is probably caused by the large file (I read almost 40MB of the file).

Then I can solve this problem by using workbook session.

So, you can also try this method, because the workbook-session-id: {session-id} header can improve performance. This is explained in the documentation.

The way it was created is shown in my screenshot below.

For more information, you can refer to the documentation:

https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0&tabs=http

https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

Hope that can help you. Best Wishes.

---

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.