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.
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.Limiting repetitive error email notifications
Hello, In our current Error handling implementation, we’re using Email sender snap in a couple of child pipelines to send out error email notifications with a retry_count as 3 in one of the child pipeline. But now we get multiple emails with the same error details and error stack, which is quite redudant and we would like to limit it to just one unique email with all the details we used to get previously instead of multiple emails with same details. Is there a way in Snaplogic we can mitigate the overflow of emails and handle such scenario? Thanks in advance. Regards, Rahul
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