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

The only thing with splitting it that way is that JSON doesn’t necessarily need to be structured with everything in a certain order. I mean, the hierarchy matters, but the order of items within a node could be in any order because each piece of data is qualified by name. If the json layout is stab…

Thanks for pointing that out. :exploding_head: I will check out the other column and work on a better solution!!!

[image] Jeff_Hager: on the other hand, you could retrieve the entire json object and use David’s json transformation column ( Jq (JSON transformation) Column ) to get the values you need. Like this? So, theoretically, this will result in a snappier app? [Screen Shot 2021-09-14 at 12.27.59 PM…

Look at me learning stuff! @Jeff_Hager @david [Screen Shot 2021-09-14 at 12.30.33 PM]

[image] Awesome! Even better that you can join multiple together! Probably a negligible speed improvement unless the api takes a long time to run on the remote server, but definitely reduces the load of having to run it multiple times.

[image] Fetch Column Ask for Help As promised: https://www.youtube.com/watch?v=oWrs8bRNyS4 Current Location works, too! [Screen Shot 2021-09-14 at 12.41.03 PM]

Wow! Did not know you could do that.

Right but I would try to return an array with all values and later using Single Value columns, choose and show the wished values reading the item position in array. This will apply in cases where I want to retrieve more than 4-5 values from JSON payload. But, we have to modify/improve the David’s …

[image] gvalero: This will apply in cases where I want to retrieve more than 4-5 values from JSON payload. David’s JSON Transform column would do that. You pull in the entire JSON string which contains all of the values, and then pick out what you need using the transform column, just like y…

Yes!.. thinking it better, one can put several values separated by comma or slash and get an array using a Split Text column later: E.g: .[0].lat + "/" + .[0].lon + "/" + .[0].temp + "/" + .[1].temp + "/" + .[1].cityname [image] Saludos!

Fetch Column

Ask for Help

Robert_Petitto September 14, 2021, 4:41pm 21

Current Location works, too!

Choose a location using the map

Topic		Replies	Views
NoCodeAPI + Fetch ❤️ Project Showcase	68	4507	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	775	October 19, 2021
🎓 Glide Tutorial - AI Assisted Data Entry Community Resources ai , chatgpt , openai , tutorial	19	898	July 18, 2023
Glide Big Tables API! Get your big table to your google sheet! Community Resources tutorial	5	873	November 1, 2023

Fetch Column

Related topics