Creating data entries from Airtable API call

Hey i’m using an Airtable GET call in Bubble’s API Connector to pull in some records and I want to create data entries in Bubble for each record.

Right now while testing, I just set up a button with a Workflow to do:

Step 1: Airtable API Call

Step 2: Create a new thing > Data Entry Name > Name = Result of Step 1, Record’s Name

I’m successfully creating data entries, but instead of creating 5 entries for the 5 records that are returned from Airtable, it’s just putting all 5 of the records (names) into one database entry on Bubble.

Does anyone know how to create one entry per returned record?

Currently how the database entry gets created

The Airtable response:

{
"records": [
    {
        "id": "recYKumRJ8oNM7L5u",
        "fields": {
            "Name": "Kristin"
        },
        "createdTime": "2020-05-16T22:35:50.000Z"
    },
    {
        "id": "recbVuG9qqrtD2zwb",
        "fields": {
            "Name": "Christian"
        },
        "createdTime": "2020-05-15T20:55:51.000Z"
    },
    {
        "id": "recpe52X3p5yR4R7o",
        "fields": {
            "Name": "Jack"
        },
        "createdTime": "2020-05-15T20:55:51.000Z"
    },
    {
        "id": "recrAVkSIUtivwdUg",
        "fields": {
            "Name": "Heymarket"
        },
        "createdTime": "2020-05-16T22:57:57.000Z"
    },
    {
        "id": "recu0bXHHkSR6SCSO",
        "fields": {
            "Name": "Jack Google Voice"
        },
        "createdTime": "2020-05-15T20:55:51.000Z"
    }
]
}

Update: found and am reading this: Need help writing to database with list called from api source

Hopefully it’s the solution.

1 Like