Using $filter on the names and worksheets endpoints for Excel

Question

I am trying to filter results returned from the names and worksheets endpoints, but my filter is not working, I get all results from both.

.../workbook/names?$filter=name eq 'Name1' - response includes all names

.../workbook/worksheets?$filter=name eq 'Sheet1' - response includes all sheets

Is this an expected limitation, or am I doing something wrong?

Answer 1

Hello Derik Oliver,

Thank you for reaching out to Microsoft Support!

We also did the same test, the results are the same as yours, the $filter query parameter does not seem to work, you can give feedback here.

We also recommend that you use the following path instead:

To get a workbook:

https://graph.microsoft.com/v1.0/me/drive/root:/documentSet:/children?$filter=name eq 'Name1.xlsx'

Reference document:

https://learn.microsoft.com/en-us/graph/api/driveitem-list-children?view=graph-rest-1.0&tabs=http

To get a worksheets:

https://graph.microsoft.com/v1.0/me/drive/root:/{item-path}:/workbook/worksheets/{id|name}

Reference document:

https://learn.microsoft.com/en-us/graph/api/worksheet-get?view=graph-rest-1.0&tabs=http

Hope this helps.

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