QueueContactImport
Queues a contact import.
FieldMaps
The columns available for the FieldMaps temporary table are the following:
Column | Description |
Destination | Destination field map. |
Ordinal | Ordinal field map. |
Source | Source 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. |