AutomationEmailQueues

A summary of the queue for an email in an automation workflow.

Table Specific Information

Select

The driver will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

Id supports the '=' operator.
WorkflowId supports the '=' operator.
EmailId supports the '=' operator.

For example:

SELECT * FROM AutomationEmailQueues WHERE Id = '1245'

SELECT * FROM AutomationEmailQueues WHERE WorkflowId = '1245' and EmailId = '1245'

Columns


Name	Type	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	A string that uniquely identifies a list.
EmailAddress	String	Email Address
NextSend	String	Next Send

ODBC Driver for Mailchimp

AutomationEmailQueues

Table Specific Information

Select

Columns