Parse JSON to separate DB items

Hi All, I’ve seen this topic come up a few times but need a definitive answer please. I’m trying to fetch a list of data points for 100 items via API call,

I then want 100 rows to be created in the DB with fields populate from JSON data. I’ve got a work flow which seems to work by fetching the data and then trying to enter it into the POST request body but the loading bar stalls and no data is created (see attached setup).

I’ve manually tested the POST request with one row and it and works but can’t manage 3 rows with data from the API. I’ve seen people suggesting a paid plugin but do I have any other options? Thanks!



To create a list of items in Bubble.io without using any plugins, follow these steps:

  1. Create an API Workflow:

Go to the Backend Workflows tab (ensure API workflows are enabled in your app settings).

Create an API workflow (e.g., create_item).

Add the necessary parameters to this workflow (e.g., name, description, etc.).

Inside the workflow, use the Create a New Thing action to create a single item using the parameters.

  1. Schedule API Workflow on a List:

In your Bubble editor, choose the Schedule API Workflow on a List action.

Select the create_item workflow you created earlier.

  1. Pass the Data as a List:

To pass the API response as a list, the API call must be set up as a Data Type API Call in the API Connector.

Initialize the API call in the API Connector. Bubble will infer the data structure from the response and automatically generate a corresponding content type for the list.

Use this content type as the Type of Content when scheduling the API workflow.

  1. Set the Data Source for the List:

In the Schedule API Workflow on a List action, set the Type of Content to the list type generated from your API call.

For the Data Source, use External API Data Source and select your API call.

From the API call’s response, choose the specific list you want to use.

  1. Pass Parameters for Each Item:

When setting up the parameters for the API workflow, use dynamic expressions to map the properties of each item in the list to the corresponding parameters.

Bubble will process each item in the list individually and execute the API workflow for each item.

1 Like

I am on mobile, sorry if my response is not understandable, if you like i can Walk you through it.

Thanks so much for your response @Baloshi69 I will try your method in the morning and send a response!

Hey @Baloshi69 thanks again for your advice but I’m not sure how to configure the scheduled backend workflow to run on the list of items? I’ve configured the backend workflow as shown and now I’m trying to call it from the front-end one but I don’t see how to format the input?


Hey, i can give you a walk throuh if you like , ping me when every you online if i was too will love to help you.