•   over 2 years ago

Accessing Excel Workbook returns “The resource could not be found.”

I'm struggling to connect to an Excel workbook through the graph API. What's strange is that I am able to connect to my OneDrive and query recent documents, and even find a recent Excel workbook & its ID (call this sales.xlsx). The graph explorer (https://developer.microsoft.com/en-us/graph/graph-explorer) is successfully querying OneDrive and the sales.xlsx.

From the application, I can successfully see recent documents in OneDrive (including sales.xlsx). It is only when I try to do a GET call from my application to see the data inside an Excel workbook there is an "itemNotFound" error.

A call from the app to query OneDrive is successful, such as: https://graph.microsoft.com/v1.0/me/drive/root/children

A call from the app to then query a workbook fails, such as: https://graph.microsoft.com/v1.0/me/drive/items/{:id}

More information on stackoverflow: https://stackoverflow.com/questions/47796702/accessing-excel-workbook-returns-the-resource-could-not-be-found

Has anyone experienced anything similar attempting to connect to the Graph API?

Comments are closed.