You have an Airtable Record that has linked records of items that can be multiple and you want to generate the JSON as specified in the screenshot above, right?
By this, I mean the Order Record in Airtable has order_number, total, and items as a linked record in Airtable.
What you can do is,
a) After the current Get/Search Records that you have, add an iterator, that loops over the linked records, after which you can use Get a Record to get the details of linked items from Airtable.
b) After which, put an array aggregator
c) Use Create a JSON Module and generate the JSON Structure based on what is needed in Customer.io, You can use the following when generating the structure
@Runcorn I have now a similar workflow where I drag speakers to a speaking slot, so there can be multiple linked records (speakers) as well. Now, I want to create an image with the speakers using placid.app. For instance, if there are 3 speakers, then I need a template for 3 speakers, if there are 4, then for 4, and so on. The fields are predefined, so I need to insert the values of Speaker 1 in Field 1, Speaker 2 in Field 2, and so on. Do you have a solution on how I can do this? Whenever I insert it, only the first speaker is displayed.