MuleSoft Connector for Salesforce Marketing Cloud

Build 20.0.7654

Template

Represents an email template in a Marketing Cloud account.

Table-Specific Information

Select

The connector 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 connector processes other filters client-side within the connector. 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654