MergeTriggerSMS()

Merges members to a Profile List and sends Oracle Responsys SMS Campaigns to them.

Parameters

Campaign_Name

SQL_VARCHAR(255)

The name of the campaign.

Body_File

SQL_VARCHAR(4096)

A JSON file containing the request body.

Returns

The procedure returns a JSON table with the following columns:

Column Name Column Type

Column Name	Column Type
`Recipient_ID` The Oracle Responsys ID (RIID) of the recipient.	SQL_INTEGER
`Success_Status` Indicates success or failure.	SQL_BIT
`Error_Messages` The error message, if any, that occurred during the trigger operation.	SQL_VARCHAR(255)

Recipient_ID

The Oracle Responsys ID (RIID) of the recipient.

SQL_INTEGER

Success_Status

Indicates success or failure.

SQL_BIT

Error_Messages

The error message, if any, that occurred during the trigger operation.

SQL_VARCHAR(255)