Forum Discussion

asingh760's avatar
asingh760
New Contributor II
4 years ago
Solved

Loop through CSV file before sending Email

Hi All, I have a requirement where I receive a CSV file containing Owner Email, Id and other details as column. I want to send an email to the people in the “Owner Email” column of the CSV. But i...
email
  • SpiroTaleski's avatar
    SpiroTaleski
    4 years ago

    @asingh760

    I am attaching two sample pipelines:

    1)Parent - which groups the data based on the email and send the data to Child pipeline.
    2)Child - which split the groups, apply xslt transformation(generate HTML table), and send the table through email.
    Parent_2021_08_27.slp (4.9 KB)
    Child_2021_08_27.slp (10.2 KB)
    Also, I am attaching the sample XSLT file, which you can modify based on your requirements:
    XSLT_Transformation (1).txt (1.1 KB)
    Note: You must create a SMTP account in order to be able to send emails, using Emails Sender Snap.

    Regards,
    Spirp Taleski

SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
4 years ago
Copy Link

@asingh760

You can group the records from CSV file based on the “Owner Email” field, using Group By Fields Snap. So that, for each email address you will have all the related data in separate group.

After that, in a Mapper Snap you can use Array Functions in order to loop through each of the group and get appropriate data for each email. After you get the needed data, in Email Sender Snap, in “Template Body” field, you can pass the data entry for each email address.

Regards,
Spiro Taleski

asingh760's avatar
asingh760
New Contributor II
4 years ago
Copy Link

Thank you for the response on this.
I am able to group by data and used mapper to read one by one. The output of the mapper looks like this

I don’t know how to use this in email send snap

I used this but it is not sending data to each user with the details