How to Create Data in Bulk

Hey everyone. I released a video a while ago that dealt with saving data received from an API in your Bubble database. In that video I demonstrated how to use the “Schedule API workflow on a list” action. While this method works great for a lot of different use cases, it’s certainly not the FASTEST way to go when you have to create many things at once…

I just released a follow up video that shows you how to create up to 1000 things at once. You can watch that here! https://youtu.be/ZaD9AIegH5A

8 Likes

Hello I’m trying to use this feature, but data I want to get from the API is a little bit more complex. I need to get into the app:

  1. id
  2. organization_id
  3. Investor name
  4. Investor email

Not sure what to put exactly in the API connector in body parameters.

This is an example from the API:

    {
      "data": [
        {
          "id": 0,
          "organization_id": 0,
          "investor": {
            "id": 0,
            "name": "string",
            "status": "Active",
            "investor_url": "string",
            "description": "string",
            "location_country": {
              "id": 0,
              "name": "string"
            },
            "location_state": {
              "id": 0,
              "country_id": 0,
              "name": "string"
            },
            "location_city": {
              "id": 0,
              "state_id": 0,
              "name": "string"
            },
            "types": [
              {
                "investor_type": "Venture Capital"
              }
            ],
            "investment_stages": [
              {
                "investment_stage": "Early Stage Venture"
              }
            ],
            "industries": [
              {
                "industry": {
                  "id": 0,
                  "name": "string"
                }
              }
            ],
            "website": "string",
            "twitter": "string",
            "facebook": "string",
            "linkedin": "string",
            "email": "string",
            "phone_number": "string",
            "added_value": "string",
            "red_flags": "string",
            "source": "IMPORTED"
          },
          "scoring": 0,
          "normalized_score": 0,
          "score_industry": 0,
          "score_localization": 0,
          "score_money_raised": 0,
          "score_region": 0,
          "score_funding_stage": 0,
          "score_hq_country": 0,
          "score_hq_region": 0
        }
      ],
      "total": 0,
      "limit": 0,
      "start": 0
    }
    ```