Graph REST API: Use $filter on the /tables/rows endpoint

Question

According to the docs OData Query Parameters are supported on /workbook/tables/{id|name}/rows However when I try it I always get a Bad Request Error saying that the filter clause is invalid. Here is the filter that I used /workbook/tables/Table1/rows?filter=Schließanlage eq '1234' Do you know whats wrong with that?

Answer 1

Hello Shadi, Good afternoon and thank you for your question. Can I please know what are you trying to achieve here?

• Are you trying to retrive properties and relationships of tablerow object?
• Are you trying to get row based on its position in the collection?
• Are you trying to get range object associated with the entire row? I tested it by using Graph Explorer by first having rows only and it provided a response for all rows(index):

GET v1.0 https://graph.microsoft.com/v1.0/me/drive/items/{itemID}/workbook/tables/Table2/rows

Although, when I tried to add OData query parameters such as filters, it shows all rows again:

GET v1.0 https://graph.microsoft.com/v1.0/me/drive/items/{itemID}/workbook/tables/Table2/rows?filter=Language eq 'French'

Where as: Table2 is the name of the tablerow Language is the column French is the value REFERENCE: Use query parameters to customize responses https://learn.microsoft.com/en-us/graph/query-parameters?tabs=http Use the filter query parameter
https://learn.microsoft.com/en-us/graph/filter-query-parameter?tabs=http

Answer 2

Hi Shadi Rashed , I found a post similar to your question, may meet your needs. And since the filter: apply documentation does not provide complete guidance on how to set up criteria. If you encounter this problem. I would recommend the option to raise a support case with Microsoft Graph, a backend Support Engineer will be able to assist you better and provide more official answers. Hope this Helps. Best wishes. You can raise support ticket from http://aad.portal.azure.com/ or https://admin.microsoft.com/#/support/requests.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.