FileOpenUserUnauthorized - Cannot access my own files on Graph

Question

I am trying to access an Excel workbook in my drives root through the Microsoft Graph Explorer. I can access the DriveItem by using:

https://graph.microsoft.com/v1.0/me/drive/items/{id}/

and see myself as the owner of the file, but when I use:

https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets

I get the "FileOpenUserUnauthorized" error. How can that be?

Thanks for your help!

Echologr

Answer 1

Hi @Echologr

According to the Graph API documentation, the required permission to access the /workbook/worksheets endpoint is Files.ReadWrite, grant that permission in Graph Explorer.

My test results are as follows:

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.