Is there any Graph API to get the rows from excel worksheet with some filter on column values?

Question

question

ffbld01ukibmcom-1577 asked Apr 20, '22 saldana-msft edited 3 days ago

Is there any Graph API to get the rows from excel worksheet with some filter on column values?

We are using Graph API for one of our excel-based applications. Currently, we have planned to use range API to retrieve the values for specific excel rows. Our queries are like following https://graph.microsoft.com/v1.0/me/drive/items/{ {ITEM_ID}}/workbook/worksheets/{ {worksheet_id}}/range(address='A1:Z100') which works. But now we want to add some filters in the query like we want to query any row that has a value for A=1234 but when we tried adding such filter on the URL, it says bad request. Look at the following query https://graph.microsoft.com/v1.0/me/drive/items/{ {ITEM_ID}}/workbook/worksheets/{ {worksheet_id}}/range(address='A1:Z1')?$filter='A eq 1234'

Could you suggest to us any API that can achieve the above use case?

microsoft-graph-general microsoft-graph-workbooks

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-21T16:40:16.307Z

ShivamDhiman-1582 answered Apr 21, '22

Hi @ffbld01ukibmcom-1577

Based on my test filter query parameter only works with the collection of the result.
The range that your are using in your query is not a collection. As per documentation only these properties are available for range. There is no property available where you can directly use filter clause to get particular value of cell.

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.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-04-22T05:06:14.153Z

ffbld01ukibmcom-1577 answered Apr 22, '22 ZehuiYaoMSFT-7151 edited Apr 25, '22

@ShivamDhiman-1582 thanks for the quick reply. Could you please share any API that might allow us to filter the rows based on a column value? FYI I know one such API which as per the documentation should work on tables, here is the documentation . But in our tests it did not work either, could you at least share one working payload for this API that shows the filter over column value, because the documentation does not have any payload for the API.

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ShivamDhiman-1582 · Apr 22 at 01:05 PM

Hi @ffbld01ukibmcom-1577

You can refer to this similar case

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.

0 ·

ZehuiYaoMSFT-7151 · Apr 25 at 07:20 AM

Hi @ffbld01ukibmcom-1577, did you refer to the answer above? Is it helpful to you? Comment here when you still need any help

0 ·

question