ODBC Driver for Salesforce Marketing Cloud

Build 24.0.9060

SendTransactionalMessageToRecipient

Sends a message to a single recipient via a send definition.

Execute

Send a transactional message:

Attributes support either JSON or temp table as input. For example,

EXECUTE SendTransactionalMessageToRecipient MessageKey = 'e1c35141-6e5c-4bc2-813b-60f969e52b0d', DefinitionKey = 'CanBeAGUIDorAny100UnicodeCharString', RecipientContactKey = 'd3c4a2d2-b620-4a39-88aa-b14868b766c6', RecipientTo = '[email protected]', Attributes = '{"UserAttr_1":"UserAttrValue_1","UserAttr_2":"UserAttrValue_2"}'

INSERT INTO Attributes#TEMP (UserAttr_1, UserAttr_2) VALUES ('UserAttrValue_1', 'UserAttrValue_2');

EXECUTE SendTransactionalMessageToRecipient MessageKey = 'e1c35141-6e5c-4bc2-813b-60f969e52b0d', DefinitionKey = 'CanBeAGUIDorAny100UnicodeCharString', RecipientContactKey = 'd3c4a2d2-b620-4a39-88aa-b14868b766c6', RecipientTo = '[email protected]', Attributes = 'Attributes#TEMP';

Input

Name Type Required Description
MessageKey String True User-defined message identifier.
DefinitionKey String True Unique identifier of the definition.
RecipientContactKey String True Unique identifier for a subscriber in Marketing Cloud. Each request must include a contactKey. You can use an existing subscriber key or create one at send time by using the recipient's email address.
RecipientTo String False Channel address of the recipient. For email, it's the recipient's email address.
Attributes String False Information used to personalize the message for the recipient. Written as key pairs. The attributes match profile attributes, content attributes, or triggered send data extension attributes.

Result Set Columns

Name Type Description
RequestId String The unique identifier of this request.

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