cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to Pass Mapping Variables to Email Snap

pranil2k2
Contributor

Hi,
I am new to SnapLogic. i need help on how to pass the Mapping variable to Email snap. I need a requirement to read the mapping variable and need to refer in Email Snap Template body. so that users can read the values on email itself.

Thanks

image

1 ACCEPTED SOLUTION

pranil2k2
Contributor

In Mapper i have two columns, and i need to configure in mail to show the table name and its stats.
image

image

I am trying using below template as suggested in document but it is throwing error. is there any standard format to refer other than below?

SMRT Load Stats

Table Name

+$$Table_name+

    <p>Table Stats</p> 
    <p>+$Table_Record_Count+</p> 

Thanks Again

View solution in original post

7 REPLIES 7

Hi, how would this work if I wanted to output multiple tables in one email body? Thanks.

pranil2k2
Contributor

Hi Sadasivam,

Thanks for the reply. I am trying to use HTML Text option. but i am getting below error.
for now i want to pass single table stats,as mapped in mapper.

i want to display $Table_Record_Count, $Table_name values in Mail. please can you give some example on this scenario and if possible please share me the pipeline for reference.

image

image

Thanks Again.

pranil2k2
Contributor

Hi,

I tried to implement your method using Table but it is throwing error.

Below is the syntax used in Mapper
[{โ€˜Table Nameโ€™: $TABLE_NAME,โ€˜Countโ€™:$COUNT}]

image
image