AutomationEmailQueues
Returns a summary of the queue for an email in an automation workflow.
View-Specific Information
Select
The provider 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 provider.
| Column | Supported Operators |
| Id | = |
| WorkflowId | = |
| EmailId | = |
SELECT * FROM AutomationEmailQueues WHERE Id = '1245'
SELECT * FROM AutomationEmailQueues WHERE WorkflowId = '1245' AND EmailId = '1245'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The MD5 hash of the lowercase version of the list member's email address. | |
| WorkflowId [KEY] | String | A string that uniquely identifies an automation workflow. | |
| EmailId [KEY] | String | A string that uniquely identifies an email in an automation workflow. | |
| ListId | String |
Lists.Id | The Id of the list associated with this automation email queue. |
| EmailAddress | String | The email address of the subscriber queued for the automation email. | |
| NextSend | String | The date and time the queued automation email is next scheduled to be sent. |