Bots From Extension: email_sender
SMTP Email Sender - Send Emails through SMTP Server
This extension provides 3 bots.
Bot @email:sendmail-bulk
Bot Position In Pipeline: Sink
Send one email per row with 'recipient', 'subject', 'message' columns
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| recipient_col | Text | recipient | Column name which has email recipient |
| subject_col | Text | subject | Column name which has email subject |
| message_col | Text | message | Column name which has email subject |
| message_mime_type_col | Text | message_mime_type | Message body MIME type column. if not specified or column not found, defaults to 'text/plain' MIME type. |
| email_status_col | Text | If specified, a new column will be added in the output to capture status of each row. |
Example Pipelines Using this Bot
Bot @email:sendmail-data
Bot Position In Pipeline: Sink
Upload dataframe to email recipient
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| recipient* | Text | Recipient email address | |
| subject | Text | RDA Report | Subject for the outgoing email |
| format | Text | csv | Attachment format. values can be of 'csv', 'xlsx', 'json' |
| attachment_name | Text | data | Name of the attachment file. Supports datetime variables (ex: alert_report_%d%m%Y) |
| message | Text | RDA Report Attached. | Message body for the outgoing email |
| message_mime_type | Text | plain | Message body MIME type. Examples 'plain' or 'html' |
Bot @email:sendmail-message
Bot Position In Pipeline: Sink
Send an email to the recipient
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| recipient* | Text | Recipient email address | |
| subject | Text | Email from RDA | Subject for the outgoing email |
| message* | Text | Message body for the outgoing email | |
| message_mime_type | Text | plain | Message body MIME type. Examples 'plain' or 'html' |