This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Email snap with both pipeline variables and HTML table?

wpenfold
New Contributor III

โ€Ž12-17-2020 07:15 AM

I need to produce an HTML email that includes both pipeline variable information in the HTML header and an HTML table that is a multiline error report. I can make one or the other work, but not both. The error report is being read from a database table. I want the email to look like:

Pipeline aaaa was run with parameters x, y, z

Error Report:

GUROUTP_LINE

POPULATION SELECTION EXTRACT
CONTROL REPORT PAGE 1

ERROR Parm 3 must be entered if 1 and 2 are
SQLCODE = 0000
SQL ERROR =
X01 ROLLBACK SQLCODE=0000
X01 COMMIT (1) SQLCODE=0000
SQLCODE = 0000
ORA-01403: no data found
DQY-ABORT ROLLBACK SQLCODE = 0000
ORA-01403: no data found

0 Kudos
11 REPLIES 11

cstewart
Former Employee
In response to cstewart

โ€Ž12-22-2020 06:46 PM

This is my template body:

"<!DOCTYPE html> 
<html> 
<head> 
     <title>My Title</title> 
<style type=\"text/css\"> table.Snap {background-color:transparent;border-collapse:collapse;width:50%;} table.Snap th, 
      table.Snap td {text-align:center;border:1px solid black;padding:5px;} table.Snap th {background-color:AntiqueWhite;} 
</style> 
</head> 
<body> 
        <table class=\"Snap\" ALIGN='CENTER'> 
        </table> 
<h2>My Extra Details</h2>
<table>
<tr></tr>
<tr><td>FIrst Line in my Custom Table</td><td>" + $One + "/ " + $Two + "/ " + $Total + "</td></tr>
<tr><td>Second Line</td><td>"  + $Three + "/ " + $Four + "</td></tr>
<tr><td>Third Line</td><td>"  + $Five + "/ " + $Six + "/ " + $TotalThree + "</td></tr>
</table>
<br><H2>A load of other stuff</H2><br>" + $SummaryChanges + "
</body> 
</html>"
0 Kudos

rfduboissl
New Contributor II

โ€Ž08-25-2021 08:41 AM

@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.
image
image

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>"
0 Kudos

dmiller
Admin Admin
Admin
In response to rfduboissl

โ€Ž08-25-2021 01:55 PM

@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.


Diane Miller
Community Manager
0 Kudos

rfduboissl
New Contributor II
In response to dmiller

โ€Ž08-25-2021 02:08 PM

Diane โ€ฆ

Thanks you for the reply.

I DID figure this out and have it working.

I will post the solution.

Rich

image001.jpg

rfduboissl
New Contributor II
In response to dmiller

โ€Ž08-25-2021 02:17 PM

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).

image001.png

2). email type is HTML table, Table data path is $table

image005.png

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

      "

      image001.jpg

      0 Kudos