Glide 101: EVERYTHING You Need to Know About Call API and Query JSON
HTML-код
- Опубликовано: 28 июл 2024
- Let's take a step back and learn about calling APIs and viewing JSON responses within a Glide App.
In this video, you'll learn how to:
- find API endpoints that you can use in a Glide App
- create API endpoints using a Construct URL column
- call the API using the Call API action
- fetch and read the JSON response
- parse items within a JSON array onto their own row in Glide using the Miracle Method ( • Glide: Transpose Data ... )
- query a JSON object in order to extract singular values from the JSON response
- display the parsed results in a Glide Collection
- take action on a search result
🚀 Start building your Glide app today: join.glideapps.com/robert
💎Grab a copy of this app by becoming a Glide VIP member!
/ @robertpetittowa
👔 Hire me to build your Glide app:
join.glideapps.com/glideexpert
00:00 - Intro and Setup
01:58 - The Terminology
03:33 - Setting Up a Work Table
05:14 - Determine the API Server to Call
07:00 - Construct the Endpoint URL in Glide
09:18 - Build Search Interface
10:32 - Setting up the Call API Action Button
11:17 - Inspecting the JSON Response
13:19 - Parsing JSON Array Items onto Their Own Row
17:56 - Query the Response Array by Line Item
20:57 - Extracting Values from a JSON Object Using a Query JSON Column
24:12 - Testing the Call API
25:40 - Allow Users to Save Data Generated by the Call API Action
27:39 - Relating the Results Table to the Work Table
28:35 - Finishing the App with a My Library Screen
30:37 - Outro
@glideapps Наука
Woooooow.... ooooh God !! How marvelous u teach so easily ... Thank u Bob
You are very welcome
You're the best Robert, this is do good and helpful!
Glad it was helpful!
Giving it a thumbs-up just because you posted it, 😊 will watch it this afternoon
Ha! Let me know if it’s helpful!
It was SO helpful - exactly the level of instruction I was looking for. Can't wait to give it a shot now. (KB) @@RobertPetittoWA
Very useful👌👍 Thanks a lot👋
You are welcome!!!
Oooo, I didn't know about that single value-whole row trick. Nice!
Oh ya! I have a whole video dedicated to it.
Awesome!!
Sure is!
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, 🎉
Interesting! I’ll need to research a bit.
@@RobertPetittoWA yeeaayy.. thankyou so much
I think I finally get how to call api
Amazing! Let me know if you need any pointers
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.
What response are you getting? The only way to play audio in Glide is with the audio component (or web embed)
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 ?
Probably, but it might eat up updates
Just insane your tutorial ! I would like to know if its possible to add a summarize of books generated with Chat GPT ?
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.
@@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
hello Robert Im collumn Query JSON error for THIS
so if i want to display more that 5 i would just need to add more rows in search resul table?
Correct!
Can we do a call that requires an authorization? For example my users want to connect their Apple Health data for my fitness app.
I haven’t found a clean way to do this yet. You’d need to use a 3rd party platform like extend.io
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.
No. I haven’t seen any degradation of performance while using this method
Thank you 👍@@RobertPetittoWA
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
At this time, you need business plan to use Call API. This was a change Glide made shortly after releasing the feature.
@@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.
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.
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
Hi Robert, I recently became a VIP member. How do I access this app please? Thanks
Thanks for the reminder! Will add this template by tomorrow.
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 ?
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 ?
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
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.
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.
@@RobertPetittoWAcan use the glide api to automatically add a row for each result possibly?
Yes.
is it possible to turn a api result into a string property to query from another table?
You’d have to do some transformations on the result, but sure can!
@@RobertPetittoWA any articles you can refer me too?
Anything related the JSON Query column
@@RobertPetittoWA ok thanks!
@@RobertPetittoWA I found the lost comment lol. I can’t find any documentation on this.
I can't find Call API action, do I have to do something before?
I guess you will have to switch it on from preview feature on glide
Enable it in Preview menu at the team folder level
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
I've been watching your videos, always with subtitles in automatic RUclips translation, but this one isn't translating, unfortunately.
oh no! anything I can do?
@@RobertPetittoWANow it's ok, with subtitles in Portuguese, I'll watch it. thanks.