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.
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
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.
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”
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?
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 …
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 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.