Glide 101: EVERYTHING You Need to Know About Call API and Query JSON

[@victorramos8296]

Starting off the year with new knowledge from Bob! Thank you for putting this valuable resource out there!

[@lawrencechiu]

Thanks for the amazing tutorial. Im preparing myself to build my next glide app with various API call. This is definitely a big thumb up for such a clear breakdown on API setup and structuring. your presentation and teaching are really solid. Will definitely continue to follow your tutorial! Thank you!!

[@andrewpndavies]

Wish I could give this more than 1 thumbs up! It's superb. Thanks Bob!

[@RobertPetittoWA]

Thanks for the kind words!

[@SeryJoel-y7z]

Woooooow.... ooooh God !! How marvelous u teach so easily ... Thank u Bob

[@RobertPetittoWA]

You are very welcome

[@PatchitForward]

Giving it a thumbs-up just because you posted it, 😊 will watch it this afternoon

[@RobertPetittoWA]

Ha! Let me know if it’s helpful!

[@PatchitForward]

It was SO helpful - exactly the level of instruction I was looking for. Can't wait to give it a shot now. (KB) @@RobertPetittoWA

[@erwinblom]

You're the best Robert, this is do good and helpful!

[@RobertPetittoWA]

Glad it was helpful!

[@DarrenHumphries]

Oooo, I didn't know about that single value-whole row trick. Nice!

[@RobertPetittoWA]

Oh ya! I have a whole video dedicated to it.

[@adityapanduperdana930]

Hi robert, i always watch your video, its very helpful for me, For next tutorial please build integration glide with payment gateway midtrans (indonesia), Thankyou robert, 🎉

[@RobertPetittoWA]

Interesting! I’ll need to research a bit.

[@adityapanduperdana930]

@@RobertPetittoWA yeeaayy.. thankyou so much

[@alsaukh3]

Very useful👌👍 Thanks a lot👋

[@RobertPetittoWA]

You are welcome!!!

[@gamifycompany4179]

Fabulous!

[@RobertPetittoWA]

Appreciated!

[@cqajagsaw]

so if i want to display more that 5 i would just need to add more rows in search resul table?

[@RobertPetittoWA]

Correct!

[@Cameraville]

Is it all taxing to have an AllRowIDs column with many ids in each cell - such as 1000? I often like to weigh the cost vs benefit of each piece of data I am creating, and if something adds to loading time I'd like to understand that.

[@RobertPetittoWA]

No. I haven’t seen any degradation of performance while using this method

[@Cameraville]

Thank you 👍@@RobertPetittoWA

[@Imbackoutside]

is it possible to turn a api result into a string property to query from another table?

[@RobertPetittoWA]

You’d have to do some transformations on the result, but sure can!

[@Imbackoutside]

@@RobertPetittoWA any articles you can refer me too?

[@RobertPetittoWA]

Anything related the JSON Query column

[@Imbackoutside]

@@RobertPetittoWA ok thanks!

[@Imbackoutside]

@@RobertPetittoWA I found the lost comment lol. I can’t find any documentation on this.

[@divers5193]

Amazing, thanks a lot ! Would there be a way to do an instant search, to have the result while I am taping without having to press the button search ?

[@RobertPetittoWA]

Probably, but it might eat up updates

[@elijahmadonia]

Can we do a call that requires an authorization? For example my users want to connect their Apple Health data for my fitness app.

[@RobertPetittoWA]

I haven’t found a clean way to do this yet. You’d need to use a 3rd party platform like extend.io

[@sixbrixs]

Hello Robert Thanks for the tutorial. Is it even possible to call the API with the Glideapp PRO plan? Or does it need the BUSINESS plan? Greetings Jan

[@RobertPetittoWA]

At this time, you need business plan to use Call API. This was a change Glide made shortly after releasing the feature.

[@EdCriesOfRedemptionSilva]

@@RobertPetittoWA Great video! It was a bucket of cold water when I got to the part where I had to call the API only to find out we now have to upgrade to business and I just upgraded to Pro. Anyhow, it was an absolutely great video. Unfortunately, I can't afford such a useful feature at this time. Keep up the good work. I am going to have to change platforms because of this.

[@vrasdinand3225]

hello Robert Im collumn Query JSON error for THIS

[@Ahmed_Abdrraheem]

Awesome!!

[@RobertPetittoWA]

Sure is!

[@syncros25]

seems like that works differently right now in glide.... Query JSON is kind of predefining the values... which is great, but how I can break the response to single rows ?

[@syncros25]

Solved it, but it was way more simple at generic to brake it up by indexnumber... is there a best practice, to just brake up the response ?

[@RobertPetittoWA]

You bet. Need to use index number. After seeing that this is what currently needs to be done, David mentioned that he’s going to look into improvements

[@theaiboxer]

I think I finally get how to call api

[@RobertPetittoWA]

Amazing! Let me know if you need any pointers

[@FloNocode]

Just insane your tutorial ! I would like to know if its possible to add a summarize of books generated with Chat GPT ?

[@RobertPetittoWA]

This books API does include a complete description field that I didn’t include in the JSON extraction. However, if you want to ChatGPT to create a different one, then, yes, as long as ChatGPT knows the title of the book.

[@FloNocode]

@@RobertPetittoWA hi thanks for you return, i am not familiar with Json and API. I need to learn more about that. Thanks for your tutorial i dont believe that glide will Can make this kind of things

[@cryptian8730]

Hi there Robert, i just purchased your template. Only to find out that visitors cannot register by themselves in Glide to become either sellers or consumers on the marketplace. All users have to be created upfront. Is it possible to build this within Glide? if so, im interested.

[@RobertPetittoWA]

Are you referring to the marketplace template? Yes, it’s possible to add that functionality directly in the app. Book a time with me to learn how: Https://calendly.com/robert-petitto

[@phyominmyat]

if i click save button twice and it's make duplicate item and also how to unsave it?

[@RobertPetittoWA]

What's the source data? Google Sheets or Airtable? Or are you using Glide Tables?

[@phyominmyat]

@@RobertPetittoWA Thank you Robert , i got it , i add condition in button action.

[@brettvandermolen7930]

Robert, your videos have been immensely helpful! I've watched and rewatched many as I've been learning Glide. Do you know if Glide can stream audio from an API call? I'm getting what appears to bet the correct response from the API I'm using, I just don't know how to get the audio to play.

[@RobertPetittoWA]

What response are you getting? The only way to play audio in Glide is with the audio component (or web embed)

[@soyjaviamat]

I can't find Call API action, do I have to do something before?

[@mandarkapse1704]

I guess you will have to switch it on from preview feature on glide

[@RobertPetittoWA]

Enable it in Preview menu at the team folder level

[@soyjaviamat]

Thanks @@RobertPetittoWA I've done, but copying your steps I get "Call API: No response", and I've checked the endpoint and the parameters in postman and it's ok

[@hakureisan5093]

Robert, your explanation is very didactic, and I like it. However, I have a question: What happens if the returned quantity in the JSON is dynamic? In one query, it returns 5 records, in the next 10, etc. How would I display all these rows in the table? Please, your assistance.

[@RobertPetittoWA]

Currently, you would need to create as many rows as you think the dynamic content would fill. There’s no way to create a dynamic table size in Glide yet.

[@joshhinden67]

@@RobertPetittoWAcan use the glide api to automatically add a row for each result possibly?

[@RobertPetittoWA]

Yes.

[@porszy26]

Hi Robert, I recently became a VIP member. How do I access this app please? Thanks

[@RobertPetittoWA]

Thanks for the reminder! Will add this template by tomorrow.

[@Conta_antiga373]

I've been watching your videos, always with subtitles in automatic KZbin translation, but this one isn't translating, unfortunately.

[@RobertPetittoWA]

oh no! anything I can do?

[@Conta_antiga373]

​@@RobertPetittoWANow it's ok, with subtitles in Portuguese, I'll watch it. thanks.