AutomationEmailQueues
Returns a summary of the queue for an email in an automation workflow.
Table-Specific Information
Select
The driver uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.
| Column | Supported Operators |
| Id | = |
| WorkflowId | = |
| EmailId | = |
SELECT * FROM AutomationEmailQueues WHERE Id = '1245'
SELECT * FROM AutomationEmailQueues WHERE WorkflowId = '1245' AND EmailId = '1245'
Insert
The WorkflowId, EmailId, and EmailAddress columns are required for INSERT operations.
INSERT INTO AutomationEmailQueues (WorkflowId, EmailId, EmailAddress) VALUES ('b0a1c4d2e3', 'f5g6h7i8j9', '[email protected]')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The MD5 hash of the lowercase version of the list member's email address. | |
| WorkflowId [KEY] | String | False |
A string that uniquely identifies an automation workflow. | |
| EmailId [KEY] | String | False |
A string that uniquely identifies an email in an automation workflow. | |
| ListId | String | True |
Lists.Id |
The Id of the list associated with this automation email queue. |
| EmailAddress | String | False |
The email address of the subscriber queued for the automation email. | |
| NextSend | String | True |
The date and time the queued automation email is next scheduled to be sent. |