AutomationEmailQueues
A summary of the queue for an email in an automation workflow.
Table Specific Information
SELECT and INSERT are supported for AutomationEmailQueues.
Select
A WorkflowId is required to retrieve data from this table. If none is specified in the WHERE clause, the first one available for your account will be used.
Insert
The WorkflowId, EmailId, and EmailAddress are required for INSERTs.
INSERT INTO AutomationEmailQueues (WorkflowId, EmailId, EmailAddress) VALUES ('myWorkflowId', 'myEmailId', 'myEmailAddress')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The MD5 hash of the lowercase version of the list member's email address. |
| WorkflowId [KEY] | String | True |
A string that uniquely identifies an automation workflow. |
| EmailId [KEY] | String | True |
A string that uniquely identifies an email in an automation workflow. |
| ListId [KEY] | String | True |
A string that uniquely identifies a list. |
| EmailAddress | String | False |
Email Address |
| NextSend | String | True |
Next Send |