DataExtension

The DataExtension object represents a data extension within an account.

  • To create or update a DataExtension, and if your account has the data extension retention policies business rule and any data retention fields are populated, you need the Data Extension | Manage Data Extension Retention permission. Data retention fields are: DataRetentionPeriod, DataRetentionPeriodLength, DataRetentionPeriodUnitOfMeasure, RowBasedRetention, ResetRetentionPeriodOnImport, DeleteAtEndOfRetentionPeriod, and RetainUntil.
  • To clear data from a DataExtension using the perform method, you need the Email | Subscribers | Data Extension | Clear Data permission. Also, your AccountType must be E2.0 or BU, or you need the role based access control business rule. If you don't own the data extension, you can't clear its data.

Properties

NameData TypeDescription
CategoryIDxsdSpecifies the identifier of the folder.
ClientClientIDSpecifies the account ownership and context of an object.
CorrelationIDxsdIdentifies correlation of objects across several requests.
CreatedDatexsdRead-only date and time of the object's creation.
CustomerKeyxsdUser-supplied unique identifier for an object within an object type. This property corresponds to the external key assigned to an object in Marketing Cloud.
DataRetentionPeriodDateTimeUnitOfMeasureSpecifies the period during which the application retains the data within a data extension. Valid values include:
  • Days
  • Weeks
  • Months
  • Years
DataRetentionPeriodLengthxsdSpecifies the number of time units for which data is retained. This property is used with DataRetentionPeriodUnitOfMeasureto specify the full data retention time.
DataRetentionPeriodUnitOfMeasurexsdSpecifies the units of time for which data is retained. Deprecated. Use DataRetentionPeriodLength and DataRetentionPeriod instead.
DeleteAtEndOfRetentionPeriodxsdIndicates whether data is deleted at the end of the retention period. If the value is false, the application deletes the entire data extension. If the value is true, the application deletes the data within the data extension but retains the data extension itself.
DescriptionxsdDescribes and provides information regarding the object.
FieldsDataExtensionField[]Specifies fields contained within a data extension.
IDxsdRead-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID.
IsSendablexsdIndicates whether you can use a data extension as part of an audience for a message send.
IsTestablexsdIndicates whether a sendable data extension can be used within tests sends for a message.
ModifiedDateNullable`1Indicates the last time object information was modified.
NamexsdName of the object or property.
ObjectIDxsdSystem-controlled, read-only text string identifier for object.
ObjectStatexsdReserved for future use.
OwnerOwnerDescribes account ownership of subscriber in an on-your-behalf account.
PartnerKeyxsdUnique identifier provided by partner for an object. This property is accessible only via API.
PartnerPropertiesAPIProperty[]A collection of metadata supplied by the client and stored by the system. These properties are accessible only via API.
ResetRetentionPeriodOnImportxsdIndicates whether a data retention period is reset after a successful import of new data. A value of true indicates that the data retention period resets to the beginning upon completion of a successful data import. A value of false indicates that the data retention period continues from the original starting point.
RetainUntilxsdIndicates the date that ends the retention period for a data extension. Make sure that the value passed to this property is correctly formatted based on the Date Format setting of the API user. Failure to do so may result in an error.
RowBasedRetentionxsdIndicates whether the data retention policy removes data by row or deletes all data in an entire data extension. A value of true indicates that all records within a data extension are removed at the same time. A value of false indicates that the application can remove individual rows within a data extension.
SendableDataExtensionFieldDataExtensionFieldIndicates the field within a sendable data extension to use as an address as part of a send. Possible values include SubscriberID, CustomerKey, or EmailAddress. The application uses this field to establish a data relationship between a value specified by theSendableSubscriberFieldproperty and a value within a sendable data extension.
SendableSubscriberFieldAttributeIndicates field to use as sending address. The application uses this field to establish a data relationship between a subscriber field and a value specified by the SendableDataExtensionField property.
StatusxsdDefines status of object. Status of an address.
TemplateDataExtensionTemplateIndicates template used to create a data extension.

The DataExtensionObject does not support LIKE operators in filters for the retrieve method.