Etlworks can read emails and email attachments using the POP3 and IMAP protocols and send emails using the SMTP protocol. Emails and email attachments can be sent as part of a source-to-destination transformation or by using a dedicated Send Email Flow.
What can you do with emails in Etlworks
|
Send emails and attachments There are several techniques available in Etlworks for sending emails. |
Send email in HTML Format When configuring the |
ETL, browse, filter, and delete emails and attachments There are several techniques available in Etlworks for reading emails and attachments.
|
|
Read emails, save attachments This flow reads the email messages (including attachments) from the inbound email connection and saves them as files into the designated folder in the server storage. |
Work with Gmail Read and create messages and attachments. |
Work with Office 365 and Microsoft Exchange Read and create messages and attachments. |
|
Troubleshoot sending and reading emails If you experience problems when sending or reading emails using outbound or inbound email connection you can add a configuration parameter that enables extra logging. |
|
|
Related resources
|
Send notifications from the scheduler In Etlworks, it is possible to send an email notification when the Flow has been automatically executed by the Scheduler. |
Configure email sender Select
|
| Send email notifications for any event triggered by Webhook |
|
Videos
|
ETL with Email Watch how to create ETL flows for sending and reading emails and attachments |
Related case study
|
Multistep workflows for APIs, Salesforce, MySQL, email systems, and Google Cloud services.
|
RecBi, a leading provider of business intelligence solutions, uses Etlworks to power complex data integration workflows across APIs, Salesforce, MySQL databases, email systems, Google Cloud services, file-based sources, and more. With multi-step pipelines capable of processing data for multiple customers in a single run, Etlworks delivers the flexibility and stability RecBi needs to stay agile and responsive to client demands. |
Create Inbound and Outbound email Connections
-
Inbound EmailConnection: used to read emails and attachments. -
Outbound EmailConnection: used to send emails and attachments.
Troubleshoot sending and reading emails
If you experience problems when sending or reading emails using an outbound or inbound email connection, you can add a configuration parameter that enables extra logging.
Configuration
Add mail.debug=true to Properties field in Outbound or Inbound email connection.
Extra logging in flow log
When mail.debug=true is set the email connector adds extra logging to the flow log.
For example, if the message was successfully sent you should see "DEBUG SMTP: message successfully delivered to mail server" in the log.
Comments
0 comments
Please sign in to leave a comment.