Send SMS with SQL Server

Send SMS using HTTP with SQL Server


Este método le permite enviar SMS a un destinatario utilizando SQL Server. Enviar un SMS con SQL Server es tan sencillo como enviar el origin, destino y el mensaje a enviar a través de una petición a nuestra API.

Example in SQL Server:

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'sms';
DECLARE @method varchar(500) = 'sendsms';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @from varchar(500) = 'Afilnet';
DECLARE @to varchar(500) = '34600000000';
DECLARE @sms varchar(500) = 'sms+test';
DECLARE @scheduledatetime varchar(500) = '';
DECLARE @output varchar(500) = '';
DECLARE @url varchar(255) = 'https://www.afilnet.com/api/http/?class='+@class+'&method='+@method+'&user='+@user+'&password='+@password+'&from='+@from+'&to='+@to+'&sms='+@sms+'&scheduledatetime='+@scheduledatetime+'&output='+@output;
DECLARE @win int
DECLARE @hr  int
DECLARE @text varchar(8000)

EXEC @hr=sp_OACreate 'WinHttp.WinHttpRequest.5.1',@win OUT
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win

EXEC @hr=sp_OAMethod @win, 'Open',NULL,'GET',@url,'false'
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win

EXEC @hr=sp_OAMethod @win,'Send'
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win

EXEC @hr=sp_OAGetProperty @win,'ResponseText',@text OUTPUT
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win

EXEC @hr=sp_OADestroy @win
IF @hr <> 0 EXEC sp_OAGetErrorInfo @win



See example in:

PHP Java C Sharp Unix Ruby on rails Python Android Objective C / iPhone SQL Server Oracle Node JS Go lang Scala lang Swift


Send an SMS to a mobile phone number


ParameterDescriptionCompulsory / Optional
class=smsClass requested: Class to which the request is madeCompulsory
method=sendsmsClass method requested: Method of the class to which the request is madeCompulsory
userUser and e-mail of your Afilnet accountCompulsory
passwordPassword of your Afilnet accountCompulsory
fromSenderCompulsory
toMobile phone number of the recipientCompulsory
smsSMS message to be sentCompulsory
scheduledatetimeSending date and time in yyyy-mm-dd hh:mm:ss formatOptional
outputOutput format of the resultOptional

When you make requests you will receive the following fields:

  •  status
  •  result (if status=success), here you will receive the following values:
    • messageid
    • credits
  •  error (if status=error), here you will receive the error code

The possible error codes are listed below

CodeDescription
MISSING_USERUser or email not included
MISSING_PASSWORDPassword not included
MISSING_CLASSClass not included
MISSING_METHODMethod not included
MISSING_COMPULSORY_PARAMCompulsory parameter not included
INCORRECT_USER_PASSWORDIncorrect user or password
INCORRECT_CLASSIncorrect class
INCORRECT_METHODIncorrect method
NO_ROUTE_AVAILABLEThere are no available paths for the indicated destination
NO_CREDITSYour balance is insufficient
Parameters:
  • class: sms
  • method: sendsms
  • user: user
  • password: password
  • from: Afilnet
  • to: 34600000000
  • sms: sms+test
  • scheduledatetime:
  • output:
Request:
https://www.afilnet.com/api/http/?class=sms&method=sendsms&user=user&password=password&from=Afilnet&to=34600000000&sms=sms+test&scheduledatetime=&output=
IMPORTANT INFORMATION ABOUT COOKIES: If you continue to use this web we will assume that you accept the terms of use. You will find more information in our Cookies Policy. Continue