# Is there a way to send only few rows in glide api get response?
**URL:** https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808
**Category:** Ask for Help
**Created:** [August 23, 2024, 3:31am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808 "2024-08-23T03:31:15Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 23, 2024, 3:31am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/1 "2024-08-23T03:31:15Z")
Hi Guys,
I have a table → when I click on show API → Curl → Get rows
it currently gives me list of all items in the table.
In my table I have a column called FetchData
Only when the value for it is true I need that Items to be shown in the response.
how can I achieve this?
Thank you in advance
Regards,
Dilip
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 23, 2024, 3:36am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/2 "2024-08-23T03:36:51Z")
That can only be done with Glide Big Tables.
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 23, 2024, 3:52am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/3 "2024-08-23T03:52:17Z")
Thank you for responding @Darren_Murphy
Can we have combination of Glide tables and Glide big tables in a project? Mixing is a good practice?
Regards,
Dilip
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 23, 2024, 4:02am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/4 "2024-08-23T04:02:37Z")
Yes, you can do that.
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 23, 2024, 4:08am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/5 "2024-08-23T04:08:21Z")
Hi @Darren_Murphy I will give it a try.
If I complete migration to Big tables how can I filter out to get only certain values?
Regards,
Dilip
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 23, 2024, 4:13am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/6 "2024-08-23T04:13:28Z")
> **[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
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 23, 2024, 4:38am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/7 "2024-08-23T04:38:01Z")
Thank you for sharing @Darren_Murphy
Will go through this.
Regards,
Dilip
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 23, 2024, 9:00am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/8 "2024-08-23T09:00:04Z")
Thank you for sharing @Darren_Murphy
Will go through it .
Regards,
Dilip
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 30, 2024, 9:23am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/9 "2024-08-30T09:23:11Z")
Hi @Darren_Murphy ,
Is this a valid query for me to just filter data from my Glide Big Tables to fetch only rows which has FetchData is true?
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 \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*’
–data-raw ‘{
“appID”: “”,
“queries”: [
{
“tableName”: “”,
“utc”: true
SELECT \* FROM “native-table-4ed” WHERE “FetchData” = TRUE;
}
]
}’
Let me know wether this is right way?
Regards,
Dilip
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 30, 2024, 9:27am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/10 "2024-08-30T09:27:00Z")
> [@Dilip\_Adiga](#):
>
> “FetchData” = TRUE;
That doesn’t look right. You need to use the internal column names that Glide assigns.
Refer to the example in the documentation.
> **[Using Glide API | Glide Docs](https://www.glideapps.com/docs/essentials/data-sources/getting-started-with-the-glide-api/using-glide-tables-api#example)**
>
> Explore what you can do with the Glide Advanced API
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 30, 2024, 10:36am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/11 "2024-08-30T10:36:31Z")
Hi @Darren_Murphy ,
I just checked it and this is what I could do
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 \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*’
–data-raw ‘{
“appID”: “”,
“queries”: [
{
“tableName”: “native-table-426a619e-53ac-4f20-918e-6d4ffa5cd4ed”,
“utc”: true
“sql”: “SELECT \* FROM "native-table-426a619e-53ac-4f20-918e-6d4ffa5cd4ed" WHERE "CreatorName" = $1 AND ("IGHandle" = $2 OR "FetchData" = $3)”,
“params”: [“FetchData” = true]
}
]
}’
Now I am not sure how can I check send data of FetchData column value is true.
Could you let me know?
Regards,
Dilip
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 30, 2024, 10:53am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/12 "2024-08-30T10:53:15Z")
A few things:
- Assuming that FetchData is the correct internal Glide column name (I’m still skeptical about that) and it is a boolean type, then you don’t need to use a parameter replacement. You can just directly test for TRUE/FALSE/NULL.
- Also, you need to be quoting the column names (this is explained in the documentation).
- Thirdly, you have defined 3 replacements ($1, $2, $3), but you are only passing one parameter - which is being passed incorrectly. Again, please refer to the example in the documentation.
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 30, 2024, 11:19am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/13 "2024-08-30T11:19:26Z")
Hi @Darren_Murphy ,
Thank you for clearing it
I guess I get it now. I was doing it wrong
“queries”: [
{
“sql”: "SELECT \* FROM "native-table-W6X94ehhihDbnGdSCKib" WHERE **backslash** “RnIes **backslash** ” IS TRUE ]
}’
RnIes ----\> is internal glide table name which is of boolean in my case
Let me know if this is ok.
For some reason I am appending them within Quotes but they are going off because of editor formatting I guess.
Regards,
Dilip
Regards.
Dilip
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [August 30, 2024, 11:33am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/14 "2024-08-30T11:33:44Z")
Hi @Darren_Murphy ,
Thank you for your help and support
“queries”: [
{
“sql”: “SELECT \* FROM "native-table-426a619e-53ac-4f20-918e-6d4ffa5cd4ed" WHERE "RnIes" = TRUE”
}
]
}
I got it to work using this query
Regards,
Dilip
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [September 6, 2024, 11:34am UTC](https://community.glideapps.com/t/is-there-a-way-to-send-only-few-rows-in-glide-api-get-response/75808/15 "2024-09-06T11:34:32Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.