Working with emails

Integrator can read emails and email attachments using the POP3 and IMAP protocols, and can send emails using the SMTP protocol. Emails and email attachments can be used as part of a source-to-destination transformation, similar to the use of databases, files, web services, and social web sites.

Connecting to email servers

Start creating an Email connection by opening the Connections window, clicking the + button and typing mail into the filter field in the "Select Connection Type" gallery:

Connection parameters

Inbound email connection

To read data from a mail server, you need to specify the following parameters for the Inbound Email connection:

Important: if you are using one of the public email providers, for example Gmail, make sure to enable POP3 and IMAP for your account, and make sure that your account can be accessed from "less secure applications" (Google's official name for third-party applications, as opposed to registered email clients).

Outbound email connection

To send emails you need to specify the following parameters for an Outbound Email connection:

Working with outbound emails

Sending emails

In Integrator, it is possible to send an email notification when the flow has been automatically executed by the scheduler.

There is also a designated flow type - Send Email. You can use it as part of a nested flow when multiple flows are combined in the pipeline, and it is possible to have it executed conditionally or in a loop.

Step 1 Create an outbound email connection.

Step 2 Continue by opening the Flow Builder window, clicking the + button and typing email into the Select Flow Type box. Select the Send Email flow type.

email flow

Step 3 Select the outbound email connection created in Step 1.

Step 4 Select the Parameters tab and enter the email parameters. Most of them are optional overrides corresponding to outbound email connection parameters:

Using outbound email as a destination in a source-to-destination transformation

Emails and email attachments can be used as destinations in a source-to-destination transformation, similar to the use of databases, files, web services, and social web sites.

Step 1 Create an outbound email connection, which will be used as the destination.

Step 2 Create any database, file, web services, or social web site connection, which will be used as the source.

Step 3 Start creating a flow in the Flow Builder window by clicking the + button and selecting any flow type where the source is a database, file, web service or social web site and the destination is a file.

Step 4 Modify the flow by selecting the connection created in Step 2 as the source (FROM), and the connection created in Step 1 as the destination (TO).

Step 5 Add mapping and modify parameters, if needed.

Working with inbound emails

Browsing inbound emails

In Integrator, you can browse inbound emails for the configured inbound email connection in Explorer.

browse emails

Using inbound email as a source in the source-to-destination transformation

Emails and email attachments can be used as sources in a source-to-destination transformation, similar to the use of databases, files, web services, and social web sites.

Step 1 Create an inbound email connection, which will be used as the source.

Step 2 Create any database, file, web services, or social web site connection, which will be used as the destination.

Step 3 Start creating a flow in the Flow Builder window by clicking the + button and selecting any flow type where the source is a file and the destination is a database, file, web service or social web site.

Step 4 Modify the flow by selecting the connection created in Step 1 as the source (FROM), and the connection created in Step 2 as the destination (TO). Use appropriate formats for the source and destination.

Step 5 Use the field From to define an email subject. Important: use wildcards, if needed. If there are multiple matching emails, Integrator will select the first one, based on the timestamp marking when the email was received.

email subject

Step 6 Add mapping and modify parameters, if needed.

Important:

Copying the contents of an email or attachment into a file

Step 1 Create an inbound email connection, which will be used as the source.

Step 2 Create a connection to be used as the destination. Supported types of destination connections are:

Cloud storage

File storage

Redis

HTTP

Step 3 Start creating a flow in the Flow Builder window by clicking the + button and selecting the Copy Files flow type.

Step 4 Modify the flow by selecting the connection created in Step 1 as the source (FROM), and the connection created in Step 2 as the destination (TO).

Step 5 Use the field From to define the email's subject. Important: use wildcards if needed. If there are multiple matching emails, Integrator will select the first one, based on the timestamp marking when the email was received.

Dumping email attachments into a folder

The simplest way to dump all or matching email attachments into a folder is to use this technique, together with specifying the property Dump Attachments To for the inbound email connection. The attachments will be copied to the specified folder in server storage, using the original file names.

Filtering inbound emails

Use the Filter section when configuring an inbound email connection to filter inbound emails.

filter emails

Available filters

Deleting inbound emails after processing them

You can configure a connection to automatically delete inbound emails from the INBOX after processing them.

Simply enable the property Delete inbound emails after reading. This property is disabled by default.

delete emails