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 '=', '<', '<=', '>', '>='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM Forms WHERE Id <= 17 SELECT * FROM Forms WHERE CreatedAt > '02/03/2019 23:11:33' SELECT * FROM Forms WHERE UpdatedAt > '01/03/2018 23:11:33' AND UpdatedAt <= '02/03/2019 23:11:33'
|Id [KEY]||Integer||Pardot ID for this form.|
|CampaignId||String||Pardot ID of the campaign associated with this form.|
|EmbedCode||String||The code used to embed the form on your webpage.|
|CreatedAt||Datetime||Time form was created in Pardot.|
|UpdatedAt||Datetime||Last time form was updated.|