Emails
Retrieve emails.
Table Specific Information
Select
The adapter will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the adapter.
- 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. |