API for Microsoft Excel is not working properly.

Question

Hey,

I am connecting you on behalf of Pabbly Connect.

Within our integration, we have set up an action event "List Worksheet" which is currently throwing an error and we are not able to use a list worksheet.

Here is the URL for your reference:
https://graph.microsoft.com/v1.0/me/drive/items/A03D9E4EB5571E5E!332/workbook/worksheets

I would also like to clarify that based on docs, my token contains the needed "Files.ReadWrite" scope.

This is the error message we are getting while hitting the API and also our shared users are facing the same issue.

{
   "error": {
       "code": "FileOpenUserUnauthorized",
 "message": "You do not have permissions to open this file in the browser.",       "innerError": {
           "code": "unauthorizedUncategorized",
         "message": "Required authentication information for the resource is either missing or invalid.",
        "innerError": {
            "code": "FileOpenUserUnauthorized",
            "message": "You do not have permissions to open this file in the browser."
        },
        "date": "2024-04-18T10:29:19",
         "request-id": "b89dfbc0-f3b1-4ad9-aac9-6163a40d3a79",
        "client-request-id": "b89dfbc0-f3b1-4ad9-aac9-6163a40d3a79"
       }    }
}

It would be great if you can assist us with the same. If any additional information is required do let us know.