You can't use this until you register with us!




Description

Extract attachments from an email account and store them in Azure Blob Storage.


Purchasing Options



Available Actions

Process IMAP

Extract attachments from an email account accessed via IMAP protocol, store them in a Microsoft Azure Blob Storage Container and record the locations in a MySQL database.


Variables

Source Parameters
imap_server required

Select the IMAP Server where the messages to process are stored.

start_point

Optional. Datetime stamp formatted as YYYY-MM-DD HH:MM:SS in UTC timezone. Only messages with a received datetime stamp that is after the datetime specified will be processed. This field is automatically set to the received datetime stamp of the last message that is successfully processed.


Destination Parameters
azure_connection required

Select the credentials to use to access the Blob Storage Container.

container_name required

Specify the name of the container where the attachments will be stored.

target_folder

Specify the virtual folder where the attachments will be stored.

allow_overwrite required

Enable to allow an existing file with the same name to be overwritten.


SQL Server Parameters
sql_server_connection required

Select the SQL Server Database where the locations of the attachments will be stored.

email_table required

Name of the table, in schema.table format, where the MIME headers, body data and unique id for each message will be stored. If it does not exist, it will be created.

attachment_table required

Name of the table, in schema.table format, where the name, unique id and storage path for each attachment will be stored. If it does not exist, it will be created.

ignore_duplicates

Ignore duplicates when storing email or attachments rows.


Process POP3

Extract attachments from an email account accessed via POP3 protocol, store them in a Microsoft Azure Blob Storage Container and record the locations in a MySQL database.


Variables

Source Parameters
pop3_server required

Select the POP3 Server where the messages to process are stored.

start_point

Optional. Datetime stamp formatted as YYYY-MM-DD HH:MM:SS in UTC timezone. Only messages with a received datetime stamp that is after the datetime specified will be processed. This field is automatically set to the received datetime stamp of the last message that is successfully processed.


Destination Parameters
azure_connection required

Select the credentials to use to access the Blob Storage Container.

container_name required

Specify the name of the container where the attachments will be stored.

target_folder

Specify the virtual folder where the attachments will be stored.

allow_overwrite required

Enable to allow an existing file with the same name to be overwritten.


SQL Server Parameters
sql_server_connection required

Select the SQL Server Database where the locations of the attachments will be stored.

email_table required

Name of the table, in schema.table format, where the MIME headers, body data and unique id for each message will be stored. If it does not exist, it will be created.

attachment_table required

Name of the table, in schema.table format, where the name, unique id and storage path for each attachment will be stored. If it does not exist, it will be created.

ignore_duplicates

Ignore duplicates when storing email or attachments rows.