LayoutTemplates
Retrieve and modify layout templates.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports '=', '<', '<=', '>', '>='.
- IsDeleted supports '='.
For example, the following queries are processed server side:
SELECT * FROM LayoutTemplates WHERE Id = 40 SELECT * FROM LayoutTemplates WHERE IsDeleted = 'true'
Insert
The following attributes are required when performing an insert: Name, LayoutContent.
INSERT INTO LayoutTemplates (Name, IsIncludeDefaultCss, LayoutContent, FolderId) VALUES ('name', 'true', 'content', 33621)
Update
Updating LayoutTemplates:
UPDATE LayoutTemplates SET Name = 'newName' WHERE Id = 24143
Delete
Remove all layout templates or a layout template by specifying the Id of the template.
DELETE FROM LayoutTemplates WHERE Id = 10003
GetDeleted
To retrieve layout templates that are in the recycle bin in Pardot the following operation is supported:
GETDELETED FROM LayoutTemplates
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Int64 | True |
ID of this object. | |
| Name | String | False |
Name of the object for identification in Pardot. Uses the name of the file being uploaded if not specified on create. | |
| LayoutContent | String | False |
HTML content of this layout template encoded as JSON string. | |
| FormContent | String | False |
HTML content encoded as JSON string that controls form display logic. Uses default values if not provided. | |
| SiteSearchContent | String | False |
HTML content encoded as JSON string that controls the site search content. | |
| IsIncludeDefaultCss | Boolean | False |
True if not supplying custom CSS styling. | |
| FolderId | Int64 | False |
ID of the folder containing this object. Uses the asset type's uncategorized folder if not specified on create. | |
| IsDeleted | Boolean | True |
True if the object is in the recycle bin in Pardot. | |
| CreatedAt | Datetime | True |
The timestamp of when this object was created. | |
| UpdatedAt | Datetime | True |
The timestamp of when this object was last updated. | |
| CreatedById | Int64 | True |
ID of the individual who created this object. | |
| UpdatedById | Int64 | True |
ID of the individual who last updated this object. |