ODBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

ImportDefinition

Defines a reusable pattern of import options. This table does not support inserts.

Table-Specific Information

Select

The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

For example, the following (but not only) queries are processed server side: 

SELECT * FROM ImportDefinition

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

System-controlled, text string identifier for object.

PartnerKey String False

Unique identifier provided by partner for an object, accessible only via API.

Client_ClientID1 Int False

The client Id of the client.

Name String False

Name of the object or property.

CustomerKey String False

User-supplied unique identifier for an object within an object type.

Description String False

Describes and provides information regarding the object.

FileSpec String False

Defines the file-naming pattern associated with an activity (valid substitutions include%%YEAR%%, %%MONTH%%, and %%DAY%%).

AllowErrors Bool False

Specifies whether an import should continue after an error occurs.

FieldMappingType String False

Defines how fields are mapped within an import definition.

FileType String False

Specifies column delimiter of a file (CSV, TAB, or Other).

UpdateType String False

Indicates update type associated with an import definition.

MaxFileAge Int False

Specifies the age of the oldest file to be included in an import definition.

MaxFileAgeScheduleOffset Int False

Specifies an offset in hours to associate with a file age for accomodating timezone differences.

MaxImportFrequency Int False

Specifies the number of hours to wait before allowing a file to be imported again.

DestinationObject_ID Int False

Identifier for an object.

DestinationObject_ObjectID String False

System-controlled, text string identifier for object.

Notification_ResponseType String True

The response type of the notification.

Notification_ResponseAddress String False

The response address of the notification.

RetrieveFileTransferLocation_ObjectID String False

System-controlled, text string identifier for object.

Delimiter String False

Specifies the delimiter used as part of an import definition.

HeaderLines Int False

Specifies the number of lines in the file that are header lines that should not be processed.

EndOfLineRepresentation String False

Specifies the line-ending character(s) used in delimited files to be imported.

NullRepresentation String False

Defines character used to represent a null value during an import.

StandardQuotedStrings Bool False

Specifies whether standard quoted strings are used as part of an import definition.

DateFormattingLocale_LocaleCode String False

The locale code of the date formatting locale.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462