Hi,
I get the error [403] Could not obtain a WAC access token. with Microsoft 365 Excel node when tryng to read a worksheet. Does someone know how to solve this?
Thanks!
Marcus
Hi,
I get the error [403] Could not obtain a WAC access token. with Microsoft 365 Excel node when tryng to read a worksheet. Does someone know how to solve this?
Thanks!
Marcus
Is the Excel document stored on the web, or on your local device only?
Make cannot access private documents on your computer, you need to upload it somewhere first.
Asking because Microsoft 365 Excel can be used offline.
I’m having the same problem. My file is an excel online file (.url)
Welcome to the Make community!
I did some research on the internet and this is what I could find:
This has something to do with a sheet within a folder that is not accessible:
microsoft graph api - Could not obtain a WAC Access Token while trying to access excel file on SharePoint - Stack Overflow
You could have selected a shared file, that is not owned by your account:
office365 - Getting WAC access token error when calling Microsoft Graph API - Stack Overflow
It could be because you are using a personal account, not a business/enterprise account:
excel - Microsoft Graph API Resource not found when access workbook of onedrive - Stack Overflow
You could try creating a new connection using a Microsoft 365 Excel Business account, and reselecting the Excel file you want to access.
For technical issues or bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to. Additionally, sharing sensitive information about your situation might not be suitable for an open forum discussion.
You can open a new ticket, or if you are unable to login for some reason, you also can reach support using the contact form on the website.
If you manage to get your issue resolved with support, we’d still love to hear about it! Sharing your solution on the forum can help others facing similar problems.
Hello @Marcus_Moutinho and @Frances_Wilson welcome to the community
The 403 error usually means that you don’t have permission to access a specific Worksheet. Can you please double-check that you have all the necessary permissions for accessing this Worksheet? For example, the admin of that file could change the permissions.
This error comes directly from Microsoft Excel. If permissions are still in place and the issue exists, I would recommend contacting Microsoft directly and sharing the following error:
{
"error": {
"code": "AccessDenied",
"message": "Could not obtain a WAC access token.",
"innerError": {
"date": "2024-01-14T10:20:03",
"request-id": "cd96cd60-a958-4f9b-aadc-9877d948ecfe",
"client-request-id": "cd96cd60-a958-4f9b-aadc-9877d948ecfe"
}
}
}
Hope this helps