JDBC Driver for Salesforce Pardot

Build 22.0.8462

Emails

Query emails to learn how prospects responded to the emails.

Table Specific Information

Select

The driver 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 driver.

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462