0

When using the Microsoft Graph API to query the contents of a worksheet via the usedRange endpoint: https://learn.microsoft.com/en-us/graph/api/worksheet-usedrange?view=graph-rest-1.0&tabs=http

When I edit a cell on the spreadsheet via the browser app and then call that endpoint, the contents of that cell isn't present until after a small delay, usually around 5s. In the worksheet itself the header says that it has been saved, however that isn't immediately present when called via the endpoint.

Is there a method to guarantee that when calling the Graph API endpoint that I'm getting the absolute latest contents, or is there a way to force a save via GraphAPI endpoints before querying for the contents of a worksheet?

I tried refreshSession but that had the same issue, I expect that as soon as it says content saved on the excel sharepoint browser app, the results will be the same as the content returned by usedRange

Owen Zhang
  • 11
  • 2
  • Probably same issue but without any response why there is so high latency for Excel endpoints. https://stackoverflow.com/questions/74462628/editing-excel-365-by-hand-and-reading-with-graph-api-latency – user2250152 Jan 05 '23 at 07:18

0 Answers0