Table Specific Information
The add-in 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 add-in.
- 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.|