Request to create workbook session- Excel

Question

I am a developer, I am currently integrating Microsoft excel into our platform.
On microsoft graph explorer I have been trying to test the end point to create a session and it keeps returning this error :{
"error": {
"code": "AccessDenied",
"message": "Could not obtain a WAC access token.",
"innerError": {
"date": "2022-02-17T11:04:12",
"request-id": "07db3510-5f11-46ca-8c10-24103400be63",
"client-request-id": "e0cea44f-7727-827f-4c79-8a0fc79831a2"
}
}
}

Even after adding the files.readwrite permission it still returns this error... please i will like to know what permission i need to create a session.

Answer 1

Hi @Liomotolani ,

I am able to replicate the same issue at my end when I am using excel file with .xls extension.
The .xls extension workbooks are not supported. As mentioned in MS Documentation.

The Excel REST API supports only Office Open XML file formatted workbooks. Please use excel file with .xlsx extension to get the desired result.
Permission required to perform this action

Result

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".