Data from GSheets API to Glide Table

I have a GSheets API ready which I generated from nocodeapi.com. Now I am trying to fetch the data from the API in JSON format, but I can’t figure out the jq query. What is the standard JQ Query that we give to fetch data from a Google Sheet?

1 Like

Do you have a screenshot of the JSON response?

1 Like

Yes I do. I am just testing some sample data right now.
this is what it looks like-

And this goes on for another 5-7 rows, and ends with-

This is basically how its starts and ends. I notice that data is an array here, but I can’t figure out how to get the row IDs, Names, etc. in the output.

For row id of first obj - .data[0].row_id
For name of second obj - .data[1].name

Can you try and see if this works?

3 Likes

Hola!

Try with

data[].Name

You should see all Names found by your API call at the same time.

Saludos!

5 Likes

Both of these work, thank you so much!

2 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.