TDV Adapter for Salesforce Pardot

Build 21.0.8137

Users

Query the available users.

Table Specific Information

Select

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

  • Id supports '=', '<', '<=', '>', '>='.
  • IsDeleted supports '='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = 32
SELECT * FROM Users WHERE CreatedAt < '02/03/2019 23:11:33' AND CreatedAt > '02/03/2018 23:11:33'

Get Deleted

To retrieve deleted users, a GETDELETED statement can be executed.

GETDELETED FROM Users

Columns

Name Type References Description
Id [KEY] Integer Pardot ID for this object.
Email String Email address of the user.
FirstName String First name of the user.
Username String Formatted as an email address, though distinct from the email field on the user object.
JobTitle String Job title of the user.
Role String Role of the user.
SalesforceId String Salesforce Id of the object.
IsDeleted Boolean True if the object is in the recycle bin in Pardot.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.
CreatedById Integer ID of the individual who created this object.
UpdatedById Integer ID of the individual who last updated this object.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137