How to bulk upsert Airtable records

How To
1

I have an HTTP request that returns an array of campaign sequences with under each campaign sequence a nested array of sequence variants (See picture for data structure).

I want to add this data to Airtable but I’ve only managed to do it when I create a record one by one.

Preferably I want to use the “bulk upsert” Airtable module to save Make operations. However, I’m running into issues configuring the bulk upsert module. I think I’d need to use the get( and map( forumlas to extract the datapoints from the arrays up to 10 records at a time? So far I haven’t been able to do that properly and I’m getting weird outcomes with the nested arrays. Please advice.

image
image510×656 14.3 KB

image
image552×415 14.1 KB

2

If you need a custom/complex data structure, you’ll need to use the Aggregate to JSON or Create JSON module so that you can specify the data structure. Then, Parse JSON to convert back into a mappable array.

If you require further assistance, my profile has a couple of links to resources that may help, or you can search my previous posts on my profile for answers to similar questions like these.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew