โ10-12-2023 10:56 AM - edited โ10-12-2023 10:57 AM
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?
Solved! Go to Solution.
โ10-12-2023 12:30 PM - edited โ10-12-2023 12:42 PM
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:
{
"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!
โ10-12-2023 12:34 PM
โ10-18-2023 07:07 AM
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.
โ10-12-2023 12:30 PM - edited โ10-12-2023 12:42 PM
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:
{
"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!
โ10-12-2023 12:34 PM
โ10-18-2023 07:07 AM
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.