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?
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.
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.
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
}
]
}
So it’s a Big Table? I want to make sure you’re using a Big Table first.
Yes!
You can check the “Filtered queries with Big Tables” section here.
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,
You don’t need to do this.
The article linked above offers a way to query rows using SQL through Glide API, if the source is a Big Table.
2 Likes
@ThinhDinh
seems difficult to get working. I have tried the below - but I get “no response”
Any ideas what could be wrong?
