Error: 401 - FileOpenUserUnauthorized - Graph API - OneDrive personal account

Question

Hi,

We are integrated with OneDrive and Sharepoint to Read and Write Excel files using Graph API.

We are facing a problem, recently, in some users' accounts that use OneDrive with personal account type(not work and neither school).

Some operations return this error:

FileOpenUserUnauthorized: You do not have permission to open this file in the browser.

    Inner Error: unauthorizedUncategorized

    Required authentication information for the resource is either missing or invalid.

    

These endpoints do not work:

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

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

And this endpoint works:

https://graph.microsoft.com/v1.0/me/drive/root/children

The most basic test is to retrieve the files, get the Item ID, and try to read the worksheets.

• I am using the file owners accounts(They have permission)
• I am using XLSX files
• Personal accounts

I got the error using the API, but I tested directly through Graph API Explorer and the same error happened.

I tested with two accounts side-by-side, one works and the other does not.

Can someone help and give guidance, because the documentation and bugs found on the internet did not help.

I appreciate any help. Thank you.

User A:

User B:

Answer 1

I opened a new question about this problem, ı have too the same problem. You can follow the link below.

• Question Link: https://learn.microsoft.com/en-us/answers/questions/1688063/error-401-fileopenuserunauthorized-graph-api

Answer 2

Hi Libor,

I still did not find a solution. How I also tested directly in Graph API and got the same problem, I discarded it as an issue in my application. I am waiting for someone to say something that help me to solve this issue.

Thanks