Create a Data Extension

Use a data extension to store information about your subscribers in Marketing Cloud.

This example creates a data extension to import or store data. After the data extension is created, associate it with an import definition. This example maps EmailAddress field of the data extension to Marketing Cloud field EmailAddress to create a data extension used to store the audience of an email send.

While you can create a data extension with an external key larger than 36 characters, doing so may cause problems when using the data extension in conjunction with other processes (especially if working with the UI, which truncates the external key to the first 36 characters). Limit your data extension external keys to 36 characters to help ensure all further processes function correctly.

Sample .NET Code

Sample PHP Code

Sample Java Code (Axis 1.4)

This sample code demonstrates how to create a data extension using the subscriber key feature:

Sample Ruby on Rails Code

Sample Ruby on Rails Code for Create a Sendable Data Extension

Sample SOAP Create Request

Sample SOAP Create Response

Sample SOAP Request with Non-Nullable Fields

The SOAP envelope below creates a data extension with a non-nullable field by including IsPrimaryKey and IsRequired values.

Sample SOAP Create Request Using Different Field Types

The sample SOAP envelope below includes an example of data extension field types.

Sample SOAP Request Creating a Data Extension with Data Retention Options

Sample SOAP Request Setting Decimal Field Types in a Data Extension

When creating a field with the Decimal data type in a data extension, you must set the precision and the scale of the field.

Sample SOAP Request Creating a Date Value in a Date-type Field

Note that the time must be passed in 24-hour format.