How do we fetch the latest data using ms graph usedRange API?

Question

How do we fetch the latest data using ms graph usedRange API?

Shubham Sharma 1

We have a workflow, where we do a PATCH request and update the data in an excel worksheet
The excel is having some formulas applied which changes the values in multiple places due to the PATCH request.

Now what we like to do is fetch the latest data from excel which is updated after the PATCH request.
* We want to have this data instantly after update.

Currently the graph api does not return this latest data instantly, instead it takes around 30-40 seconds to reflect the latest data.

If this can get quicker, it would help us.

Zehui Yao_MSFT 5,876 Reputation points

2022-08-10T07:16:57.44+00:00

Hi @Shubham Sharma , would you mind providing the formulas you are using?
Shubham Sharma 1 Reputation point

2022-08-10T07:59:43.46+00:00

@Zehui Yao_MSFT

it is happening on all type of formulas,
example: lets say we want C1 to have sum of A1 and B1, (=A1+B1).
Now our application push the data into A1 and B1 and try to fetch the resultant C1, it does not reflect instantly in graph api (worksheet - usedRange).
Instead if we fetch after 30-40 seconds, it gives us the updated values.

1 answer

Your answer

Zehui Yao_MSFT 5,876 Reputation points

2022-08-10T07:16:57.44+00:00

Hi @Shubham Sharma , would you mind providing the formulas you are using?
Shubham Sharma 1 Reputation point

2022-08-10T07:59:43.46+00:00

@Zehui Yao_MSFT

it is happening on all type of formulas,
example: lets say we want C1 to have sum of A1 and B1, (=A1+B1).
Now our application push the data into A1 and B1 and try to fetch the resultant C1, it does not reflect instantly in graph api (worksheet - usedRange).
Instead if we fetch after 30-40 seconds, it gives us the updated values.

Answer 1

Zehui Yao_MSFT 5,876

Hi @Shubham Sharma , as I can't sure your data vol, so I can't fully reproduce your question,
I recommend try use the session header workbook-session-id: {session-id} Enter non-persistent session mode by API:
POST https://graph.microsoft.com/v1.0/me/drive/items/{item-id}/workbook/createSession
to see if it can improve performance. Hope it can help you, best regards.

Documentation for your reference:
https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0&tabs=http

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.

Zehui Yao_MSFT 5,876 Reputation points

2022-08-22T08:17:42.273+00:00

@Shubham Sharma , Is the above suggestion useful to you?
Shubham Sharma 1 Reputation point

2022-08-22T09:10:43.653+00:00

@Zehui Yao_MSFT
My use case involves persisting the changes on to the file, so any user has the file open, the changes are reflected there.

please let me know if there are any solution to this while persisting the changes.
Zehui Yao_MSFT 5,876 Reputation points

2022-08-24T08:25:31.92+00:00

Hi @Shubham Sharma , I suggest opening a support ticket so that maybe the back-end engineer can make more suggestions from the back-end direction, wish you all the best.

Share via

How do we fetch the latest data using ms graph usedRange API?

1 answer

Your answer