Graph API - Sharepoint - POSTMAN - Could not obtain a WAC access token

Question

when trying to access Sharepoint workbook receiving the error "403 forbidden Could not obtain a WAC access token". However able to get the items in the sharepoint site.

Azure AD permissions:
"roles": [
"Sites.Read.All",
"User.Read.All",
"Files.Read.All"
],

Answer 1

Hi @Gopi, Radhika ，

I could replicate the issue if the exvel file is .xls extension. So I think your excel file is .xls file.

However, the Excel REST API supports only Office Open XML file formatted workbooks. The .xls extension workbooks are not supported.

Please refer to this article for more: https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

Answer 2

Hi @Gopi, Radhika ，

Per my test, I could aceess the workbook in SharePoint successfully.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

I have set the following permissions in Azure AD.

But getting "Could not obtain a WAC access token" in POSTMAN and 403 forbidden in Graph explorer UI.

URL Endpoint:https://graph.microsoft.com/v1.0/sites/<site>.sharepoint.com,<id>/lists/<itemid>/items/1/driveitem/workbook/worksheets

Error in Graph explorer: