DataExtensionTemplate
Represents a data extension template within an account.
View-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.
For example, the following (but not only) queries are processed server side:
SELECT * FROM DataExtensionTemplate WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | System-controlled, read-only text string identifier for object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| Name | String | Name of the object or property. |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Client_ID | Int | The Id of the client. |
| Description | String | Describes and provides information regarding the object. |
| IsSendable | Bool | Specifies whether the template is sendable. |
| IsTestable | Bool | Specifies whether the template is testable. |
| SendableCustomObjectField | String | Specifies a sendable custom object field. |
| SendableSubscriberField | String | Specifies a sendable subscriber field. |
| DataRetentionPeriodLength | String | Specifies until when should the data be retained. |
| DataRetentionPeriodUnitOfMeasure | Int | Specifies the unit of measure for the data rentention period. |
| RowBasedRetention | Bool | Specifies whether row based retention is enabled. |
| ResetRetentionPeriodOnImport | Bool | Specifies whether retention period should be reset on import. |
| DeleteAtEndOfRetentionPeriod | Bool | Specifies whether the data should be deleted at the end of the retention period. |
| RetainUntil | Datetime | Specified until when the data should be retained. |