Forum Discussion
@cstewart, I’ve attempted to use your solution, but I need further info. Do you have a snapshot or examples of the mapper snap going into this email snap as well as the email snap, showing the configuration. I have the email type set as “HTML table” using your solution and my email snap continues to give me => Failure: Template body: $complete_PDW is undefined.
Below is the html in my template body:
"<DOCTYPE html>
<html>
<head></head>
<p>Good morning Team,Today’s DQC values for your review.</p>
<body>
<p>1. Attunity Load Items Status/Issues</p>
<ul></ul>
<li>a). Status – Complete.</li>
<li>b). Issues – No issues</li>
<p>2. PDW Load Items Status/Issues</p>
<table border=1>
<tr></tr>
<tr><td>PDW – Completed at: </td><td>" + $complete_PDW + " </td></tr>
<tr><td>CALL Center – Completed at: </td><td>" + $complete_CC + " </td></tr>
<tr><td>SpecRx – Completed at: </td><td>" + $complete_SPECRX + " </td></tr>
<tr><td>MHK – Completed at: </td><td>" + $complete_MHK + " </td></tr>
<tr><td>Reporting Cluster – Completed at: </td><td>" + $complete_RPT_Cluster + " </td></tr>
</table>
<li>f) Issues : None</li>
</body>
</html>"
- dmiller5 years agoFormer Employee
@rfduboissl because you have Table-driven path set to $table, it’s trying to find $complet_PDW within that, but base on your JSON image it is not within a $table but at the same level.
I think you want to set your email type to HTML Text since you are explicitly listing the fields in the HTML. If you use HTML table as the Email type, it will append the table in the HTML.
- rfduboissl5 years agoNew Contributor II
Diane …
Thanks you for the reply.
I DID figure this out and have it working.
I will post the solution.
Rich
- rfduboissl5 years agoNew Contributor II
1). Data going into the email snap … the $variables must be at the same level as the table, ( I had each of them coming in as separate documents).
2). email type is HTML table, Table data path is $table
3). Final Template body html is:
"
Good morning Team,Today’s DQC values for your review.
1. Attunity Load Items Status/Issues
- a) Status – Complete.
- b) Issues – No issues
2. PDW Load Items Status/Issues
- a) PDW – Completed at " + $complete_PDW + "
- b) CALL Center – Completed at " + $complete_CC + "
- c) SpecRx – Completed at " + $complete_SPECRX + "
- d) MHK – Completed at " + $complete_MHK + "
- e) Reporting Cluster – Completed at " + $complete_RPT_Cluster + "
- f) Issues : None
3. Please find the DQC errors in the below table