Insert "Batch of Rows" to Airtable

[dunncrew]

Hi, When writing records to SQL, I see an option to insert a "Batch of Rows", but I don't see that "batch" option in Airtable, so I am guessing I have to write 1 row at a time somehow ? Probably just 10 - 20 records when it runs.

Any suggestions? 

[GrailAutomation · Accepted solution]

Hi @dunncrew! The Workato connector for Airtable natively supports creating 1 record at a time... but it also includes a Custom Action, which you could use to insert a batch of records (up to 10 at a time, according to Airtable's API documentation). Instructions:

1. Add action to your recipe (app = Airtable, action = Custom Action)
2. In the action setup, click Start Guided setup
3. Method = POST
4. Path = https://api.airtable.com/v0/{baseId}/{tableIdOrName} 
5. Request body =

{
    "records": [
      {
        "fields": {
          "Address": "333 Post St",
          "Name": "Union Square",
          "Visited": true
        }
      },
      {
        "fields": {
          "Address": "1 Ferry Building",
          "Name": "Ferry Building"
        }
      }
    ]
  }

6. Response body = 

{
  "records": [
    {
      "createdTime": "2022-09-12T21:03:48.000Z",
      "fields": {
        "Address": "333 Post St",
        "Name": "Union Square",
        "Visited": true
      },
      "id": "rec560UJdUtocSouk"
    },
    {
      "createdTime": "2022-09-12T21:03:48.000Z",
      "fields": {
        "Address": "1 Ferry Building",
        "Name": "Ferry Building"
      },
      "id": "rec3lbPRG4aVqkeOQ"
    }
  ]
}

That should do the trick — lmk if any issues!

[GrailAutomation · Accepted solution]

Oh — also worth noting the Airtable API supports syncing up to 10K rows if you push a CSV.

[GrailAutomation · Accepted solution]

Hi @dunncrew! The Workato connector for Airtable natively supports creating 1 record at a time... but it also includes a Custom Action, which you could use to insert a batch of records (up to 10 at a time, according to Airtable's API documentation). Instructions:

1. Add action to your recipe (app = Airtable, action = Custom Action)
2. In the action setup, click Start Guided setup
3. Method = POST
4. Path = https://api.airtable.com/v0/{baseId}/{tableIdOrName} 
5. Request body =

{
    "records": [
      {
        "fields": {
          "Address": "333 Post St",
          "Name": "Union Square",
          "Visited": true
        }
      },
      {
        "fields": {
          "Address": "1 Ferry Building",
          "Name": "Ferry Building"
        }
      }
    ]
  }

6. Response body = 

{
  "records": [
    {
      "createdTime": "2022-09-12T21:03:48.000Z",
      "fields": {
        "Address": "333 Post St",
        "Name": "Union Square",
        "Visited": true
      },
      "id": "rec560UJdUtocSouk"
    },
    {
      "createdTime": "2022-09-12T21:03:48.000Z",
      "fields": {
        "Address": "1 Ferry Building",
        "Name": "Ferry Building"
      },
      "id": "rec3lbPRG4aVqkeOQ"
    }
  ]
}

That should do the trick — lmk if any issues!

[GrailAutomation · Accepted solution]

Oh — also worth noting the Airtable API supports syncing up to 10K rows if you push a CSV.

[dunncrew · Accepted solution]

AirTable has a restriction on how many INSERTS can occur in a time-frame. So I decided to insert 1 at a time in a loop, and include a WAIT delay to insert slowly.