JDBC Driver for Salesforce Pardot

Build 22.0.8462

Users

Query the available users.

Table Specific Information

Select

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

  • 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] Int64 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 Int64 ID of the individual who created this object.
UpdatedById Int64 ID of the individual who last updated this object.

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