cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Insert "Batch of Rows" to Airtable

dunncrew
Deputy Chef III
Deputy Chef III

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? 

3 ACCEPTED SOLUTIONS

GrailAutomation
Deputy Chef III
Deputy Chef III

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!

View solution in original post

GrailAutomation
Deputy Chef III
Deputy Chef III

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

View solution in original post

dunncrew
Deputy Chef III
Deputy Chef III

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.

View solution in original post

3 REPLIES 3

GrailAutomation
Deputy Chef III
Deputy Chef III

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
Deputy Chef III
Deputy Chef III

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

dunncrew
Deputy Chef III
Deputy Chef III

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.