ImportDefinition
Defines reusable import definitions in Salesforce Marketing Cloud. Each import definition specifies the file location, mapping, and data extension target for recurring import operations. This table supports query and update operations, but it does not allow inserts because imports are configured through the application interface.
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.
For example, the following (but not only) queries are processed server side:
SELECT * FROM ImportDefinition WHERE ObjectID = 'nzxcaslkjd-123'
SELECT * FROM ImportDefinition WHERE ObjectID IN ('nzxcaslkjd-123', 'nzxcaslkjd-456')
SELECT * FROM ImportDefinition WHERE CreatedDate > '2017/01/25'
Update
You must specify the ObjectId in the WHERE clause when executing an update against this table.
UPDATE ImportDefinition SET Name = 'Changed' WHERE ObjectId = 'nzxcaslkjd-123'
Delete
You must specify the ObjectId in the WHERE clause when executing a delete against this table.
DELETE FROM ImportDefinition WHERE ObjectId = 'nzxcaslkjd-123'
Columns
| Name | Type | ReadOnly | Description |
| ObjectID [KEY] | String | False |
Specifies the system-controlled text string identifier (Id) that uniquely represents this import definition object. |
| PartnerKey | String | False |
Specifies the unique partner-provided Id for this object, which is accessible only through API-level integrations. |
| Client_ClientID1 | Int | False |
Specifies the client Id that is associated with the account context in which this import definition operates. |
| Name | String | False |
Specifies the name of the import definition. |
| CustomerKey | String | False |
Specifies the user-supplied unique Id for this import definition within its object type. |
| Description | String | False |
Provides descriptive information that explains the purpose and configuration of the import definition. |
| FileSpec | String | False |
Specifies the file-naming pattern that the import process expects. Valid substitutions include %%YEAR%%, %%MONTH%%, and %%DAY%%, which allow dynamic file-name resolution. |
| AllowErrors | Bool | False |
Returns a value of 'true' when the import is permitted to continue after an error occurs. It returns a value of 'false' when the import must stop upon encountering an error. |
| FieldMappingType | String | False |
Specifies how the system maps fields between the imported file and the destination data structure for this import definition. |
| FileType | String | False |
Specifies the column delimiter type that is used in the import file (for example, 'CSV', 'TAB', or 'Other'). |
| UpdateType | String | False |
Specifies the update behavior that is applied to records during the import process. |
| MaxFileAge | Int | False |
Specifies the maximum allowable age, expressed in hours, of the oldest file that can be included in this import definition. |
| MaxFileAgeScheduleOffset | Int | False |
Specifies the number of hours used as an offset when calculating file age, which allows the import schedule to account for timezone differences. |
| MaxImportFrequency | Int | False |
Specifies the minimum number of hours the system must wait before allowing another file to be imported. |
| DestinationObject_ID | Int | False |
Specifies the destination object's Id. |
| DestinationObject_ObjectID | String | False |
Specifies the system-controlled text string Id of the destination object. |
| Notification_ResponseType | String | True |
Specifies the notification response type that is used when the import process generates a notification. |
| Notification_ResponseAddress | String | False |
Specifies the email address or endpoint to which the import notification should be sent. |
| RetrieveFileTransferLocation_ObjectID | String | False |
Specifies the system-controlled text string Id of the file transfer location from which import files are retrieved. |
| Delimiter | String | False |
Specifies the delimiter that is used to separate data within the imported file. |
| HeaderLines | Int | False |
Specifies the number of header lines in the file that should be ignored during processing. |
| EndOfLineRepresentation | String | False |
Specifies the line-ending character or character sequence that is used in the import file. |
| NullRepresentation | String | False |
Specifies the character or sequence that represents a null value during the import process. |
| StandardQuotedStrings | Bool | False |
Returns a value of 'true' when the import process uses standard quoted-string handling. It returns a value of 'false' when the import process uses non-standard handling. |
| DateFormattingLocale_LocaleCode | String | False |
Specifies the locale code that is used to interpret date formats during the import process. |