OTP with SQL Server

Generate an OTP Token (One Time Password) with SQL Server

SQL Server : API DOCUMENTATION



OTP with SQL Server

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) = 'otp';
DECLARE @method varchar(500) = 'generateotp';
DECLARE @user varchar(500) = 'user';
DECLARE @password varchar(500) = 'password';
DECLARE @type varchar(500) = 'number';
DECLARE @destination varchar(500) = '34600000000';
DECLARE @time varchar(500) = '1';
DECLARE @timetype varchar(500) = 'days';
DECLARE @length varchar(500) = '6';
DECLARE @otpformat varchar(500) = 'all';
DECLARE @output varchar(500) = '';
DECLARE @url varchar(255) = 'https://www.afilnet.com/api/http/?class='+@class+'&method='+@method+'&user='+@user+'&password='+@password+'&type='+@type+'&destination='+@destination+'&time='+@time+'&timetype='+@timetype+'&length='+@length+'&otpformat='+@otpformat+'&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 Delphi



Method details

Parameter Description Compulsory / Optional
class=otp Class requested: Class to which the request is made Compulsory
method=generateotp 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
type Type of group (email or mobile) Compulsory
destination Mobile number or destination email Compulsory
time Number of days, weeks, months or years Optional
timetype Type of time (Posible value: minutes, hours, days, weeks, months o years) Optional
length Length of the password to generate Optional
otpformat Format of the password to generate, if it includes all the characters, only numbers or only letters (all, numbers, letters) 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:
    • No additional values will be sent to you
  • 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
INCORRECT_TIME_TYPE Incorrect type of time (possible values: minutes, hours, days, weeks, months or years)
INCORRECT_TYPE Incorrect type. The type must be mobile or email
INCORRECT_FORMAT ERROR_INCORRECT_FORMAT
INCORRECT_OTP_FORMAT ERROR_INCORRECT_OTP_FORMAT
Parameters:
  • class : otp
  • method : generateotp
  • user : user
  • password : password
  • type : number
  • destination : 34600000000
  • time : 1
  • timetype : days
  • length : 6
  • otpformat : all
  • output :

Request:
https://www.afilnet.com/api/http/?class=otp&method=generateotp&user=user&password=password&type=number&destination=34600000000&time=1&timetype=days&length=6&otpformat=all&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