Sample Code for Sending SMS Messages and Logging Responses in SFMC Using QueueMO API

Introduction

In this tutorial, we will walk through the process of sending SMS messages to mobile numbers stored in a data extension and logging the responses in another data extension using Salesforce Marketing Cloud (SFMC). We will be using the QueueMO API for sending SMS messages.

Step 1: Create Data Extensions

1.1 Data Extension for Mobile Numbers

First, we need a data extension to store the mobile numbers. This data extension should have the following fields:

• mobile_number (Text, Primary Key)
• subscriberkey (Text)
• Processed (Boolean)

Example Configuration:

Data Extension Name: SMS_Mobile_Numbers
Fields: mobile_number, subscriberkey, Processed

1.2 Data Extension for Logging Responses

Next, we need a data extension to log the responses from the SMS messages:

• subscriberkey (Text)
• mobile_number (Text)
• response (Text)
• timestamp (Date)

Example Configuration:

Data Extension Name: SMS_Response_Log
Fields: subscriberkey, mobile_number, response, timestamp

Step 2: Write the Script

Below is the complete SSJS script to handle the authentication and API call. You can host this in Automation Studio as a Script Activity.

Conclusion

By following these steps, you can set up an automated system in SFMC to send and log SMS messages efficiently. Feel free to customize the placeholders in the script to fit your specific REST credentials and Business Unit requirements.