when trying to access Sharepoint workbook receiving the error "403 forbidden Could not obtain a WAC access token". However able to get the items in the sharepoint site.
Azure AD permissions:
"roles": [
"Sites.Read.All",
"User.Read.All",
"Files.Read.All"
],
Hi @GopiRadhika-0333 ，
I could replicate the issue if the exvel file is .xls extension. So I think your excel file is .xls file.
However, the Excel REST API supports only Office Open XML file formatted workbooks. The .xls extension workbooks are not supported.
Please refer to this article for more: https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
Hi @MichaelHan-MSFT
No I created the workbook via sharepoint online (Office 365). They are with extension .xlsx. Please see attached. There are some .csv files in this sharepoint site under other folders but nothing under the folder that I am trying to extract the workbook.
!
Hi @GopiRadhika-0333 ，
I created the workbook via sharepoint online as you said. And I could accees the workbook successfully.
Which item Id did you use? Please make sure you are using the excel file Id instead of folder Id.
Hi @GopiRadhika-0333 ，
Per my test, I could aceess the workbook in SharePoint successfully.
If an Answer is helpful, please click "Accept Answer" and upvote it.
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.
Hi @MichaelHan-MSFT ,
I have set the following permissions in Azure AD.
But getting "Could not obtain a WAC access token" in POSTMAN and 403 forbidden in Graph explorer UI.
Error in Graph explorer:
I have set the following permissions in Azure AD.
But getting "Could not obtain a WAC access token" in POSTMAN and 403 forbidden in Graph explorer UI.
Error in Graph explorer:
7 people are following this question.
