JDBC Driver for Salesforce Pardot

Build 22.0.8462

ListEmail

A list email is a single email sent to a recipient list.

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 '=', '<', '<=', '>', '>='.
  • IsDeleted supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.
  • SentAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM ListEmail WHERE Id = 50
SELECT * FROM ListEmail WHERE SentAt > '01/01/2022'
SELECT * FROM ListEmail WHERE CreatedAt > '01/01/2022'

GetDeleted

To retrieve list email that are in the recycle bin in Pardot the following operation is supported:

GETDELETED FROM ListEmail

Columns

Name Type References Description
Id [KEY] Int64 ID of the email.
Name String Name of the object for identification in Pardot.
Subject String The email subject.
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.
CampaignId Int64 Pardot campaign related to this object.
IsPaused Boolean True if the email send is paused.
IsSent Boolean True if the email has been sent.
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
CreatedById Int64 ID of the individual who created this object.
UpdatedById Int64 ID of the individual who last updated this object.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.
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.
SentAt Datetime Time the email was sent.
OperationalEmail Boolean True if the email is operational.
EmailTemplateId Int64 ID of the email template used for the list email.
TrackerDomainId Int64 ID of the tracker domain used for the list email.
SenderOptionsType String The sending user type(s).
SenderOptionsAddress String The sending email address(s).
SenderOptionsName String The name(s) of the sender.
SenderOptionsUserId String The user ID(s) of the sender.
ReplyToOptionsType String The reply to user type(s).
ReplyToOptionsAddress String The sending email address(s).
ReplyToOptionsUserId String The user ID(s) of the sender.

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