Graph API suddenly did not working for Personal Microsoft Account

Tiger Ng 5 Reputation points
2023-03-19T04:59:54.87+00:00

Hi,

My app's account type on Azure Portal is

"Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts (e.g. Skype, Xbox**)"**

My app is using Graph API to access workbooks. It is running properly for Personal Microsoft Account until last day. It prompts error:

"Could not obtain a WAC access token"

WAC is related to SharePoint. However, I am using Personal Microsoft Account for authorisation.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,771 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
{count} vote

2 answers

Sort by: Most helpful
  1. John Max 10 Reputation points
    2023-03-19T09:54:20.96+00:00

    The error message you are receiving suggests that there may be an issue with obtaining a WAC (Web Application Companion) access token for your Personal Microsoft Account. WAC is related to accessing and editing documents on SharePoint.

    To troubleshoot this issue, you may want to try the following steps:

    1. Verify that the SharePoint site you are trying to access is accessible and that you have the necessary permissions to view and edit the document.
    2. Check if there have been any changes to the SharePoint or Office 365 environment that could affect your access.
    3. Verify that your app has the necessary permissions to access the SharePoint site. You may need to check the permissions your app has been granted in the Azure Portal.
    4. Check if your app is correctly configured to use the correct endpoints and scopes for accessing the Graph API and SharePoint.

    You may also want to check if there have been any updates or changes to the Graph API that could be affecting your app's ability to access the workbook.

    Regards
    John
    CEO
    Mobilesinbd

    0 comments No comments

  2. Zehui Yao_MSFT 5,831 Reputation points
    2023-03-21T06:42:42.4866667+00:00

    Hi Tiger Ng, I could reproduce this issue when the excel file is .xls extension.

    As according to the documentation, the Excel REST API supports only Office Open XML file formatted workbooks. The .xls extension workbooks are not supported. So please check the extension of your file. Hope this helps. Best Wishes.

    User's image

    User's image

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.