Email API for SQL Server

Send Email with our API for SQL Server easily and securely. Try our API for SQL Server for free. Our team will help you to integrate the automated sending of emails and Email Marketing campaigns in your application in SQL Server.

Email API functionality

Send email with SQL Server

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'email';
DECLARE @method varchar(500) = 'sendemail';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @subject varchar(500) = 'Afilnet - Test email';
DECLARE @to varchar(500) = 'test@test.com';
DECLARE @email varchar(500) = 'email+test';
DECLARE @attachments varchar(500) = '[{\"url\":\"https://test.com/test1.pdf\",\"name\":\"Test 1\"},{\"url\":\"https://test.com/test2.pdf\",\"name\":\"Test 2\"}]';
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+'&subject='+@subject+'&to='+@to+'&email='+@email+'&attachments='+@attachments+'&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
Parameter Description Compulsory / Optional
class=email Class requested: Class to which the request is made Compulsory
method=sendemail 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
subject Sender ID Compulsory
to Destination email Compulsory
email Email message to be sent Compulsory
attachments JSON que contiene la lista de archivos con los campos (name, url) que se enviarán adjuntos Optional
scheduledatetime Delivery date and time in yyyy-mm-dd hh:mm:ss format Optional
output Output format of the result Optional
Answer:
  • 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

Error codes:
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

Send email from template with SQL Server

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'email';
DECLARE @method varchar(500) = 'sendemailfromtemplate';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @to varchar(500) = '34600000000';
DECLARE @idtemplate varchar(500) = '1000';
DECLARE @params varchar(500) = 'mobile:123456789,name:test+name';
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+'&to='+@to+'&idtemplate='+@idtemplate+'¶ms='+@params+'&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
Parameter Description Compulsory / Optional
class=email Class requested: Class to which the request is made Compulsory
method=sendemailfromtemplate 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
to Destination email Compulsory
idtemplate Template identifier Compulsory
params Parameters to be replaced in the template for customization (<>), separated by , (commas) Optional
scheduledatetime Delivery date and time in yyyy-mm-dd hh:mm:ss format Optional
output Output format of the result Optional
Answer:
  • 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

Error codes:
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
NOT_ACCESS_TO_TEMPLATE You haven't access to the selected template

Send bulk email with SQL Server

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'email';
DECLARE @method varchar(500) = 'sendemailtogroup';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @subject varchar(500) = 'Afilnet - Test email';
DECLARE @idgroup varchar(500) = '1';
DECLARE @email varchar(500) = 'Afilnet - Test email';
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+'&subject='+@subject+'&idgroup='+@idgroup+'&email='+@email+'&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
Parameter Description Compulsory / Optional
class=email Class requested: Class to which the request is made Compulsory
method=sendemailtogroup 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
subject Remitente Compulsory
idgroup Identifier of the destination group Compulsory
email Email message to be sent Compulsory
scheduledatetime Delivery date and time in yyyy-mm-dd hh:mm:ss format Optional
output Output format of the result Optional
Answer:
  • status
  • result (if status=success), here you will receive the following values:
    • id
    • count
    • credits
    • destinations
      • messageid
      • destination
  • error (if status=error), here you will receive the error code

Error codes:
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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group
NO_CREDITS Your balance is insufficient

Send bulk email from template with SQL Server

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'email';
DECLARE @method varchar(500) = 'sendemailtogroupfromtemplate';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @idgroup varchar(500) = '1000';
DECLARE @idtemplate varchar(500) = '1000';
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+'&idgroup='+@idgroup+'&idtemplate='+@idtemplate+'&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
Parameter Description Compulsory / Optional
class=email Class requested: Class to which the request is made Compulsory
method=sendemailtogroupfromtemplate 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
idgroup Identifier of the destination group Compulsory
idtemplate email.sendemailtogroupfromtemplate_idtemplate Compulsory
scheduledatetime Delivery date and time in yyyy-mm-dd hh:mm:ss format Optional
output Output format of the result Optional
Answer:
  • status
  • result (if status=success), here you will receive the following values:
    • id
    • count
    • credits
    • destinations
      • messageid
      • destination
  • error (if status=error), here you will receive the error code

Error codes:
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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group
NO_CREDITS Your balance is insufficient

Get email delivery status with SQL Server

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
DECLARE @class varchar(500) = 'email';
DECLARE @method varchar(500) = 'getdeliverystatus';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @messages varchar(500) = '123456,123457,123458';
DECLARE @output varchar(500) = '';
DECLARE @url varchar(255) = 'https://www.afilnet.com/api/http/?+'&class='+@class+'&method='+@method+'&user='+@user+'&password='+@password+'&messages='+@messages+'&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
Parameter Description Compulsory / Optional
class=email Class requested: Class to which the request is made Compulsory
method=getdeliverystatus 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
messages List of sending identifiers separated by , (commas) Compulsory
output Output format of the result Optional
Answer:
  • status
  • result (if status=success), here you will receive the following values:
    • messageid
    • sms
    • deliverydate
    • deliverystatus
  • error (if status=error), here you will receive the error code

Error codes:
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

Returns the delivery status of certified SMS with PHP Returns the delivery status of certified SMS with Java Returns the delivery status of certified SMS with C Sharp Returns the delivery status of certified SMS with Unix Returns the delivery status of certified SMS with Ruby on rails Returns the delivery status of certified SMS with Python Returns the delivery status of certified SMS with Android Returns the delivery status of certified SMS with Objective C / iPhone Returns the delivery status of certified SMS with SQL Server Returns the delivery status of certified SMS with Oracle Returns the delivery status of certified SMS with Node JS Returns the delivery status of certified SMS with Go lang Returns the delivery status of certified SMS with Scala lang Returns the delivery status of certified SMS with Swift Returns the delivery status of certified SMS with Delphi

Afilnet offers you methods to improve security when using our API with SQL Server, thanks to the possibility of creating accesses and the possibility of activating filtering by IP.

Which API for SQL Server should I use?

Discover the advantages and disadvantages of each of our APIs. Find out which API is best for your Software in SQL Server.

This API allows you to connect to us from SQL Server to send requests via HTTP GET requests. This request sends the parameters in the same URL as the request.

  • HTTP GET is extremely simple to implement
  • Information is sent unencrypted (passwords could be extracted from logs or cache)
  • Maximum request of ~4000 characters

The POST request API allows you to connect to our API from SQL Server by sending request parameters via HTTP POST parameters. The information is sent independently of the URL.

  • HTTP POST is simple to implement
  • Information is sent encrypted
  • There is no limit on the size of the request
  • Medium security

The basic authentication API allows the use of GET and POST requests in SQL Server with an additional security layer, since in this case the username and password are sent in the header of the request.

  • Basic authentication is easy to implement
  • Access data is sent encrypted
  • The size limit depends on the use of GET or POST
  • Medium security

SOAP allows you to send requests in XML format with SQL Server, SOAP adds an extra layer of security to API requests.

  • SOAP integration is more complex
  • Information is sent encrypted
  • There is no limit on the size of the request
  • Medium / High security

Our JSON API allows you to send requests in JSON format with SQL Server, in addition this API adds the oAuth 2.0 protocol in the authentication that allows you to add an additional layer of security.

  • JSON oAuth 2.0 integration is more complex
  • Information is sent encrypted
  • There is no limit on the size of the request
  • High security

Connect SQL Server with our EMAIL API

Our Email API allows you to easily, quickly and efficiently. The process you need to follow to be able to use our API will only take a few minutes. Our company will offer you a free trial so that you can test the service.

01

Register as a client

In order to have access to the API you must be an Afilnet client. Registration will take a few minutes.

02

Request your free trial

Our company will offer you trial balance that will allow you to test with the API you need.

03

Integrate the API

Perform API integration using the programming language of your choice. If you have any questions or suggestions about the API, contact us

04

Welcome to Afilnet!

Everything ready!, has managed to improve its communications with Afilnet. We are here to support our API when you need it


Contact our team with any questions through the contact methods that we offer. Our team will try to offer you an immediate solution and will help you in the integration of our API in your Software.

Try Afilnet for free!

Sign up for free and try Afilnet! We offer you a free trial of our services. *



(*) Promotion only valid for companies that have never used the Afilnet service before. When requesting the free balance, Afilnet may request to verify your company information

Bulk SMS · Email Marketing · Social network · Instant messaging · Certification · and much more
Continue 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.
Afilnet
Follow us
Payment methods
Wire transfer
Credit card
Paypal
Western Union
Skrill
Crypto
Afilnet in your language

Copyright © 2025 Afilnet · All rights reserved