Emails
Retrieve emails.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- Id supports '='.
For example, the following query is processed server side:
SELECT * FROM Emails WHERE Id = 10
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | Pardot ID for this email. | |
| Name | String | Name of this email. | |
| Subject | String | Email Subject. | |
| Message | String | Contains the text of email. | |
| HTMLContent | String | Contains text and html elements of different formats. | |
| CreatedAt | Datetime | Time the Email Was Created. |