# Fetch JSON **URL:** \ **Category:** Ask for Help\ **Created:** [January 2, 2022, 4:28am UTC](https://community.glideapps.com/t/fetch-json/36581 "2022-01-02T04:28:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Trevor\_Petrucci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trevor_petrucci/32/36542_2.png) [@Trevor\_Petrucci](https://community.glideapps.com/u/Trevor_Petrucci)\ **Post date:** [January 2, 2022, 4:28am UTC](https://community.glideapps.com/t/fetch-json/36581/1 "2022-01-02T04:28:48Z")
Hello, I have a quick question about fetch json function. So i am able to specifically parse out certain parts of the URL through the fetch json function, but is it possible to get multiple things? For example, if i had someone search “starbucks” I would want it to show a whole lsit of items from the api and not just one specific thing that i am looking for. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 2, 2022, 8:58am UTC](https://community.glideapps.com/t/fetch-json/36581/2 "2022-01-02T08:58:20Z")
How does your API return data? I think you just need to understand the result structure and construct an appropriate jq snippet to return multiple items at once. ---
**Author:** ![Trevor\_Petrucci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trevor_petrucci/32/36542_2.png) [@Trevor\_Petrucci](https://community.glideapps.com/u/Trevor_Petrucci)\ **Post date:** [January 2, 2022, 3:30pm UTC](https://community.glideapps.com/t/fetch-json/36581/3 "2022-01-02T15:30:25Z")
Basically it only comes back in one cell and I want it to return in multiple cells if there are multiple results. Does that make sense? ---
**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:** [January 2, 2022, 4:05pm UTC](https://community.glideapps.com/t/fetch-json/36581/4 "2022-01-02T16:05:07Z")
You can use several transform JQ [Transform JSON column • Glide](https://www.glideapps.com/plugins/jq) column to get the different results you are needing. ---
**Author:** ![Trevor\_Petrucci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trevor_petrucci/32/36542_2.png) [@Trevor\_Petrucci](https://community.glideapps.com/u/Trevor_Petrucci)\ **Post date:** [January 2, 2022, 6:04pm UTC](https://community.glideapps.com/t/fetch-json/36581/5 "2022-01-02T18:04:04Z")
I have been able to do that but Im looking for where it brings a list of things with multiple rows and not just one column and one row. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 3, 2022, 12:34am UTC](https://community.glideapps.com/t/fetch-json/36581/6 "2022-01-03T00:34:56Z")
You apply the transformation only on one cell, so the info you take back only goes to that cell, unless: - You can return a delimited list of values. - You then apply a split text column on that list to get an array. - In a supporting table, you have multiple rows like this. Array index || Value 0 || 1 || 2 || 3 || The value column will use a Single Value approach, pointing to the split text column in step 2, then use “From start” in configuration, combined with the array index. However you must either know in advance how many rows you are going to get (I assume this is not the case), or add as many rows as you can to cover most cases possible.