SnapLogic - Integration Nation

pranil2k2 · ‎11-25-2019

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

pranil2k2 · ‎11-26-2019

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

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

psadasivam · ‎11-25-2019

@pranil2k2 - You can access your document inside template body by enabling “=” (toggle) expression mode. eg: ‘<body>’+$firstname+‘</body>’. you have multiple ways. Can you share sample output from mapper snap and your template to help further.

pranil2k2 · ‎11-26-2019

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

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

pranil2k2 · ‎11-26-2019

"

SMRT Load Stats

Table Name

+$$Table_name+

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

" i think it got broken

psadasivam · ‎11-26-2019

@pranil2k2, Just make sure you are passing array of JSON object to email Snap as shown below and Table-data path is set to $
SnapLogic%20Designer%20-%20PS%20new%20pipeline%200%20-%20%3AILMN-DEV%3APOC%3Ashared%202019-11-26%2011-22-57 Test%20Email%20-%20Inbox%202019-11-26%2011-20-20

SnapLogic - Integration Nation

How to Pass Mapping Variables to Email Snap