ImportAndSendMessage
Imports and sends.
EXECUTE ImportAndSendMessage MessageId = 'MessageId', " +
"Keyword = 'Test_Keyword'," +
"NotificationEmail = '[email protected]'," +
"IsDuplicationAllowed = true," +
"IsDuplicationAllowed = true," +
"ImportDefinition = '[{" +
" \"FileName\": \"MyTestList.csv\"," +
" \"ImportType\": \"FILE\"," +
" \"ImportMappingType\": \"ManualMap\"," +
" \"FieldMaps\": [{" +
" \"Destination\": \"_FirstName\"," +
" \"Source\": \"First Name\"" +
" }, {" +
" \"Destination\": \"_Subscriberkey\"," +
" \"Source\": \"Subscriber Key\"" +
" }, {" +
" \"Destination\": \"_LastName\"," +
" \"Source\": \"Last Name\"" +
" }, {" +
" \"Destination\": \"_MobileNumber\"," +
" \"Source\": \"Mobile\"" +
" }, {" +
" \"Destination\": \"_CountryCode\"," +
" \"Source\": \"Country\"" +
" }]" +
" }]'
Input
| Name | Type | Required | Description |
| MessageId | String | True | Encoded message Id. |
| Keyword | String | True | A valid keyword on the shortcode for the message to opt the numbers on to. |
| NotificationEmail | String | False | If specified, email notifications will be sent on import and program completion. |
| Override | Boolean | False | Flag to indicate whether the override text should be used. |
| OverrideText | String | False | Text to override the existing message. |
| IsDuplicationAllowed | Boolean | False | If true, duplicate messages may be sent. |
| IsVisible | Boolean | False | If specified true, the import definition and list created will be visible. |
| ImportDefinition | String | True | List of Import Definitions to be created (currently limited to 1). |
Result Set Columns
| Name | Type | Description |
| TokenId | String | The token Id. |
| LastPublishDate | String | The last published date. |