# Filtering lines that arrive in the API

**URL:** https://community.glideapps.com/t/filtering-lines-that-arrive-in-the-api/64152
**Category:** Ask for Help
**Tags:** api
**Created:** [July 20, 2023, 6:22am UTC](https://community.glideapps.com/t/filtering-lines-that-arrive-in-the-api/64152 "2023-07-20T06:22:51Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![libi41](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/libi41/32/52932_2.png) [@libi41](https://community.glideapps.com/u/libi41)
#### Post date: [July 20, 2023, 6:22am UTC](https://community.glideapps.com/t/filtering-lines-that-arrive-in-the-api/64152/1 "2023-07-20T06:22:52Z")

</div>

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,

 ![‏‏לכידה](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f25a0b586e76a095a22b4dddc481fd4dc3d6ef54.png)

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

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 20, 2023, 9:47am UTC](https://community.glideapps.com/t/filtering-lines-that-arrive-in-the-api/64152/2 "2023-07-20T09:47:46Z")

</div>

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.

> **[Map & get - Make x Glide](https://docs.lowcode.agency/recordings/j4Vd9oMn5U6bXBJJRfXJ)**

---

<div class="post-metadata">

### Author: ![libi41](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/libi41/32/52932_2.png) [@libi41](https://community.glideapps.com/u/libi41)
#### Post date: [July 20, 2023, 12:22pm UTC](https://community.glideapps.com/t/filtering-lines-that-arrive-in-the-api/64152/3 "2023-07-20T12:22:52Z")

</div>

Thanks! it worked.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [July 21, 2023, 12:23pm UTC](https://community.glideapps.com/t/filtering-lines-that-arrive-in-the-api/64152/4 "2023-07-21T12:23:41Z")

</div>

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