Glide Fetch Column column.sh/fetch is an experimental code column that fetches JSON data from a public API and transforms it with an optional jq query . Example: Fetch a Cat Fact Add column at https://column.sh/fetch Set URL to https://cat-fact.herokuapp.com/facts to fetch cat facts. Set query to .…

I’ve tried a self-relation (multiple) back to itself using a standard text column, but it doesn’t quiet work, as the list I want to display it’s contained in an individual column of the sheet that contains a single row.

What I’m thinking is create a row number in each row and start with 0. Then add a single value column that looks at that array. Choose “from start” > Row number. This should put each value on its own row. Then you can display it in an inline list.

This is obviously not exactly what you are looking to do, but I was looking for a way to display multiple items in a list from a fetch. Rather than inline list (for now), I replaced the JSON elements I didn’t want ( [, ", ".) with HTML tags and created an unordered list for display purposes. I am u…

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…

the list needs to act like a Glide list, eg; be selectable to view its details etc

Yes, that makes sense. I’d love to do that too, truthfully. Hopefully someone smarter than I am helps us figure it out!

Well to display an inline list you will still need multiple rows to house it, so that defeats your purpose.

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.

The details are all within the same returned json

Fetch Column

Ask for Help

gvalero March 7, 2022, 7:04pm 74

no worry Roldy, I suffered the same when I did my own Rest API weeks ago:

BTW… How many rows are you handling and how fast is your API’ reply?

1 Like

Topic		Replies	Views
NoCodeAPI + Fetch ❤️ Project Showcase	68	4489	June 24, 2022
🌐 Please help us test: API Column and Webhook action Ask for Help	119	7585	November 18, 2021
Best practices pls for image sharing & storage from anywhere in app Ask for Help	35	771	October 19, 2021
🎓 Glide Tutorial - AI Assisted Data Entry Community Resources ai , chatgpt , openai , tutorial	19	891	July 18, 2023
Glide Big Tables API! Get your big table to your google sheet! Community Resources tutorial	5	872	November 1, 2023

Fetch Column

Related topics