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.
10,538 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Shivam Dhiman 5,946 Reputation points
    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.

    0 comments No comments

  2. Zehui Yao_MSFT 5,831 Reputation points
    2023-04-10T08:31:00.2066667+00:00

    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.

    0 comments No comments