ListEmail
A list email is a single email sent to a recipient list.
Table Specific Information
Select
The connector uses the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports '=', '<', '<=', '>', '>='.
- IsDeleted supports '='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
- SentAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM ListEmail WHERE Id = 50 SELECT * FROM ListEmail WHERE SentAt > '01/01/2022' SELECT * FROM ListEmail WHERE CreatedAt > '01/01/2022'
GetDeleted
To retrieve list email that are in the recycle bin in Pardot the following operation is supported:
GETDELETED FROM ListEmail
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | ID of the email. | |
| Name | String | Name of the object for identification in Pardot. | |
| Subject | String | The email subject. | |
| TextMessage | String | The text content of the email. This field is retrieved only when filtering with email id. | |
| HtmlMessage | String | The HTML content of the email. This field is retrieved only when filtering with email id. | |
| CampaignId | Int64 | Pardot campaign related to this object. | |
| IsPaused | Boolean | True if the email send is paused. | |
| IsSent | Boolean | True if the email has been sent. | |
| IsDeleted | Boolean | True if the object is in the recycle bin in Pardot. | |
| CreatedById | Int64 | ID of the individual who created this object. | |
| UpdatedById | Int64 | ID of the individual who last updated this object. | |
| CreatedAt | Datetime | The timestamp of when this object was created. | |
| UpdatedAt | Datetime | The timestamp of when this object was last updated. | |
| ClientType | String | Value is 'Builder' if the email was sent via the Lightning Email Builder. Value is 'Web' if it was sent via the legacy Pardot email builder. | |
| SentAt | Datetime | Time the email was sent. | |
| OperationalEmail | Boolean | True if the email is operational. | |
| EmailTemplateId | Int64 | ID of the email template used for the list email. | |
| TrackerDomainId | Int64 | ID of the tracker domain used for the list email. | |
| SenderOptionsType | String | The sending user type(s). | |
| SenderOptionsAddress | String | The sending email address(s). | |
| SenderOptionsName | String | The name(s) of the sender. | |
| SenderOptionsUserId | String | The user ID(s) of the sender. | |
| ReplyToOptionsType | String | The reply to user type(s). | |
| ReplyToOptionsAddress | String | The sending email address(s). | |
| ReplyToOptionsUserId | String | The user ID(s) of the sender. |