PostMessageToNumber
Initiates a message to one or more mobile numbers.
Subscribers
The columns available for the Subscribers temporary table are the following:
| Column | Description |
| MobileNumber | Specifies the mobile number used as the unique identifier for that record. |
| SubscriberKey | Specifies the SubscriberKey value used as the unique identifier for that record. |
| Attributes | Set 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. |