Filtering lines that arrive in the API

Ask for Help
1

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,

‏‏לכידה
‏‏לכידה559×865 43.6 KB

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

2

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.

2 Likes
3

Thanks! it worked.

1 Like
4

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