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
S3 File as Email Attachment
Hello, As part of an error handling pipeline, I am attempting to write a detailed error file to an S3 bucket, and then attach that file to the email notification at the end of the error pipeline to alert users of the issue. I was able to do this successfully when writing the file to snaplogic’s native file system, but the email sender snap is failing consistently when attempting to grab the S3 file. The error message is: Cannot find AWS access key ID in URL Resolution: Please enter valid URI path. Reason: URI syntax error. For the attachments field, I have something like this: s3:///buistintegration/test_errors_12082017.json I tried adding the AWS Access Key and Secret in a few different combinations before the bucket name, with no luck. Has anyone attempted this before? Is it possible? Any input is appreciated. Thanks, Jack Skrable
How to trigger a pipeline based on incoming email
Anyone can come up with a creative way to initiate a pipeline based on an receiving an email? I would set some rules in the email account to auto route it to a sub-folder. We could have a schedule task to read the email folder but I would rather have a push instead of an interval pull mechanism.How to Configure an Email Sender Snap to Avoid Individual Emails per Record
If you configure an Email Sender Snap with an input view and connect it to receive data from upstream Snaps, one email will be sent for each document processed through the pipeline unless you are using HTML table as the Email type. The HTML table format will embed the data in the email body up to the Batch size limit, sending as many emails as necessary to batch through the documents. Alternatively, if you want to just send the details as an attachment to an email, do not add an input view. Instead, just place the Snap unconnected on the workspace, write the data to a file, and have the Email Sender Snap attach that file to the email.
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
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.
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.
