Power BI Connector for Salesforce Marketing Cloud

Build 24.0.9060

PostMessageToNumber

Initiates a message to one or more mobile numbers.

Subscribers

The columns available for the Subscribers temporary table are the following:

ColumnDescription
MobileNumberSpecifies the mobile number used as the unique identifier for that record.
SubscriberKeySpecifies the SubscriberKey value used as the unique identifier for that record.
AttributesSet real-time attributes for individual personalization strings, per subscriber. The subscriber attribute must match the attribute string in the message. You can pass attributes that are not used as attributes in the message into the SMS send log.

Execute

Use mobile numbers for referecing contact records:

EXECUTE PostMessageToNumber MessageId = 'NCNSDNsd222as85dj92j2sM', mobileNumbers = '[" +
          "    \"13175551212\"" +
          "    ]', Subscribe = true, Resubscribe = true, keyword = 'JOINSMS', Override = true, messageText = 'Welcome to Code@', ContentURL = 'http://image.exct.net/lib/abcd/m/1/dj_CC_AUS.jpg', SendTime = '2012-10-05 20:01'

Use Subscribers#TEMP table as an alternate way for referecing contact records:

INSERT INTO Subscribers#TEMP (MobileNumber, SubscriberKey, Attributes) VALUES ('15555554410', 'ExampleSubKey1', '{" +
          "            \"FirstName\":\"Michael\"" +
          "            }')
INSERT INTO Subscribers#TEMP (MobileNumber, SubscriberKey, Attributes) VALUES ('15555552254', 'ExampleSubKey2', '{" +
          "            \"FirstName\":\"Kristen\"" +
          "            }')          
EXECUTE PostMessageToNumber MessageId = 'NCNSDNsd222as85dj92j2sM', Subscribe = true, Resubscribe = true, Keyword = 'JOINSMS', Override = false, SendTime = '2012-10-05 20:01' 

Input

Name Type Required Description
MessageId String True The encoded message ID.
MobileNumbers String False An array of one or more mobile numbers.
Subscribe Boolean False Flag to indicate a subscription should be created if none exist.
Resubscribe Boolean False Flag to indicate a subscription should be reset if currently unsubscribed.
Keyword String False The keyword must align with code on message. Required when subscribe and/or resubscribe are true.
Override Boolean False Flag to indicate that the contact has received the messageText as provided instead of the message's original text.
MessageText String False Text value to be used in place of the message's original text. This value is required when override is true.
UtcOffset String False The UTC offset of the blackout window start and end times. UtcOffset is required in every REST call in order for the blackout window to be honored.
WindowStart String False The start time of the blackout window, in the UTC offset specified. To see if the SendTime is within the blackout window, convert the WindowStart and WindowEnd times to UTC and compare them to the SendTime.
WindowEnd String False The end time of the blackout window, in the UTC offset specified. To see if the SendTime is within the blackout window, convert the WindowStart and WindowEnd times to UTC and compare them to the SendTime.
SendTime Date False Date and Time in UTC that the message will go out. Example format: 2012-10-17 17:01. The BlackoutWindow will still be respected if used with this option. If the SendTime is set to a date and time in the past, the message will send immediately.
ContentURL String False The URL of the media content sent via an MMS message.

Result Set Columns

Name Type Description
TokenId String A token that can be used to make a follow-up call to check the status of the request.

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