topic Re: Insert "Batch of Rows" to Airtable in Workato Pros Discussion Board

Insert "Batch of Rows" to Airtable

dunncrew — Thu, 12 Oct 2023 17:57:35 GMT

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?

Re: Insert "Batch of Rows" to Airtable

GrailAutomation — Thu, 12 Oct 2023 19:42:28 GMT

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:

Add action to your recipe (app = Airtable, action = Custom Action)
In the action setup, click Start Guided setup
Method = POST
Path = https://api.airtable.com/v0/{baseId}/{tableIdOrName}
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!

Re: Insert "Batch of Rows" to Airtable

GrailAutomation — Thu, 12 Oct 2023 19:34:30 GMT

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

Re: Insert "Batch of Rows" to Airtable

dunncrew — Wed, 18 Oct 2023 14:07:43 GMT

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.