ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

Emails

Query emails to learn how prospects responded to the emails.

Table Specific Information

Select

The provider will use 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 provider.

  • 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] Integer ID of the email.
ProspectId Integer Pardot prospect id related to this email.
CampaignId Integer Pardot campaign related to this object.
CreatedById Integer 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 Integer ID of the list associated with this email.
listEmailId Integer 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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137