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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.
For example, the following (but not only) queries are processed server side:
SELECT * FROM Template
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. |