How to Optimize Bulk Insertion in Bubble from an API Response?

Need help
1

image
image346×799 23 KB

image
image920×942 32.2 KB

I’m working on a project where I retrieve a list of data from an external API (as shown in the images above). The API returns the data as a list, and currently, I am traversing through this list and creating individual entries in the database using a backend workflow.

While this approach works, it takes a significant amount of time since I am processing and storing each entry one by one.

Here’s what I have done so far:

  1. I fetch the data from the external API as a list.
  2. I loop through the list using “Schedule API Workflow on a list”, and for each item, I run another backend workflow to create a new database entry.

I want to optimize this process to insert all entries in bulk instead of creating them one by one. Is there a way in Bubble to handle bulk insertion efficiently?

Any guidance or suggestions would be greatly appreciated!

Thanks in advance. :blush:

2

I do a lot of similar stuff with the bulk API: Data API requests | Bubble Docs

3

sorry i haven’t found any solution related to my issue. Please can you help me to solver over my issue?

4
  1. Click the link
  2. Read the info
    2a. Google the various tutorials out there.
  3. Try it out on your app

I’m at a loss of how else I can help you. :man_shrugging:

5

Hi @rico.trevisan
i have seen that but i cannot found the same issue as i am facing.