QueueContactImport
Queues a contact import job in Salesforce Marketing Cloud. This procedure prepares contact data for processing and import into the system, allowing for asynchronous execution and progress tracking.
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 | Specifies the list identifier (Id) that determines to which MobileConnect list the imported contacts should be added. This Id links the file import to the appropriate subscription list. |
| ShortCode | String | False | Specifies the short code that is associated with the import. The short code defines the messaging channel through which contacts can receive future messages. |
| Keyword | String | False | Specifies the keyword that applies to the import. The keyword determines the subscription context that is assigned to the imported contacts. |
| SendEmailNotification | Boolean | False | Specifies whether an email notification should be sent when the contact import begins or completes. A value of 'true' enables notifications. |
| EmailAddress | String | False | Specifies the email address that receives the import notification when the SendEmailNotification field is set to 'true'. |
| ImportMappingType | String | False | Specifies the field mapping strategy that is used to interpret the columns in the import file. This value determines how file fields map to MobileConnect attributes. |
| FileName | String | False | Specifies the name of the import file, including its extension. The file must be uploaded to the designated Enhanced FTP location before processing. |
| FileType | String | False | Specifies the type of that is file used for the import. The only supported file type is a .csv file. |
| IsFirstRowHeader | Boolean | False | Specifies whether the first row of the file contains column headers. A value of 'true' treats the first row as header information. |
Result Set Columns
| Name | Type | Description |
| TokenId | String | Specifies the token Id that is generated for the queued contact import. This Id can be used to check the processing status in a follow-up request. |