Need Help Creating JSON Array for Attendees

:bullseye: What is your goal?

I have airtable field with emails comma seperated now when that field comes in Make i want to create an string like this:
{“email”:“email1”},{“email”:“email2”} and so on.

For Example (AT Field):
test@email.cm, john@gmail.cm, doe@gmail.cm

In make I want:
{“email”:“test@gmail.cm”},{“email”:“john@gmail.cm”},{“email”:"doe@gmail.cm}

Which i will pass in Google Calender Attendees as Map like this:
[ created string ]

so it will be treated as attendees array

Hey there,

you can do that with an iterator module followed by an aggregate to JSON module. Put your comma separated list inside a split() function in the iterator module and define the structure you want in the aggregate to JSON module.

Hi @Stoyan_Vatov , thanks for the reply. I got the desired output which is: [{“email”:“test@gmail.cm”},{“email”:“john@gmail.cm”},{“email”:“doe@gmail.cm”}]

But when I pass this to Attendees like this:

It gives error you have any idea how can i achieve this?

Note: For privacy I am using the fake emails in my scenario I have real emails.

Hi thanks all so I achieved this using Iterator module like @Stoyan_Vatov told, but after that have an array aggregator module with source as Iterator and Target as Attendees and fill the email with iterator value like below:

Then pass this array in attendees in create event module

3 Likes