Emails
Query emails to learn how prospects responded to the emails.
Table Specific Information
Select
The adapter uses the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- Id supports '=', '<', '<=', '>', '>='.
- ProspectId supports '=', '<', '<=', '>', '>='.
- ListEmailId supports '=', '<', '<=', '>', '>='.
- SentAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM Emails WHERE Id = 50 SELECT * FROM Emails WHERE ProspectId = 23 SELECT * FROM Emails WHERE SentAt > '01/01/2022'
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | ID of the email. | |
| ProspectId | Int64 | Pardot prospect id related to this email. | |
| CampaignId | Int64 | Pardot campaign related to this object. | |
| CreatedById | Int64 | ID of the individual who created this object. | |
| 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. | |
| 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. | |
| ListId | Int64 | ID of the list associated with this email. | |
| listEmailId | Int64 | ID of the list email associated with this email. | |
| Name | String | Name of the email for identification in Pardot. | |
| SentAt | Datetime | Time the email was sent. | |
| Subject | String | The email subject. |