Create support for the long-running operations for the “calculate” (Excel) API in Microsoft Graph

Create support for the long-running operations for the “calculate” (Excel) API in Microsoft Graph
23

Upvotes

Upvote

 Apr 11 2022
2 Comments (2 New)
New

Create support for the long-running operation pattern for the “calculate” (Excel) API in Microsoft Graph. 

Comments
Brass Contributor

Some Graph operations take an indeterminate amount time to complete. It is easy to hit timeout while waiting for the response to these requests. To resolve this issue, Microsoft provides the long-running operation pattern. When you use this pattern, you don't need to worry about the timeout for the request. Unfortunately, the long running operation pattern doesn’t yet support all Excel-related operations. Specifically, the Calculate operation isn’t yet supported. Recalculating a large and/or complex Excel workbook frequently times out, making subsequent operations (save as PDF, reading values from cells, etc.) unreliable or impossible.

Iron Contributor

Sometimes we have to find a solution even some proprietary API wont work.

 

I would say this is a valid option and my suggestion:

 

"Durable Functions is an extension of Azure Functions that lets you write stateful functions in a serverless compute environment. The extension lets you define stateful workflows by writing orchestrator functions and stateful entities by writing entity functions using the Azure Functions programming model. Behind the scenes, the extension manages state, checkpoints, and restarts for you, allowing you to focus on your business logic."

 

Create a long-running serverless workflow with Durable Functions - Learn | Microsoft Docs