Could not obtain a WAC access token

Kelwen C W QIU 0 Reputation points
2023-03-18T14:55:37.45+00:00

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?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
876 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shivam Dhiman-MSFT 5,266 Reputation points Microsoft Vendor
    2023-03-20T05:18:50.2333333+00:00

    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:
    Untitled

    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.