How to Save Data From an API to Your Bubble Database | Bubble.io Tutorials
Вставка
- Опубліковано 2 жов 2024
- Hey everyone,
I'm going to be posting more regular answers to questions that come up in the forum (or just questions that people ask me to do videos on). This is the first video in my video coaching newsletter series.
The original forum post is here: forum.bubble.i...
Dude, I've been searching ALL DAY for a single decent tutorial that shows how to do this. Thank you!
Excellent teaching manner, concept is simple and straightforward. You have a talent for instruction, we could use more ADVANCED tutorials with APIs posting and getting, backend workflows, etc,. Please continue with APIs videos and set the path for us to fully learn.
If you create a full course on APIs, the full in and outs using Bubble, I'm sure MANY people will signup! Let's give a thumbs up to let Jacob know we're interested in MORE Videos with API functionality : )
Another Great video.. teaching skill is awesome, thanks a ton... waiting for another video now.. bell icon is clicked👍👍
Great video! I'm VERY VERY interested in the approach you took with your client that you referenced at the end of this video. I've got some external product API feeds I'm pulling into my site that ends up equaling tens of thousands of products and I'm saving all the data to Bubble, so I'm trying to figure out the most effecient approach.
A very important thing to pay attention to: When using "Detect request data" to set the data fields you will use, the Backend Workflow URL wil have "/initialize" in the end. DO NOT FORGET to remove that from the endpoint when testing your workflow, otherwise the call will go to the "initialize" endpoint, and it won't work. Also, don't fortget to remove "/version-test" from the URL when going to production. Spent hours trying to understand why my setu wouldn't work, just because of these two silly mistakes. 🤬🤬
this video + this one comment have saved my life
At 7:52 when we're trying to set the "Type of thing", I do not have the option to choose my API Call from the dropdown list. My API call is set to "Action" but the only options in the "Type of thing" dropdown are Database tables and API calls set to "Data". How is it that "Get Post" above is an "Action" API call but appears in this list of "Types of things"?
I also tried to setup data API calls which do appear in the "Type of thing" dropdown but then there is a type mis-match between this and the "List to run on", results of step 1 as that is a different (action) API call.
Can anyone help or advise on things to try or reasons this might be happening?
Hard to say without looking at editor and seeing how you've set things up! I'd recommend posting about this in the forum with some screenshots.
was there any solution to this problem? I'm in the same situation.
@@emersonsdovale in your settings you need to go to API and add a tick next to the action type API that you want to run. I assume this was glazed over in the video as there is some spelling mismatch between "Get Post" and "Get Posts" which I assume was a previously set-up example.
Yesss! @@joshuabatson4340 Wow. thank you very much, bro
Thank you so much I had this same question a week ago.
Your videos are awesome 👍 You have a fantastic talent in the way you present content clearly. Thank you so much for helping the community. 🙏🙏
Aww thanks Tim! I appreciate the kind words.
Awesome work!! Exactly what I was looking for ... would it be possible to make videos in 1080p rez? After all, it's 2022 ... 720p died at least 10 years ago ... I've attended the funeral 😏
THE BEST!!
I was searching two days for this tutorial. Finally! It works! Thank you so much!
Thanks so much. You help me a lot!
This was great any chance you could should how to save a file from an api call
Thank you for this informative and useful video. Although perhaps obvious to some, please consider the potential for ambiguity in the terminology you use. A “post” in your application seems to be a blog post servicing the business model of your application. Although I could be wrong. Please be aware the semantic risk you are taking in this example is that you are using a term that is an http keyword. Consequently the term “creating a post” can mean several things. I believe your use means “create a record in the Post table of the database “, but I - among others perhaps - cannot be sure. Even though it might seem laborious, repetitive, bothersome and inconvenient , saying “record in the Post table of the database” every time it is referred eliminates ambiguity. Still I come away from your videos that your ultimate goal is to clearly communicate your ideas and be helpful to the community. The less you make listeners work, the more subscribers you will have IMHO. #pleasedisambiguate
HI Jacob, Thanks for your video! I'm strugle with nested parts in the api response. how to solve this? have seen your other video, but I have 3 steps. (tests>parameters>limits) I'm not able to save every "limit" in a record in bubble including in this record the PARAMETER (code, name,...) and the TEST (code, name,...) Thanks a lot for your help ;-)
Great video - Thanks!
Thanks for watching!
The database result are all empty fields on me despite the initiliaze call being okay
Thanks for the video, this is exactly what I was looking for!
Great Video 👍
Hey where's the Bubble API Connector video on your channel that you referenced at 3:15 ? I can't find it but it would be great if you created a Bubble API Connector basics video and a couple of demo examples. Demoing SendGrid and Dropbox DBX Platform in particular would be really useful I think. Any chance???
when u initialize the call a popup window will appear with returned result in tht popup u find raw data at the bottom there u will find this
Thanks, exactly what I needed! Helped a lot, thank you so much! 🙏🏼
Hello, I made an API call then save the results in custom states and display on text fields, so far so good. The json data comes as list too so i created custom states as list to save all the data from the api call. Problem is that when i try to use a chart it doesnt work. I cant choose as datatype or source those custom states and if i use the api call as datatype it doesnt allow me to choose the data from the api call. Ho can i chart with api data? I got a free account , please tell me i dont need to go to backend workflows or save data on bubble database in order to do charts.
Got it to work! Thanks
thans for your post, really helpful 👍🏼🚀
Hi, what to do if the data you are trying to save, in my case downloadable links with documents from an external website , saves as one long string instead of the links being saved separately?
i have not backend workwfows
I am not looking to create data but instead modify it, can this still be achieved by this? But instead of Create data, would i use Make changes to data?
Sorry for the late reply here. You can make changes to a list of things in Bubble. Normal workflow action. Have you tried that?
What if the api returns a the list of results in a parent object named `results`? Hubspot does this and when using these steps, I keep getting errors when trying to set up the "Schedule API Workflow on a list" step. Another example is if we were using the deck of cards API and we wanted to store all of the drawn cards in the database. How would we do that?
Love the videos. Any idea when your videos is coming out on some of the other solutions to high row counts? I have a few data streams I'm looking to bring into bubble, and am interested in some of the approaches to larger scale data writing into the bubble DB.
Same
good, any solution for recursive workflow? unfortunately API endpoints won't take API objects as parameters :(
How would I connect the information from the api database to specific user, such as a specific users post in your case? Thank you for the video btw
Oh thanks a lot !!! You save me a lot of hours of searching and testing :)
I have a question : If we click many times to the button " Create Post", how to update only several item of the db loaded from the API if only few of them changed, without to be obliged to upload the entire db and without doublons (duplicated item) ?
Man, THANKS
Thanks a lot broooo! This is super usefull :)
Thanks for this! How would one set it up so that it updates data in that list on a new call/ GET, vs repopulating it from scratch?
Great video! It helped me very much. Can't wait for your video on how to speed up the process. Looks like customs states would help!
I'm trying to do this exact thing but instead of creating a new thing. I'm trying to make changes to a already existing database. I want to just update the price of a product via the live api data and use the manufacturer # to make sure that the right item is getting changed. I'm struggling to get it working any suggestions?
In workflow actions you'll find "Make changes to a list of things."
@@jacobgershkovich This worked perfectly thank you. One more question. I just want to pull the external data into the backend directly every couple of hours say 6 skipping the front end. Any suggestions?
I want to ask, why should we store API data in ubbble database? what is advantage and disadvantage.
Lots of different reasons why you might want to I think. Having control over the data is probably the biggest one though.
@@jacobgershkovich Okay.. Thank you so much.. One more thing what if we store data to database from page workflow actions rather than backend workflow? I mean creating thing in DB from page workflow itself. Do you recommend that?
Thanks for the video! I am on the free plan so got stuck at the 'scheduled date' in the workflow. This feature is only available in a paid plan, so in preview it exits before the API call.
Is there a way to get around this for first trial app through-and through? To be clear: I don't mind paying for the service, but need to see the full functionality :D 😀
did u manage to solve this?
perfect man, i love you
PS. There seems be to a change to the Menu settings in the Backend workflows since the video has been made. In the video at 6:14, there is a setting missing. In my file you have to choose between POST and GET. Using POST got mine working
Thanks for pointing this out.
Great video, to the point. Thanks
I've been working on an API call and subsequent webhook response. Still struggling to parse the webhook response to create a new thing. What's the best way to get in touch?
Hey Kyle! I don't offer coaching at the moment but that will likely change soon. In the meantime, I'd recommend posting about the specific problem in the Bubble forum.
@@jacobgershkovich I tried the forums and had a little support but the solutions aren't working for me so far. I am hiring a freelancer to see if he can figure it out. Thank you.
You're a lifesaver
Thank you soooo much !!!
Hi Jacob, did you come up with a way of increasing the speed of the API workflow? I currently have to import & create "only" 400 things with around 20 data points each. Even though its only 400 things being created, the workflow takes quite some time... Any tips? :)
Check this video out: ua-cam.com/video/ZaD9AIegH5A/v-deo.html
@@jacobgershkovich Just watched the video. Insane tutorial! Thanks a lot. You're always one step ahead of my learning needs. :)
Thanks for this guide, I got it to work with saving basic user details such as name and email. However, pressing the button again would also save the same exact details. What conditions can I apply so that it searches for an existing email first so that when I add another data to the API, only the new ones will get added?
It'll be something like this: Create a new thing only when "Do a search for ____ where email = response's email" count is 0
@@jacobgershkovich That worked. Thanks a lot!!
Hi Jacob! Your content is great man! I noticed that if I call the API again Bubble saves again the same data to the database. Therefore, duplicates are created. Is there a way to only save new data in the database and avoid duplicates?
Thanks Nick! You could write an expression that checks this in the "only when" section of your workflow action when you're creating a new thing.
@@jacobgershkovich Many thanks!!
This is pure gold!! Thanks!
How do you create a mapping if one field in the table refers to another field? Let's say we have a nested json, with a parent field and a list of multiple fields that are related to it. How do I loop through the child list and map it to the parent field?
You can schedule other backend workflows!
@@jacobgershkovich so a workflow within a workflow?
Good Job Jacob.
You saved some hours for me!
Thanks !
Glad I could help!
Hugely helpful video. Thanks so much. A medal is deserved!
Thanks Ben!
Can We have users from bubble app get data from their Social media accts?
Yeah, definitely possible.
Very usefull and clear! Thank you
Glad it was helpful!
Amazing!
Thank you!
Thanks for watching!