Send SMS with SQL Server
Send SMS using HTTP with SQL Server
SQL Server : METHODS
SMS
TEXT-TO-SPEECH
- Send voice text-to-speech
- Send voice from template
- Send bulk voice
- Send bulk voice from template
- Get voice delivery status
- Send Email
- Send Email from template
- Send bulk Email
- Send Bulk Email from template
- Get email delivery status
SOCIAL NETWORKS
GROUPS
- Create group
- Get group field list
- Add a field to a group
- Delete a field from a group
- Delete a contact from a group
- Assing country to e group
- Get group contact list
- Add contact to a group
- Modify contact of a group
- Delete contact of a group
HLR
COUNTRIES
EVENTS
USER
TEMPLATES
OTP (ONE-TIME PASSWORD)
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.
Coming soon...
Send an SMS to a mobile phone number
| Parameter | Description | Compulsory / Optional |
|---|---|---|
| class=sms | Class requested: Class to which the request is made | Compulsory |
| method=sendsms | Class method requested: Method of the class to which the request is made | Compulsory |
| user | User and e-mail of your Afilnet account | Compulsory |
| password | Password of your Afilnet account | Compulsory |
| from | Sender | Compulsory |
| to | Mobile phone number of the recipient | Compulsory |
| sms | SMS message to be sent | Compulsory |
| scheduledatetime | Sending date and time in yyyy-mm-dd hh:mm:ss format | Optional |
| output | Output format of the result | Optional |
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
| Code | Description |
|---|---|
| MISSING_USER | User or email not included |
| MISSING_PASSWORD | Password not included |
| MISSING_CLASS | Class not included |
| MISSING_METHOD | Method not included |
| MISSING_COMPULSORY_PARAM | Compulsory parameter not included |
| INCORRECT_USER_PASSWORD | Incorrect user or password |
| INCORRECT_CLASS | Incorrect class |
| INCORRECT_METHOD | Incorrect method |
| NO_ROUTE_AVAILABLE | There are no available paths for the indicated destination |
| NO_CREDITS | Your 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=
