SQL Server

Send SMS Messages via Route Mobile's SMSPlus REST API

See more HTTP Misc Examples

Demonstrates how to use the Route Mobile SMSPLUS Bulk HTTP API. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- This requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @req int
    EXEC @hr = sp_OACreate 'Chilkat.HttpRequest', @req OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @req, 'Path', '/bulksms/bulksms'
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'username', 'YOUR_USERNAME'
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'password', 'YOUR_PASSWORD'

    -- Indicate the type of message. 
    -- Values for type include: 
    -- 0: Plain text (GSM 3.38 Character encoding) 
    -- 1: Flash (GSM 3.38 Character encoding)  
    -- 2: Unicode 
    -- 3: Reserved  
    -- 4: WAP Push 
    -- 5: Plain text (ISO-8859-1 Character encoding)  
    -- 6: Unicode Flash 
    -- 7: Flash (ISO-8859-1 Character encoding) 
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'type', '0'

    -- destination is the Mobile number to which the message is to be sent 
    -- (may or may not include a plus [+] sign). 
    -- Multiple mobile numbers can be separated by commas (,)
    -- No need to URL encode strings passed to AddParam. 
    -- Chilkat will automatically URL encode when the request is sent.
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'destination', '+14155551234'

    -- Specify the source address that should appear in the message.
    -- Max Length of 18 if numeric.
    -- Max Length of 11 if alphanumeric. To prefix the plus sign (+) to the sender�s address 
    -- when the message is displayed on their cell phone, please prefix the plus sign 
    -- to your sender�s address while submitting the message 
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'source', '+14155558999'

    -- Add the message itself.  (No URL encoding needed.)
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'message', 'Test Message'

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT

    EXEC sp_OASetProperty @req, 'HttpVerb', 'POST'
    EXEC sp_OASetProperty @req, 'ContentType', 'application/x-www-form-urlencoded'

    DECLARE @resp int
    EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT

    EXEC sp_OAMethod @http, 'HttpReq', @success OUT, 'http://api.rmlconnect.net/bulksms/bulksms', @req, @resp
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @req
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @resp
        RETURN
      END

    -- Examine the response status code and the response body:

    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    PRINT 'response status code = ' + @iTmp0

    PRINT 'response body:'
    EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @req
    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @resp


END
GO