Forum Discussion

wpenfold's avatar
wpenfold
Contributor
5 years ago

Email snap with both pipeline variables and HTML table?

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...
email
dmiller's avatar
dmiller
Former Employee
5 years ago

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

rfduboissl's avatar
rfduboissl
New Contributor II
5 years ago

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

      "