Post array of objects to Airtable

Hi, I’m trying to post an array of objects (created using using MAP/JOIN functions) to Airtable, but it appears that because the array is encapsulated with double quotes, the post fails. When I remove the quotes from the formula bar manually, the post is successful. Any ideas on how I can get this working?

Variable created by JOIN function, with offending double quotes:

Failed post response:

Removed double quotes manually:

Results in successful post:

I tried adding and removing Content-Type: application/json to the header, but that didn’t help.


How and why are you using JOIN in your array of objects? I’m not sure if that’s the correct formula since it creates just text type data and therefore creates a text out of your array, making the POST request to fail. Maybe there’s another way to create your array of objects without JOIN, keeping the data type intact.