# Fetch Column
**URL:** https://community.glideapps.com/t/fetch-column/31731
**Category:** Ask for Help
**Tags:** custom-code
**Created:** [September 13, 2021, 3:09pm UTC](https://community.glideapps.com/t/fetch-column/31731 "2021-09-13T15:09:13Z")
**Posts on this page:** 17
**Page:** 4
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 3:22am UTC](https://community.glideapps.com/t/fetch-column/31731/61 "2021-10-21T03:22:01Z")
I only have a single row in my glide table…
so this is my objective…To host the majority of my app data in Firebase and using Firebase’s REST API to display and maintain the data, and simply use Glide for authentication, front-end and the business logic.
I believe this would address the row limits, performance and scalability issue associated with Glide.
I have this simple `Firebase` branch called `venues`
I have this simple Glide table that is fetching the above data and so I want to display the json returned of Venue objects in an inline list.
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 3:25am UTC](https://community.glideapps.com/t/fetch-column/31731/62 "2021-10-21T03:25:35Z")
the list needs to act like a Glide list, eg; be selectable to view its details etc
---
### Author:  [@Kyan\_Lynch](https://community.glideapps.com/u/Kyan_Lynch)
#### Post date: [October 21, 2021, 3:28am UTC](https://community.glideapps.com/t/fetch-column/31731/63 "2021-10-21T03:28:19Z")
Yes, that makes sense. I’d love to do that too, truthfully. Hopefully someone smarter than I am helps us figure it out!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 21, 2021, 5:06am UTC](https://community.glideapps.com/t/fetch-column/31731/64 "2021-10-21T05:06:26Z")
Well to display an inline list you will still need multiple rows to house it, so that defeats your purpose.
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 5:16am UTC](https://community.glideapps.com/t/fetch-column/31731/65 "2021-10-21T05:16:34Z")
yeah i think i gathered that earlier. I figured that it could’ve been a possibility since an in-line list can be built from any array and the returned json is essentially an array/dictionary
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2021, 12:00pm UTC](https://community.glideapps.com/t/fetch-column/31731/66 "2021-10-21T12:00:59Z")
Let’s pretend we could display the array as an inline list. What are you expecting to happen when you click on an item? Show details for just that item? Where are those details living? In another array? Glide can’t do this without knowing the position in the array.
---
### Author:  [@Rogelio](https://community.glideapps.com/u/Rogelio)
#### Post date: [October 21, 2021, 12:37pm UTC](https://community.glideapps.com/t/fetch-column/31731/67 "2021-10-21T12:37:56Z")
The details are all within the same returned json
---
### Author:  [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [November 22, 2021, 11:23pm UTC](https://community.glideapps.com/t/fetch-column/31731/68 "2021-11-22T23:23:09Z")
Apologies if you are already aware of this, but it looks like we can do a lot of things with Fetch JSON and Transform JSON plugins.
I was playing around with the plugins to see if I could fetch daily prayer times from a public API. Everything went well and I was able even to transform JSON with JQ until it came to finding a way to capture everything inside one cell, without having to create additional columns or even split/template columns, to present the data in nice way. I visited this and the dictionary thread to see what I could learn, and I learned a lot. Suddenly it occurred to me to see if I could actually get some HTML and text to work in the Transform JSON plugin itself. Below is the result.
What you need to do is place your HTML and/or text inside inverted commas, so “
text”
Here is the data I was working with:
[{“times”:{“Imsak”:“05:21”,“Sunrise”:“07:29”,“Fajr”:“05:31”,“Dhuhr”:“11:47”,“Asr”:“13:42”,“Sunset”:“16:04”,“Maghrib”:“16:26”,“Isha”:“17:55”,“Midnight”:“22:48”},“date”:{“timestamp”:1637539200,“gregorian”:“2021-11-22”,“hijri”:“1443-04-17”}},{“latitude”:51.50735092163086,“longitude”:-0.12775829434394836,“elevation”:33,“city”:“London”,“country”:“United Kingdom”,“country\_code”:“GB”,“timezone”:“Europe/London”,“local\_offset”:0},{“timeformat”:“HH:mm”,“school”:“Ithna Ashari”,“juristic”:“Shafii”,“highlat”:“None”,“fajr\_angle”:18,“isha\_angle”:17}]
Thank you
---
### Author:  [@inspired](https://community.glideapps.com/u/inspired)
#### Post date: [December 10, 2021, 7:53am UTC](https://community.glideapps.com/t/fetch-column/31731/69 "2021-12-10T07:53:19Z")
thank you so much that was very helpful and informative. so cool how you can use text entry as a search bar.
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [March 7, 2022, 6:21pm UTC](https://community.glideapps.com/t/fetch-column/31731/70 "2022-03-07T18:21:36Z")
Hi @ThinhDinh,
I am trying to fetch the json that produces my GAS REST API service from a google sheet; calling the service from the browser, the json is returned, but nothing is returned via the fetch column.
Is this problem due to my rest api not allow cross-origin requests?
If it depends on it, do you know if there is a way to enable?
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 7, 2022, 6:30pm UTC](https://community.glideapps.com/t/fetch-column/31731/71 "2022-03-07T18:30:54Z")
> [@Roldy](#):
>
> problem due to my rest api not allow cross-origin requests?
Sorry for my innocence but does it mean? 😇
Do you see any data movement in your GS when an API call is received?
Saludos
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [March 7, 2022, 6:40pm UTC](https://community.glideapps.com/t/fetch-column/31731/72 "2022-03-07T18:40:58Z")
Hi @gvalero !
To clarify … I want to retrieve data from a google sheet not connected to the app. I need to do this because the sheet has hundreds of thousands of rows and I can’t manage it directly in glide due to the limitations we know (25,000 rows).
The idea is to tap into this data a little at a time by building a REST API service on top of this large sheet so that only the quota of rows I need is returned.
But it seems that the response of my rest api service has some problems to be received by the fetch column because it is empty …
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [March 7, 2022, 6:56pm UTC](https://community.glideapps.com/t/fetch-column/31731/73 "2022-03-07T18:56:34Z")
@ThinhDinh , @gvalero
I am very sorry for wasting your time, it was only due to a problem of authorization to run the web app.
🤦
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [March 7, 2022, 7:04pm UTC](https://community.glideapps.com/t/fetch-column/31731/74 "2022-03-07T19:04:26Z")
🤣 no worry Roldy, I suffered the same when I did my own Rest API weeks ago:
> [@A Google Sheet working as a REST API: good or bad idea? bomb](https://community.glideapps.com/t/a-google-sheet-working-as-a-rest-api-good-or-bad-idea/35668):
>
> Hola! It’s just a Proof of Concept which I wanted to do since a long time ago to know how reliable and fast a Google Sheet can handle a large amount of data and be used as an API to receive/send data frequently. As you should know, GS is not a native database therefore, some key functionalities (like an indexed file) don’t exist and can’t be used to improve the lookup speed. GS has the Filter() and Query() as tools to search data but it isn’t enough to make a lookup fast or optimal, both of th…
BTW… How many rows are you handling and how fast is your API’ reply?
---
### Author:  [@Roldy](https://community.glideapps.com/u/Roldy)
#### Post date: [March 7, 2022, 7:24pm UTC](https://community.glideapps.com/t/fetch-column/31731/75 "2022-03-07T19:24:29Z")
Currently I’m just doing a feasibility analysis because my potential client has a catalog of points of interest of about 100,000 rows in excel.
In the end what I have to do is just pull down a few hundred per user of these POI.
I’m about to experiment with dummy data (by the way, have you ever used the [https://www.mockaroo.com](https://www.mockaroo.com) service? Very convenient for doing these simulations).
How fast my script will be to extrapolate 100 rows from 100.000 I still don’t know …
But I’ll let you know as soon as I finish it … I hope some seconds as in your example app.
Thank you for your suggestion! 👍
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 7, 2022, 8:22pm UTC](https://community.glideapps.com/t/fetch-column/31731/76 "2022-03-07T20:22:25Z")
> [@Roldy](#):
>
> I’m about to experiment with dummy data (by the way, have you ever used the [https://www.mockaroo.com](https://www.mockaroo.com/) service? Very convenient for doing these simulations).
Any company that uses a kangaroo in their logo gets a thumbs up from me 👍 😆
This looks great, thanks for sharing
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 8, 2022, 1:13am UTC](https://community.glideapps.com/t/fetch-column/31731/77 "2022-03-08T01:13:00Z")
Oh that website is great! Thanks for sharing.
[Previous page](https://community.glideapps.com/t/fetch-column/31731.md?page=3)