Hi,
I am not sure how do you exactly want to send SMS with MS SQL store procedure, which is a database environment. Can you explain more details how and what you want to achieve?
Meanwhile, check
this tutorial to learn how you could implement an A2P SMS application.
Hope this helps,
+ Phong
Hi, thx for your reply, we are using Microsoft SQL server database, where we have a table with all the phone numbers to send SMS, (each SMS is unique to that number),
we want to build a DB job to automate this, below is the sample code which we are going to using ,
it will be helpful if you provide us all the steps (e.g. API to login and get the token so that token we will use in SMS API )
--- below is the sql sample code, this is working fine if I login manually and collect the token from browser trace/debugger
Declare @Object as Int;Declare @ResponseText as Varchar(8000);DECLARE @reqHead AS VARCHAR(8000) = '{"Authorization": "U0pDMTFQMDFQQVMwMHxBQUF3NlMxZlNtZ1NCZEF5NTJrd1BnOFZkOWhhdlVnZkdGamVTeVpTTGxWdjhscmY4ZHN0NjlvQm1Lc0poVkZZbXNsNF9QWWRPMEVYNEV2UTBjM2U1NkM0MFk0SDhFeUVhUkhIczcycTVONm13MjNxcV9xVFkxUHA1cXZjWmZLMXEzcDBXaWdqNm4zdllvLUUyT1ZCSHExZmRvRFJIWVlnYXBKR1htc2JrZ0dWemVmQTRfLXU3WEUtSngwbTRLNzhIeDRKVVN6ZkR6NnRpUjIybjZmLU12cmN8VjVqczBRfFVEdzVrQ3BLbFduOTZFbzZ6c1d6QkF8QUE"}'DECLARE @Body AS VARCHAR(8000) = '{ "from": {"phoneNumber": "+17xxxxxxxx1"}, "to": [{"phoneNumber": "+152xxxxxxxx4"}], "text": "Hello, Jack"}' -- Code Snippet MSXML2.ServerXMLHttp MSXML2.XMLHTTPExec sp_OACreate 'MSXML2.ServerXMLHttp', @Object OUT;Exec sp_OAMethod @Object, 'open', NULL, 'post','https://platform.devtest.ringcentral.com/restapi/v1.0/account/~/extension/~/sms', 'false'EXEC sp_OAMethod @Object, 'setRequestHeader', @reqHead, 'Content-Type', 'application/json'Exec sp_OAMethod @Object, 'send', null, @bodyExec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUTSelect @ResponseTextExec sp_OADestroy @Object
Hi Jeevi,
Why are you posting this types of links in this forum.