Data from GSheets API to Glide Table

Ask for Help
1

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?

2

Do you have a screenshot of the JSON response?

3

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

image
image721×343 20.7 KB

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

image
image698×285 16.4 KB

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.

4

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?

5

Hola!

Try with

data[].Name

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

Saludos!

6

Both of these work, thank you so much!