DynamicContents
Retrieve dynamic contents.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement 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 DynamicContents WHERE Id = 32 SELECT * FROM DynamicContents WHERE CreatedAt > '02/03/2019 23:11:33' SELECT * FROM DynamicContents WHERE UpdatedAt > '01/03/2018 23:11:33' AND UpdatedAt <= '02/03/2019 23:11:33'
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | Pardot ID for this dynamic content. | |
| Name | String | Dynamic content's name. | |
| EmbedCode | String | Code to embed this dynamic content onto your webpage. | |
| EmbedUrl | String | URL to embed this dynamic content. | |
| BaseContent | String | The default dynamic content. | |
| BasedOn | String | Field that this dynamic content is based on. | |
| Variation | String | The variation of content prospect will see based on the field's value Note: Information about a variation is returned in a variation node in the XML response. It contains the value of the field in the comparison tag and the content of the variation in the content tag. | |
| CreatedAt | Datetime | Time dynamic content was created in Pardot. | |
| UpdatedAt | Datetime | Last time dynamic content was updated. |