Template
Represents an email template in a Marketing Cloud account.
Table-Specific Information
Select
The driver uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The driver processes other filters client-side within the driver.
For example, the following (but not only) queries are processed server side:
SELECT * FROM Template WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM Template WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM Template WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID | String | System-controlled, read-only text string identifier for object. |
| ID [KEY] | Int | Read-only identifier for an object. |
| Client_ID | Int | The Id of the client. |
| TemplateName | String | Name used to identify template within Marketing Cloud application. |
| LayoutHTML | String | Contains HTML used to define layout of fields and content within template. |
| BackgroundColor | String | Specifies background color used for template. |
| BorderColor | String | Specifies border color used in template. |
| BorderWidth | Int | Specifies border pixel width used in template. |
| Cellpadding | Int | Specifies pixel width of padding within cells used in template. |
| Cellspacing | Int | Specifies pixel spacing between cells used in template. |
| Width | Int | Specifies the pixel width of the entire template |
| Align | String | Indicates the alignment of elements within the template. |
| ActiveFlag | Int | Indicates whether the template is available for use within the account. |
| CategoryID | Int | Indicates whether content validation has completed for this email message. |
| CategoryType | String | Identifies correlation of objects across several requests. |
| OwnerID | Int | Specifies MID of business unit that created the template within an Enterprise 2.0 account. |
| HeaderContent_ID | Int | The Id of the header content. |
| HeaderContent_ObjectID | String | System-controlled, read-only text string identifier for object. |
| Layout_ID | Int | The Id of the layout. |
| Layout_LayoutName | String | The name of the layout. |
| CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| TemplateSubject | String | Contains email subject line specified by the template. |
| IsTemplateSubjectLocked | Bool | Indicates whether the subject defined in the header can be changed or not by email using template. |