Unable to view Excel worksheets. "General exception while processing"

[eugene-kim]

Describe the bug I'm trying to list worksheets in a workbook in Microsoft Graph Explorer

To Reproduce

1. Go https://developer.microsoft.com/en-us/graph/graph-explorer
2. Sign in
3. Grant yourself Files.ReadWrite permissions
4. Make a GET request to: https://graph.microsoft.com/v1.0/me/drive/items//workbook/worksheets (update with an excel file you have in your one drive)
5. Get the following response: Internal Server Error - 500 - 275 ms

   {
   "error": {
       "code": "generalException",
       "message": "General exception while processing",
       "innerError": {
           "date": "2024-07-15T14:48:29",
           "request-id": "3b2f22df-944f-48bb-bc64-bb44336bc465",
           "client-request-id": "537a1bbf-21a8-0c28-e514-c618a0b1a509"
       }
   }
   }

Expected behavior A clear and concise description of what you expected to happen.

Screenshots

Additional context I tried to do this via Node and wasn't successful so I looked to get some resolution via the explorer. Received the same response:

async function getWorksheets(accessToken: string, userId: string, fileId: string): Promise<any> {
  const client = await getAuthenticatedClient(accessToken);
  const worksheets = await client.api(`/users/${userId}/drive/items/${fileId}/workbook/worksheets`).get();
  return worksheets;
}

[eugene-kim]

The file id i was using: 6BB86F66F0707C42!122

[ElinorW]

Hi @eugene-kim , could you please confirm if you are still experiencing this issue?

[eugene-kim]

@ElinorW yes. Are you asking because there was a fix in place?

[ElinorW]

@eugene-kim no, but I believe it's an issue with the Excel API's. Please post this on the Microsoft Graph Q&A forum where the appropriate team will be able to help

[eugene-kim]

@ElinorW I'm trying to post in the forum but it says I'm violating the Code of Conduct.

All I did was post the text of the original question and referred back to this issue. Are you able to assist?

Thank you

[ElinorW]

@eugene-kim, that's strange. I've tried to post it as well but I got the same error. 😞 Let me try and find an alternative

[ElinorW]

@eugene-kim if you have a paid azure subscription or an m365 tenant, you can create a support ticket instead https://developer.microsoft.com/en-us/graph/support

[eugene-kim]

I'm trying to create a support request but I'm prevented from doing so. I've put in my details and I only see self help solutions. Do you have any suggestions on how I can proceed?

I have the standard support plan

[ElinorW]

Hey @eugene-kim click on the 'Return to support request" and then click Next

[eugene-kim]

Thank you! I was able to create a support ticket

[ElinorW]

Closing this for now. If you encounter any issues on Graph Explorer, please feel free to create an issue