ImportDefinition
The ImportDefinition object defines a reusable pattern of import options. For example, you could create an import definition to upload Subscribers.csv every day into the Customers list to prevent having to re-enter the same parameters every day.
If you import information to a data extension, you must create a data extension object and set the ObjectID property or customer key on the data extension object. You must then set the DestinationObject property to that object. If you are importing to a list, you must create a list object, set an ID property, and set the DestinationObject property to that object. You must specify the ID property for a list. Imports don't currently support the use of ObjectID or CustomerKey when importing to a list.
You can specify what character encoding you wish to use with your imports, but this specification applies to all imports in an account and can only be enabled by your Account Executive.
- To create an ImportDefinition where the destination object is a list, you need the Email | Subscribers | List | Import Subscribers permission.
- To create or update an ImportDefinition where the destination object is a data extension, you need the Email | Subscribers | Data Extension | Import and Manage Data permissions.
- To create or update an ImportDefinition where the destination object is a list and the list ID is the All Subs List ID, you need the Email | Subscribers | All Subscribers | Import Subscribers and View permissions.
| Name | Data Type | Description |
|---|---|---|
| AllowErrors | xsd | Specifies whether an import continues after an error occurs. A value of true permits the import process to continue, and a value of false stops the import process after the first error. |
| AutoGenerateDestination | ImportDefinitionAutoGenerateDestination | Specifies the properties of the destination to be generated automatically during an import. |
| Client | ClientID | Specifies the account ownership and context of an object. |
| ControlColumn | xsd | Specifies the column name in which to find control values as part of an import (use when the value ofImportDefinitionUpdateTypeis ColumnBased). |
| ControlColumnActions | ImportDefinitionColumnBasedAction[] | Specifies the control column actions to apply to an import. |
| ControlColumnDefaultAction | ImportDefinitionColumnBasedActionType | Defines default control column action to take as part of an import definition. Valid values include:
|
| CorrelationID | xsd | Identifies correlation of objects across several requests. |
| CreatedDate | xsd | Read-only date and time of the object's creation. |
| CustomerKey | xsd | User-supplied unique identifier for an object within an object type. This property corresponds to the external key assigned to an object. |
| DateFormattingLocale | Locale | Specifies how dates are formatted in import data; used to ensure the data is interpreted correctly when it is being loaded. |
| DeleteFile | Boolean | Indicates whether the call deletes the file used in the import once the process completes. |
| Delimiter | xsd | Specifies the delimiter used as part of an import definition. |
| Description | xsd | Describes and provides information regarding the object. |
| DestinationObject | APIObject | Specifies the destination of an import. |
| DestinationType | xsd | Reserved for future use. |
| EndOfLineRepresentation | xsd | Specifies the line-ending character(s) used in delimited files to be imported. |
| FieldMappingType | ImportDefinitionFieldMappingType | Defines how fields are mapped within an import definition. Valid values include:
|
| FieldMaps | FieldMap[] | Specifies the mapping of fields to columns in a file. |
| FileSpec | xsd | Defines the file-naming pattern associated with an activity (valid substitutions include%%YEAR%%, %%MONTH%%, and %%DAY%%). |
| FileType | FileType | Specifies column delimiter of a file. Valid values include:
|
| Filter | xsd | Specifies filter to apply to retrieve. |
| HeaderLines | xsd | Specifies the number of header lines in the file to ignore. |
| ID | xsd | Read-only identifier for an object. Some objects use the ObjectID property as a unique ID. |
| InteractionObjectID | xsd | Returns associated ID for activities within the asynchronous process of the overall conversation or program. |
| Keyword | xsd | Reserved for future use. |
| MaxFileAge | xsd | Specifies the age of the oldest file to be included in an import definition. Any files older than the maximum age are not included in the import definition. |
| MaxFileAgeScheduleOffset | xsd | Specifies an offset in hours to associate with a file age for accomodating timezone differences. This time represents the maximum allowable difference between the scheduled time and the time the import definition actually accesses the file to be imported. |
| MaxImportFrequency | xsd | Specifies the number of hours to wait before allowing a file to be imported again. This property prevents an import definition run within a program from executing if a specified number of hours have passed since the program began. |
| ModifiedDate | Nullable`1 | Indicates the last time object information was modified. |
| Name | xsd | Name of the object or property. |
| Notification | AsyncResponse | Specifies the email address to which to send a notification. |
| NullRepresentation | xsd | Defines character used to represent a null value during an import. |
| ObjectID | xsd | System-controlled, read-only text string identifier for object. |
| ObjectState | xsd | Reserved for future use. |
| Owner | Owner | Describes account ownership of subscriber in an on-your-behalf account. |
| PartnerKey | xsd | Unique identifier provided by partner for an object. This property is accessible only via API. |
| PartnerProperties | APIProperty[] | A collection of metadata supplied by the client and stored by the system. These properties are accessible only via API. |
| RetrieveFileTransferLocation | FileTransferLocation | Specifies the file transfer location to contain the file. |
| SourceObject | APIObject | Specifies source of the import. |
| StandardQuotedStrings | xsd | Specifies whether standard quoted strings are used as part of an import definition. A true value indicates standard quoted strings are used in an import definition. |
| SubscriberImportType | ImportDefinitionSubscriberImportType | Specifies the subscriber import type for an import definition. Valid values include Email and SMS. |
| SubscriptionDefinitionId | xsd | Identifies subscription to which the import definition is associated. |
| UpdateType | ImportDefinitionUpdateType | Indicates update type associated with an import definition. Valid values include:
|