I want to load information into bubble using an external ETL application to write the data into the bubble DB.
I can support a myriad of write and export options inc posting to an endpoint, but I can’t find anything that explains how to do it. Lots of articles and posts on connecting external DBs, loading via a csv or getting bubble to import, but none of these fit the use case.
Is there not a bulk api or somethign that I can post rows to, so they’re created in bubble as records?
If you can call an API within that application, you can achieve this in two ways in Bubble.io: using Data APIs directly or workflow APIs.
I suggest generating an API token in Bubble so you can authenticate the call to Bubble.io. A token is necessary for Data APIs, but you can use it optionally with workflow APIs.
Data APIs are more difficult, so I suggest using backend APIs with authentication using the token generated in Bubble.io.
Just create an API workflow with parameters you want to expose publicly so you can call it. Also, uncheck the bottom checkbox that says this call can run without authentication.
Then, inside the API workflow, create or update your data.
The API URL will be ‘https://yourdomain/version-(live or test)/api/1.1/wf/’. You can also find this in your settings.
Now, for Data APIs—they are faster but harder. You have to match the exact naming and type of parameters you want to update in the entity.
You can contact me, and I would be happy to help you without charge. See my profile contact information here, on LinkedIn, or contact me via WhatsApp.
items must be separated by a new line. make sure the data api is enabled for that thing, and you can load existing json data for that thing in your browser through https://[Project Name].bubbleapps.io/[Version]/api/1.1/obj/[Thing Name] to understand what the fields look like exactly.
