How to Save Data From an API to Your Bubble Database | Bubble.io Tutorials
Vložit
- čas přidán 25. 01. 2022
- 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.io/t/saving-json...
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 : )
I was searching two days for this tutorial. Finally! It works! Thank you so much!
Thanks, exactly what I needed! Helped a lot, thank you so much! 🙏🏼
Thanks for the video, this is exactly what I was looking for!
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.
Thank you so much I had this same question a week ago.
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!
This is pure gold!! Thanks!
Hugely helpful video. Thanks so much. A medal is deserved!
Thanks Ben!
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.
Thanks so much. You help me a lot!
Good Job Jacob.
You saved some hours for me!
Thanks !
Glad I could help!
Great video, to the point. Thanks
Thanks a lot broooo! This is super usefull :)
Great Video 👍
Great video - Thanks!
Thanks for watching!
Amazing!
Thank you!
Thanks for watching!
Very usefull and clear! Thank you
Glad it was helpful!
Thank you soooo much !!!
perfect man, i love you
THE BEST!!
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
Man, THANKS
You're a lifesaver
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
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) ?
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?
This was great any chance you could should how to save a file from an api call
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 ;-)
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 😏
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.
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
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?
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?
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.
good, any solution for recursive workflow? unfortunately API endpoints won't take API objects as parameters :(
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
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?
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 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!!
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?
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!!
The database result are all empty fields on me despite the initiliaze call being okay
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: czcams.com/video/ZaD9AIegH5A/video.html
@@jacobgershkovich Just watched the video. Insane tutorial! Thanks a lot. You're always one step ahead of my learning needs. :)
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?
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'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.
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?
Can We have users from bubble app get data from their Social media accts?
Yeah, definitely possible.
i have not backend workwfows
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