topic Re: How to read list of contents and write onto email body? Is there a way to do this. in Workato Pros Discussion Board

How to read list of contents and write onto email body? Is there a way to do this.

anoop9275 — Wed, 06 Sep 2023 15:03:12 GMT

Trying to draft email alert which would have contents of list created. Need to understand if I do group mapping, it shows only 1 record wherein list have 100 record count. Greatly appreciate quick response on this.

Re: How to read list of contents and write onto email body? Is there a way to do this.

gary1 — Wed, 06 Sep 2023 15:11:30 GMT

I'd need to see some screenshots of your recipe to understand what's happening. In what action are you trying the group mapping?

Re: How to read list of contents and write onto email body? Is there a way to do this.

anoop9275 — Wed, 06 Sep 2023 15:15:02 GMT

Need above list with 2 records to be written onto email body.

Re: How to read list of contents and write onto email body? Is there a way to do this.

gary1 — Wed, 06 Sep 2023 15:19:20 GMT

In the email body, try [items].to_json. It's not pretty, but it will convert the array from Ruby to JSON and you'll be able to see the contents in the email.

If you want to format them, you can create a message template that uses HTML.

Re: How to read list of contents and write onto email body? Is there a way to do this.

anoop9275 — Wed, 06 Sep 2023 15:20:36 GMT

I tied adding list onto email body but shows only 1 record. Need a way how to display all records of list.

Re: How to read list of contents and write onto email body? Is there a way to do this.

gary1 — Wed, 06 Sep 2023 15:40:17 GMT

I'm assuming the "Items" array contains objects that contain the Title, Address, and Manager data pills you're putting into the email body. When you use data pills from an array like this, it only grabs the first item in the array, which is why you're seeing only one result.

There are many options to display all of the items in the array, and here are a couple of my suggestions:

Switch to formula mode, add in only the Items data pill and use [items].to_json. This will convert the entire items list to JSON and you'll get everything in them email body, but it won't look pretty.
Switch to formula mode and use [Items].pluck('title').smart_join(', ') to make a comma-delimited list of all Titles in the array. You can repeat the same for each Address and Manager. I don't think this is a very good option, because I'm assuming you want to keep the data from each object grouped together.
Create a message template that parses the Items array and generates either a text or HTML output for the email body. This takes more effort and maybe some learning, but it will produce the best looking result.

I think the most important thing you need to decide is how you want your email to look. If it needs to look good, the message template is your best option.

Re: How to read list of contents and write onto email body? Is there a way to do this.

anoop9275 — Wed, 06 Sep 2023 16:28:57 GMT

Tried, shows only 1 record instead should show 2 records.

Re: How to read list of contents and write onto email body? Is there a way to do this.

gary1 — Wed, 06 Sep 2023 16:30:39 GMT

Send a screenshot of how you tried, maybe we can fix it.

Re: How to read list of contents and write onto email body? Is there a way to do this.

marlon-muela — Fri, 15 Sep 2023 04:39:44 GMT

Hi @anoop9275 ,

This is Marlon from the Support team.
You can try to drag and drop the list items on the message body. See sample below.