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. |