# Glide Table API Get All Filter?

**URL:** <https://community.glideapps.com/t/glide-table-api-get-all-filter/56679>\
**Category:** Ask for Help\
**Created:** [January 13, 2023, 8:23pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679 "2023-01-13T20:23:35Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![travischristian](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travischristian/32/49210_2.png) [@travischristian](https://community.glideapps.com/u/travischristian)\
**Post date:** [January 13, 2023, 8:23pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/1 "2023-01-13T20:23:35Z")

</div>

I have data in a table that I’m querying from another platform but rather than bringing ALL the rows over I want to limit it by filtering to a specific date range. Creating the request using the format Glide provides is working fine but is there a way to set a filter in the request so that I’m limiting the search upfront (rather than returning all the rows and filtering in a subsequent step)?

curl --request POST ‘[https://api.glideapp.io/api/function/queryTables](https://api.glideapp.io/api/function/queryTables)’   
–header ‘Content-Type: application/json’   
–header ‘Authorization: Bearer XXXXXXXXXXXX’   
–data-raw ‘{  
“appID”: “XXXXXXXXXXX”,  
“queries”: [  
{  
“tableName”: “native-table-XXXXXXXXX”  
}  
]  
}’

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 13, 2023, 8:43pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/2 "2023-01-13T20:43:31Z")

</div>

No, I’m afraid that’s not supported. It would be nice if it was.

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [January 13, 2023, 8:44pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/3 "2023-01-13T20:44:38Z")

</div>

> [@Darren\_Murphy](#):
>
> It would be nice if it was

Even just return one row based on RowID would be wonderful – although a full-fledged query would certainly be the next thing we’d ask for! 🥇

---

<div class="post-metadata">

**Author:** ![Carrano\_Dot\_Dev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carrano_dot_dev/32/61751_2.png) [@Carrano\_Dot\_Dev](https://community.glideapps.com/u/Carrano_Dot_Dev)\
**Post date:** [August 16, 2023, 6:09pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/4 "2023-08-16T18:09:13Z")

</div>

Insane that this isn’t a feature already.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 16, 2023, 6:12pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/5 "2023-08-16T18:12:12Z")

</div>

It is.

> **[Using Glide Tables API](https://www.glideapps.com/docs/essentials/data-sources/getting-started-with-the-glide-api/using-glide-tables-api#filtered-queries-with-big-tables)**
>
> Explore what you can do with the Glide Tables API

---

<div class="post-metadata">

**Author:** ![Carrano\_Dot\_Dev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carrano_dot_dev/32/61751_2.png) [@Carrano\_Dot\_Dev](https://community.glideapps.com/u/Carrano_Dot_Dev)\
**Post date:** [August 16, 2023, 6:13pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/6 "2023-08-16T18:13:42Z")

</div>

Only with Big Tables which have some pesky limitations.

---

<div class="post-metadata">

**Author:** ![Bernd\_Grimm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bernd_grimm/32/81073_2.png) [@Bernd\_Grimm](https://community.glideapps.com/u/Bernd_Grimm)\
**Post date:** [May 23, 2024, 9:43am UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/7 "2024-05-23T09:43:21Z")

</div>

hey guys, is it still not possible to get a single row out of a specific table?

tried this:

```auto
 "options": {
        "filter": {
          "column": "RowID",
          "operator": "=",
          "value": "SpecificRowID"
        }
      }

```

Unfortunately doesn´t work…

---

<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:** [May 23, 2024, 1:06pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/8 "2024-05-23T13:06:16Z")

</div>

Do you use Make for this or just a generic HTTP call?

---

<div class="post-metadata">

**Author:** ![Bernd\_Grimm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bernd_grimm/32/81073_2.png) [@Bernd\_Grimm](https://community.glideapps.com/u/Bernd_Grimm)\
**Post date:** [May 23, 2024, 1:25pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/9 "2024-05-23T13:25:50Z")

</div>

[Make.com](http://Make.com) - and with make a http-request. I have now solved it within make scenario. and for the glide query, I don’t think it makes any difference whether you retrieve all data records or just one.

But of course it would be nicer…

---

<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:** [May 23, 2024, 1:28pm UTC](https://community.glideapps.com/t/glide-table-api-get-all-filter/56679/10 "2024-05-23T13:28:11Z")

</div>

What I usually do is using the Glide module to get all rows, then apply the get & map functions to get the value I want.
