# Retrieve new data from API

**URL:** <https://community.glideapps.com/t/retrieve-new-data-from-api/76274>\
**Category:** Ask for Help\
**Created:** [September 11, 2024, 2:55am UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274 "2024-09-11T02:55:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![skye](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@skye](https://community.glideapps.com/u/skye)\
**Post date:** [September 11, 2024, 2:55am UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274/1 "2024-09-11T02:55:37Z")

</div>

Hi all, I am wanting to retrieve dynamic data from the Glide App API. We have business plan, so should have access to advance API. At the moment, this is what I have done:

```auto
r = requests.post(
    "https://api.glideapp.io/api/function/queryTables",
    headers={"Authorization": "xxx"},
    json={
        "appID": "xxx",
        "queries": [
            {
                "tableName": "xxx",
                "utc": True
            }
        ]
    }
)

```

This however gives me all rows for the table. Is there a way to only retrieve certain rows (e.g. rows \> date) so that I can re-run the code regularly (e.g. daily) and only add new rows for export?

Thanks in advance,  
Skye

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 11, 2024, 3:59am UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274/2 "2024-09-11T03:59:45Z")

</div>

> **[Using Glide API | Glide Docs](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 Advanced API

---

<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:** [September 11, 2024, 2:52pm UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274/3 "2024-09-11T14:52:20Z")

</div>

Is it a Big Table? If it is, you can do a query based on this section.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/232bcd7a76e530c839f3f2c1808d4669f2c5ff8e.png)

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [September 12, 2024, 5:10am UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274/4 "2024-09-12T05:10:37Z")

</div>

Hey @skye ,

I hope this will help you.

I got help from @Darren_Murphy and did some digging around and found this is the way to do it.

```auto
curl --location 'https://api.glideapp.io/api/function/queryTables' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer xxxxxxxxx' \
--data '{
  "appID": "xxxxxxxx",
  "queries": [
    {
      "sql": "SELECT * FROM \"native-table-taableid\" WHERE \"FetchData?\" = TRUE"
    }
  ]
}'

```

The above curl is for me to filter and get API response when my column with name “FetchData?” has boolean checked meaning “True”

You can use this as benchmark. What I observed was the format of using \ or / and " or " before and after column name or table name is important to get desired output.

Hope this helps.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![skye](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@skye](https://community.glideapps.com/u/skye)\
**Post date:** [September 15, 2024, 8:49pm UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274/5 "2024-09-15T20:49:57Z")

</div>

Thank you for your help! This is great 🙂

---

<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:** [September 15, 2024, 11:26pm UTC](https://community.glideapps.com/t/retrieve-new-data-from-api/76274/6 "2024-09-15T23:26:34Z")

</div>

Hopefully it solved your case! Let us know if you need anything further.