JDBC Driver for Salesforce Marketing Cloud

Build 24.0.9062

QueueContactImport

Queues a contact import.

FieldMaps

The columns available for the FieldMaps temporary table are the following:

ColumnDescription
DestinationDestination field map.
OrdinalOrdinal field map.
SourceSource field map.

Execute


INSERT INTO FieldMaps#TEMP (destination, ordinal, source) VALUES ('_MobileNumber', 2, 'mobile number')
INSERT INTO FieldMaps#TEMP (destination, ordinal, source) VALUES ('_CountryCode', 3, 'locale')
INSERT INTO FieldMaps#TEMP (destination, ordinal, source) VALUES ('_SubscriberKey', 1, 'subscriber key')
EXECUTE QueueContactImport ListId = 'UEhwdktFWXpFZUs3Z3hRUW45R2dBQTo2Mzow', ShortCode = '90913', Keyword = 'WELCOME', SendEmailNotification = true, EmailAddress = '[email protected]', " +
          "ImportMappingType = 'MapByOrdinal', FileName = 'testdata.csv', FileType = 'csv', IsFirstRowHeader = true

Input

Name Type Required Description
ListId String True The list id.
ShortCode String False The short code.
Keyword String False The keyword.
SendEmailNotification Boolean False Send email notification.
EmailAddress String False Email address the notification goes to.
ImportMappingType String False Field mapping type.
FileName String False The name of the file, including extensions.
FileType String False The only type supported is csv.
IsFirstRowHeader Boolean False Flag indicating whether or not the first row is the header.

Result Set Columns

Name Type Description
TokenId String The token Id of the queued contact import.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062