Table Specific Information
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 '=', '<', '<=', '>', '>='.
- Email supports '='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE Id = 32 SELECT * FROM Users WHERE Email = "firstname.lastname@example.org" SELECT * FROM Users WHERE CreatedAt < '02/03/2019 23:11:33' AND CreatedAt > '02/03/2018 23:11:33'
|Id [KEY]||Integer||Pardot ID of the user.|
|String||User's email address.|
|FirstName||String||User's first name.|
|LastName||String||User's last name.|
|JobTitle||String||User's job title.|
|CreatedAt||Datetime||Time user was created in Pardot; Time is reported in the API user's preferred timezone.|
|UpdatedAt||Datetime||Last time user was updated in Pardot; Time is reported in the API user's preferred timezone.|