I would like to access/manipulate Excel workbooks stored in OneDrive Personal using the Microsoft Graph REST API. I am able to access/manipulate Excel workbooks stored in OneDrive for Business.
I am able to authenticate my OneDrive Personal account (get access tokens, permission scopes, etc.) and I am able to do other (non-Excel-related) Graph REST operations, such as view file properties.
The Microsoft Graph Explorer https://graph.microsoft.io/en-us/graph-explorer# only supports OneDrive for Business (not OneDrive Personal).
Here https://graph.microsoft.io/en-us/docs/api-reference/v1.0/resources/excel, it says "…read and modify Excel workbooks stored in OneDrive, SharePoint, or other supported storage platforms". Could they really mean "OneDrive for Business"?
When I try to access anything Excel-workbook-related (on OneDrive Personal), such as:
POST /{version}/me/drive/items/01CYZLFJGUJ7JHBSZDFZFL25KSZGQTVAUN/workbook/createSession
It always returns MethodNotAllowed:
{"error": {"code": "MethodNotAllowed","message": "Method not allowed.","innerError": { "request-id": "9c1d81ec-4300-4e8b-b453-82cd6caca00e", "date": "2016-10-19T01:25:20"} } }
I tried {version} v1.0 and beta.
Does the Graph Excel REST API support OneDrive Personal? If not, when might it? I can't find any documentation on this. I realize Graph just recently started supporting OneDrive Personal via Azure AD 2.0 Endpoint, so perhaps there's just a delay in supporting Excel?
The functionality to access Excel REST API on workbooks in OneDrive personal is not available at the moment. We are working on enabling this in the near future.