Include CSV list in email

Hi,

I've created recipe that sends an email when a batch update happens on a Postgres table

What I'd like to do is list the updated rows in a CVS format in the email with each record on a separate row like

2520, I am, Cat, cat@company.com, false

2518, I am, Dog, dog@company.com, false

What I've done so far for the email body is using formula mode I have the formula

ROWS.pluck('id','first_name','last_name','email','has_free_campaign').to_csv

and in the email I get...

"[2520, ""I am"", ""Cat"", ""cat@company.com"", false]","[2518, ""I am"", ""Dog"", ""dog@company.com"", false]"

How do I get rid of all off the double double quotes and have each record on a separate row?

cheers,

Chris

Hi Patricia,

Thanks very much for getting back to me!

As a matter of fact I had just tried Format Map and yes it works better but what I didn't know about was the `.join("\n")` and that was the final missing piece.

One other question, when sending an email via Workato it seems like you can either send text or a formula but not both and what I was hoping to do was embed my batch listing within some free text so is it possible to have a mixture? thx

best,

Chris

Hi Patricia,

That's perfect, thx!