JDBC Driver for Salesforce Pardot

Build 22.0.8462

EmailClicks

Retrieve email clicks.

Table Specific Information

Select

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

  • Id supports '>', '>='.
  • ListEmailId supports '='.
  • DripProgramActionId supports '='.
  • EmailTemplateId supports '='.
  • TrackerRedirectId supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM EmailClicks WHERE ListEmailId = 20
SELECT * FROM EmailClicks WHERE DripProgramActionId = 42
SELECT * FROM EmailClicks WHERE EmailTemplateId = 26 AND TrackerRedirectId = 31 AND CreatedAt > '02/03/2019 23:11:33'

Columns

Name Type References Description
Id [KEY] Int64 Pardot ID for this email click.
ProspectId Int64

Prospects.Id

Pardot ID for the associated prospect.
Url String URL of the email click.
ListEmailId Int64 Pardot ID for the associated list email. Value not present if null.
DripProgramActionId Integer Pardot ID for the associated drip program action. Value not present if null.
EmailTemplateId Int64

EmailTemplates.Id

Pardot ID for the associated email template. Value not present if null.
TrackerRedirectId Int64 Pardot ID for the associated tracker redirect. Value not present if null.
CreatedAt Datetime Time that email click occurred.

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