Тёмный

How to Save Data From an API to Your Bubble Database | Bubble.io Tutorials 

Jacob Gershkovich
Подписаться 3,7 тыс.
Просмотров 28 тыс.
50% 1

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...

Опубликовано:

 

25 янв 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 83   
@thinkjon
@thinkjon 2 года назад
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 : )
@andreewendel9291
@andreewendel9291 2 года назад
I was searching two days for this tutorial. Finally! It works! Thank you so much!
@TechAuditTV
@TechAuditTV 2 года назад
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.
@NadeemWBR
@NadeemWBR 2 года назад
Another Great video.. teaching skill is awesome, thanks a ton... waiting for another video now.. bell icon is clicked👍👍
@mrhero199702
@mrhero199702 2 года назад
Thanks for the video, this is exactly what I was looking for!
@jsebastianmunch
@jsebastianmunch 2 года назад
Thanks, exactly what I needed! Helped a lot, thank you so much! 🙏🏼
@sergeyauts
@sergeyauts 2 года назад
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!
@timgarrett1255
@timgarrett1255 Год назад
Your videos are awesome 👍 You have a fantastic talent in the way you present content clearly. Thank you so much for helping the community. 🙏🙏
@jacobgershkovich
@jacobgershkovich Год назад
Aww thanks Tim! I appreciate the kind words.
@sprintersprinter1307
@sprintersprinter1307 2 года назад
This is pure gold!! Thanks!
@MrBrrclifford
@MrBrrclifford Год назад
Hugely helpful video. Thanks so much. A medal is deserved!
@jacobgershkovich
@jacobgershkovich Год назад
Thanks Ben!
@shinonguyen1098
@shinonguyen1098 2 года назад
Thank you so much I had this same question a week ago.
@petrinnn
@petrinnn Год назад
Good Job Jacob. You saved some hours for me! Thanks !
@jacobgershkovich
@jacobgershkovich Год назад
Glad I could help!
@nalbano4
@nalbano4 2 года назад
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.
@fernandofischer3725
@fernandofischer3725 9 месяцев назад
Same
@mr.h3758
@mr.h3758 11 месяцев назад
Great video, to the point. Thanks
@WillianTeodosio
@WillianTeodosio Год назад
Thanks so much. You help me a lot!
@thatjasonr
@thatjasonr Год назад
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?
@Pimous
@Pimous 2 года назад
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) ?
@AurelienBRIANT
@AurelienBRIANT Год назад
Great video - Thanks!
@jacobgershkovich
@jacobgershkovich Год назад
Thanks for watching!
@anastasialis7736
@anastasialis7736 Год назад
Amazing! Thank you!
@jacobgershkovich
@jacobgershkovich Год назад
Thanks for watching!
@deepaksubash7335
@deepaksubash7335 Год назад
Great Video 👍
@temshik_papa
@temshik_papa 7 месяцев назад
perfect man, i love you
@CriptoBroh
@CriptoBroh Год назад
Thanks a lot broooo! This is super usefull :)
@AdministrativoBridge
@AdministrativoBridge 2 месяца назад
THE BEST!!
@lucianaelisa9501
@lucianaelisa9501 Год назад
Very usefull and clear! Thank you
@jacobgershkovich
@jacobgershkovich Год назад
Glad it was helpful!
@IkeSpeaksUp
@IkeSpeaksUp 10 месяцев назад
You're a lifesaver
@garyjehan8918
@garyjehan8918 Год назад
Thank you soooo much !!!
@tobialtamirano4098
@tobialtamirano4098 Месяц назад
Man, THANKS
@honestiguana
@honestiguana Год назад
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. 🤬🤬
@opaidios
@opaidios 7 месяцев назад
this video + this one comment have saved my life
@Taylor20211
@Taylor20211 2 года назад
This was great any chance you could should how to save a file from an api call
@chrisanderson4910
@chrisanderson4910 Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
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.
@emersonsdovale
@emersonsdovale 10 месяцев назад
was there any solution to this problem? I'm in the same situation.
@joshuabatson4340
@joshuabatson4340 9 месяцев назад
@@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.
@emersonsdovale
@emersonsdovale 9 месяцев назад
Yesss! @@joshuabatson4340 Wow. thank you very much, bro
@VogelaarVredehof
@VogelaarVredehof Год назад
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 ;-)
@IsaacBG84
@IsaacBG84 4 месяца назад
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.
@jamessteele53
@jamessteele53 Год назад
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
@jacobgershkovich
@jacobgershkovich Год назад
Thanks for pointing this out.
@Carol-uz8pr
@Carol-uz8pr Год назад
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
@chelseyfoster7260
@chelseyfoster7260 Год назад
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?
@clarissavanrooy9948
@clarissavanrooy9948 2 месяца назад
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?
@PhilippeLarcher
@PhilippeLarcher Год назад
good, any solution for recursive workflow? unfortunately API endpoints won't take API objects as parameters :(
@SB-yb3us
@SB-yb3us 2 года назад
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 😀
@kruvio
@kruvio Месяц назад
did u manage to solve this?
@htmlfivedev
@htmlfivedev 2 года назад
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 😏
@alexlefkowitz
@alexlefkowitz 2 года назад
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???
@RogerWoods-bi6pb
@RogerWoods-bi6pb Год назад
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
@onlyhcfreak
@onlyhcfreak Год назад
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? :)
@jacobgershkovich
@jacobgershkovich Год назад
Check this video out: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ZaD9AIegH5A.html
@onlyhcfreak
@onlyhcfreak Год назад
@@jacobgershkovich Just watched the video. Insane tutorial! Thanks a lot. You're always one step ahead of my learning needs. :)
@kimokimooooo
@kimokimooooo Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
It'll be something like this: Create a new thing only when "Do a search for ____ where email = response's email" count is 0
@kimokimooooo
@kimokimooooo Год назад
@@jacobgershkovich That worked. Thanks a lot!!
@LabFloss
@LabFloss Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
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.
@LabFloss
@LabFloss Год назад
@@jacobgershkovich Many thanks!!
@salesgurupro
@salesgurupro Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
You can schedule other backend workflows!
@salesgurupro
@salesgurupro Год назад
@@jacobgershkovich so a workflow within a workflow?
@DavJonesy
@DavJonesy Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
Sorry for the late reply here. You can make changes to a list of things in Bubble. Normal workflow action. Have you tried that?
@Scuurpro
@Scuurpro Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
In workflow actions you'll find "Make changes to a list of things."
@Scuurpro
@Scuurpro Год назад
@@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?
@kyleandrewpittman
@kyleandrewpittman Год назад
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?
@jacobgershkovich
@jacobgershkovich Год назад
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.
@kyleandrewpittman
@kyleandrewpittman Год назад
@@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.
@VictorHernandez-nz2rs
@VictorHernandez-nz2rs Год назад
Can We have users from bubble app get data from their Social media accts?
@jacobgershkovich
@jacobgershkovich Год назад
Yeah, definitely possible.
@giraty50
@giraty50 Год назад
The database result are all empty fields on me despite the initiliaze call being okay
@pratimadudhewar3680
@pratimadudhewar3680 Год назад
I want to ask, why should we store API data in ubbble database? what is advantage and disadvantage.
@jacobgershkovich
@jacobgershkovich Год назад
Lots of different reasons why you might want to I think. Having control over the data is probably the biggest one though.
@pratimadudhewar3680
@pratimadudhewar3680 Год назад
@@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?
@romanmed9035
@romanmed9035 3 месяца назад
i have not backend workwfows
@flat5th
@flat5th 2 месяца назад
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
Далее
How data moves through your app - for Bubble beginners
31:26
Learn JSON in 10 Minutes
12:00
Просмотров 3,1 млн
Четыре тормоза
00:53
Просмотров 45 тыс.
КТО ЭТО БЫЛ?
25:31
Просмотров 1,1 млн
Впервые дал другу машину…
00:57
Просмотров 942 тыс.
Schedule API on a List | Bubble.io Tutorial
10:04
Просмотров 17 тыс.
A Beginner's Guide to Data Sources in Bubble.io
9:36
How to FETCH data from an API using JavaScript ↩️
14:17
How to Use URL/Page Parameters in Bubble.io
16:52
Просмотров 21 тыс.
Четыре тормоза
00:53
Просмотров 45 тыс.