🌐 Please help us test: API Column and Webhook action

[Robert_Petitto]

It’s my work device

[Drearystate]

So your a PC guy?

[Drearystate]

I honeslty have never used a Apple anything other than an iphone and that is just to fix them…so never really used Apple.

[Robert_Petitto]

Not anymore—been on a Mac so long now that it would be painful to switch back to windows.

[Drearystate]

See, I was thinking about this the other day. If by some miracle I won the Mac book I would have to learn how to use it…that’s just really sad.

[Robert_Petitto]

Just figured out Giphy!!!

[Drearystate]

Robert, I’m gonna drift off to sleep tonight and wake up to you acccessing NASA’s API and watching live video feeds from the ISS (I did this yesterday) on Glide. Please sir…control yourself

[Drearystate]

BTW it was a huge waste considering NASA has a live channel on youtube you could embed and stream…

[erwblo]

It’s good for you to leave your comfort zone

[V88]

Apple = different world.

I switched 10 years ago. Have to dabble back in the “dark side” with some (unfortunate) customers.

[Darren_Murphy]

Same. Haven’t touched anything MS related in about 12 years. Last version of Windows I remember using was XP.

[david]

I’ve made a GitHub repo with sample code and instructions for deploying your own Glide API endpoints: https://github.com/glideapps/glide-api

[Robert_Petitto]

I still don’t get it…how would I call a public API, say unsplash, with this endpoint?

[david]

You would call the Unsplash API using JavaScript from this endpoint, and return an Unsplash image URL as a string value.

If you are not familiar with JavaScript and calling APIs from code, you will have a very hard time making it work–this is a specialized technical feature not meant for most Glide developers!

[Robert_Petitto]

Rats. Is it a similar method to Glitch server? I managed to figure that one out last night!

[Jeff_Hager]

@Mark @david. Maybe this is something to consider long term for API integration.

Using App Script with a JSON API

For complex JSON structures, it would be awesome if glide created an entire separate glide table from the JSON object. They could set it up to pull input values from another sheet, then populate the results from the API in a separate table, complete with headings and data. This is technically what I’m already doing with ImportJSON in the google sheet. I have a personal app where I get data from the API of a campground reservation system to populate an entire sheet with data from one of my fav…

[david]

@Robert_Petitto

Is it a similar method to Glitch server?

It’s more or less the same.

[Robert_Petitto]

Open Weather Map!

@Mark this API specifically requires me to switch screens before it refreshes.

Glide · Create Apps from Google Sheets

[Mark]

@Robert_Petitto Your endpoint is not returning if the input is not a valid ZIP code, it seems, which causes Glide to not update. As soon as you start typing Glide will query the API, even if the input is not complete yet, but if a request never returns Glide doesn’t try again. Arguably that’s a bug on Glide’s side, but it’s also definitely a bug in your endpoint

[Robert_Petitto]

I’m learning! Maybe we can discuss this Monday. Thanks for taking a look!