Filtering lines that arrive in the API

I work with the Mike automation system to receive lines from the sheet using the API.
Reading returns me all the rows in the sheet, how do I filter only the rows I need?
I used the filter in JSON and it’s not a filter,
I used the Query String found in the HTTP model I send - it’s not a filter either.
What am I doing wrong?
attached an example,

I am trying to extract only rows in which the number that appears is:
Many thanks to the respondents

I think what you need is an iterator on the returned rows array, then you can filter based on the right column.

Here’s an extra video on having something like a lookup function, which might not apply to this specific case (since I think you want to return the full row), but might be useful down the line.


Thanks! it worked.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.