Error: 401 - FileOpenUserUnauthorized - Graph API

Question

When I make a request to this endpoint in the doc then ı get the following error and ı am sure, ı have the necessary "permissions" for the request.

Error and Message:

• Error: 401 - FileOpenUserUnauthorized
• Message: You do not have permissions to open this file in the browser.

---

I did some research and the same problem is mentioned in forums here:

• https://learn.microsoft.com/en-us/answers/questions/1656673/error-401-fileopenuserunauthorized-graph-api-onedr
• https://learn.microsoft.com/en-sg/answers/questions/1624742/fileopenuserunauthorized-error-for-excel-api

Answer 1

Same for me, my app runs without problem for years, and this morning got this error. My query is : https://graph.microsoft.com/v1.0/me/drive/items/E97916D0B5077B6C!4981/workbook/worksheets('Documents')/usedRange.

Not working in MS Graoh Explorer either.

I guess the problem is on Microsoft side. Any clues ?

Answer 2

I am running into this for personal OneDrive accounts. I consented Files.ReadWrite but still running into the same issue.

"https://graph.microsoft.com/v1.0/me/drive/items/<id>/" works to get Excel workbook but "https://graph.microsoft.com/v1.0/me/drive/items/<id>/workbook/worksheets" show following error.

Any help here would be appreciated.

Answer 3

Did you find a solution? My app also was running fine and than get this error.

Answer 4

I had the same problem. I solved it by accessing One Drive, then opening the Excel file in the browser. Then I called the /workbook/worksheets API and it worked. I also had the problem of the /search api returning an empty list. And I tried searching for a file by keyword on the One Drive web (remember to press Enter to display the results). And this api also worked again.