# Data from GSheets API to Glide Table **URL:** \ **Category:** Ask for Help\ **Created:** [November 15, 2021, 7:29pm UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547 "2021-11-15T19:29:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Heena\_Mirchandani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heena_mirchandani/32/33315_2.png) [@Heena\_Mirchandani](https://community.glideapps.com/u/Heena_Mirchandani)\ **Post date:** [November 15, 2021, 7:29pm UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/1 "2021-11-15T19:29:50Z")
I have a GSheets API ready which I generated from [nocodeapi.com](http://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? ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [November 15, 2021, 7:38pm UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/2 "2021-11-15T19:38:34Z")
Do you have a screenshot of the JSON response? ---
**Author:** ![Heena\_Mirchandani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heena_mirchandani/32/33315_2.png) [@Heena\_Mirchandani](https://community.glideapps.com/u/Heena_Mirchandani)\ **Post date:** [November 16, 2021, 7:26am UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/3 "2021-11-16T07:26:22Z")
Yes I do. I am just testing some sample data right now. this is what it looks like- ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6ba7fe6075623fd6e20e4dcd8ba909a35880135.png) And this goes on for another 5-7 rows, and ends with- ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/11194d4ddf654133f330c5ba3120c152d97bda0f.png) 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. ---
**Author:** ![manity](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manity/32/2836_2.png) [@manity](https://community.glideapps.com/u/manity)\ **Post date:** [November 16, 2021, 8:18am UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/4 "2021-11-16T08:18:46Z")
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? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 16, 2021, 12:29pm UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/5 "2021-11-16T12:29:12Z")
Hola! Try with ` data[].Name` You should see all Names found by your API call at the same time. Saludos! ---
**Author:** ![Heena\_Mirchandani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heena_mirchandani/32/33315_2.png) [@Heena\_Mirchandani](https://community.glideapps.com/u/Heena_Mirchandani)\ **Post date:** [November 16, 2021, 4:59pm UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/6 "2021-11-16T16:59:13Z")
Both of these work, thank you so much! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 17, 2021, 4:59pm UTC](https://community.glideapps.com/t/data-from-gsheets-api-to-glide-table/34547/7 "2021-11-17T16:59:57Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.