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. 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
How can we "prettify" a Json data section presented in an email with the HTML table template type chosen?
Hello community, is there anyway we can manipulate a part of a document for a json section to make it more reader friendly ie prettify it, especially in the html table format option in the Email sender snap. So it doesn’t look bunched in the email body, in a table column and much more reader friendly. This is a small example of the problem:- So its maybe looks like this in the email body when its rendered :- { “Results”:{ “Title”:" Results 2", “FileInfo”:{ “Files”:[ { “Name”:“OLD”, “Type”:“Directory” } ] } }, “Files”:[ { “Name”:“OLD”, “Type”:“Directory” } ] } Ok so the editor had screwed the tabbing structure up here, but you get the idea! Any help appreciated. Many thanks, Mike
Email Sender Snap Include two different table
This is some part of html code that I m using to include in Email body ' <tr> <th>Description</th> <th>Record Count</th> </tr> <tr> <td>Total Record Count In File</td> <td>'+ _Rowcount + '</td> </tr> </table> <br/><br/> Total Successful Record Count In File :' + _ValidRecords+'<br> Total Error Record Count In File :'+ _InvalidRecords+' <br>Error Records Description<br><br> <table class="hovertable"> </table>' Here first table is just a table with 1 row with static values and for the second table tag rows will be populated from input document. This is working ok,but the issue i am facing is both the table are sticking together even if i have defined them separately in html code. Also the text expected above the second table is also pushed down. refer screenshot below: …I ran the same html code in my local browser and was getting expected results(Two separate tables) Is there any fix for this,so that i get two separate tables
How to Format an Email Body
Hi, I’m using an HTML table as an email type, to send an email to my team. But there is a field called status. if the status is ‘Failed’ i need to highlight the cell in red. If the status is completed, I need to highlight it in green. Can we achieve this using email snap? Can someone help me with this? Thanks in advance.
Failed to send email message : Email Sender
Hi, I am getting below error while sending email via email sender. How to rectify it? Failed to send email message Resolution: Please check for valid properties. Reason: Failed to send email message: 554 5.2.252 STOREDRV.Submission.Exception:SendAsDeniedException.MapiExceptionSendAsDenied; Failed to process message due to a permanent exception with message Cannot submit message.
Upload Gmail attachments to Box
Created by @skatpally When new email is received in Gmail, if the email has attachments, SnapLogic uploads these attachments to the Box root folder. Configuration Sources: Email with attachments Targets: Box root folder Snaps used: Email Reader, Mapper, File Reader, Box Write Downloads Upload_Gmail_attachments_to_Box.slp (6.6 KB)
