Could not obtain a WAC access token

Question

when we use the access token to call below API, it return error "Could not obtain a WAC access token"

https://graph.microsoft.com/v1.0/me/drive/root:/Bank_transactions_loancurrent_1Y_Xero_IN01.xlsx:/workbook/worksheets?

but use the same access token call below api it is successful

https://graph.microsoft.com/v1.0/me

https://graph.microsoft.com/v1.0/me/drive/recent?

Answer 1

Hi Kelwen C W QIU please refer to this recent same issue, it seems that this problem may be a temporary server-side problem, please check if it still exists in your environment.

Answer 2

Hi @Kelwen C W QIU

I am able to replicate the same issue with the above Graph API endpoint.
As a workaround, to list the worksheets use the below Graph API in sequence:

GET /me/drive/root/children

GET /me/drive/items/{id}/workbook/worksheets

Result:

For executing the above endpoint using relative path, I would recommend you to raise a support case with Microsoft Graph, a Support Engineer will be able to assist you better. You can raise support ticket from
http://aad.portal.azure.com/ or https://admin.microsoft.com/#/support/requests.

Hope this helps.

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