MuleSoft Connector for Salesforce Pardot

Build 21.0.7930

EmailClicks

Retrieve email clicks.

Table Specific Information

Select

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

  • 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 Description
Id [KEY] Integer Pardot ID for this email click.
ProspectId Integer Pardot ID for the associated prospect.
Url String URL of the email click.
ListEmailId Integer 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 Integer Pardot ID for the associated email template. Value not present if null.
TrackerRedirectId Integer Pardot ID for the associated tracker redirect. Value not present if null.
CreatedAt Datetime Time that email click occurred.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930