JDBC Driver for Salesforce Marketing Cloud

Build 24.0.9062

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.

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