# How to use a API call to query one row? **URL:** \ **Category:** Ask for Help\ **Created:** [July 24, 2024, 9:58pm UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149 "2024-07-24T21:58:34Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Travis\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis_anderson/32/61251_2.png) [@Travis\_Anderson](https://community.glideapps.com/u/Travis_Anderson)\ **Post date:** [July 24, 2024, 9:58pm UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/1 "2024-07-24T21:58:34Z")
I cant seem to find anything on how to do this? Is there a way to get 1 row with a query table api call? ---
**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 25, 2024, 12:00am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/2 "2024-07-25T00:00:22Z")
That would only be possible if that’s a Big Table (using SQL). If it’s a normal table, for example in Make, you would have to query all rows first, then use a get + map function combination to get the value you want, assuming you want something from that row. ---
**Author:** ![FrancoisDigico](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/francoisdigico/32/75651_2.png) [@FrancoisDigico](https://community.glideapps.com/u/FrancoisDigico)\ **Post date:** [July 25, 2024, 12:15am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/3 "2024-07-25T00:15:29Z")
Hello, there are many ways to achieve that. You can use Glide API if business plan to call any API. Other possiblity is use Glide webhooks (Maker plan). We did perform 500 calls this month with 5 integrations with Shopify. ---
**Author:** ![Travis\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis_anderson/32/61251_2.png) [@Travis\_Anderson](https://community.glideapps.com/u/Travis_Anderson)\ **Post date:** [July 25, 2024, 12:39am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/4 "2024-07-25T00:39:03Z")
Thanks for getting back to me, Im not very familer with APIs, how would I change this post to only get one row? { “appID”: “123456”, “queries”: [ { “tableName”: “native-table-1234”, “utc”: true } ] } ---
**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 25, 2024, 12:49am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/5 "2024-07-25T00:49:42Z")
So it’s a Big Table? I want to make sure you’re using a Big Table first. ---
**Author:** ![Travis\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis_anderson/32/61251_2.png) [@Travis\_Anderson](https://community.glideapps.com/u/Travis_Anderson)\ **Post date:** [July 25, 2024, 12:57am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/6 "2024-07-25T00:57:19Z")
Yes! ---
**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 25, 2024, 2:32am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/7 "2024-07-25T02:32:23Z")
> **[Using Glide API | Glide Docs](https://www.glideapps.com/docs/using-glide-tables-api#filtered-queries-with-big-tables)** > > Explore what you can do with the Glide Advanced API You can check the “Filtered queries with Big Tables” section here. ---
**Author:** ![FrancoisDigico](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/francoisdigico/32/75651_2.png) [@FrancoisDigico](https://community.glideapps.com/u/FrancoisDigico)\ **Post date:** [July 25, 2024, 3:44am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/8 "2024-07-25T03:44:45Z")
Something like that before sending to an API as Json data (all platforms know it’s easy) data = { “appID”: “123456”, “queries”: [ { “tableName”: “native-table-1234”, “utc”: true } ] } myData = data.parseJson(); dataToSend = something like that, ---
**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 25, 2024, 9:10am UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/9 "2024-07-25T09:10:18Z")
You don’t need to do this. > [@FrancoisDigico](#): > > data = { > “appID”: “123456”, > “queries”: [ > { > “tableName”: “native-table-1234”, > “utc”: true > } > ] > } > > myData = data.parseJson(); > dataToSend = something like that, The article linked above offers a way to query rows using SQL through Glide API, if the source is a Big Table. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [July 25, 2024, 8:02pm UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/10 "2024-07-25T20:02:18Z")
@ThinhDinh seems difficult to get working. I have tried the below - but I get “no response” Any ideas what could be wrong? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/4312f47a8efc5687635abbe3759afe4aef213789.png) ---
**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 25, 2024, 11:29pm UTC](https://community.glideapps.com/t/how-to-use-a-api-call-to-query-one-row/75149/11 "2024-07-25T23:29:27Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/2708813cf803f3f9e2b36d403a4e6621cb14627e.png) Here’s a sample call from Make that’s working. I think there was an issue with the API a few hours ago, reported in Glide’s Slack. You can try your call again now.