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.