Reseller API for Oracle

Manage your reseller account with our API for Oracle easily and securely. Try our API for Oracle for free. Our team will help you manage the clients of your reseller account in Oracle.

API functionality to Resellers

Add a subaccount with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=subaccount'||'&'||'method=addsubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;
Parameter Description Compulsory / Optional
class=subaccount Class requested: Class to which the request is made Compulsory
method=addsubaccount 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
accountemail Account email Compulsory
accountpassword Account password Compulsory
namelastname Name and surname of the contact person Compulsory
iscompany (0) If it is a natural person or (1) if it is a company Compulsory
companyname Name of the company (in case it is a company) Optional
documentid Company identification document code Compulsory
language Language of the subaccount. See attached table Compulsory
countrycode ISO country code in ISO-3166-1 ALPHA-2 format Compulsory
cityid City identifier Compulsory
cityname Name of the city or town to which it belongs Compulsory
zipcode Postal Code Compulsory
address Physical address Compulsory
Answer:
  • 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

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
EMPTY_COUNTRYCODE The country code is empty
EMPTY_FIELDS Some mandatory field is empty
COUNTRY_NOT_FOUND There is no country with the indicated code
EMPTY_CITY You have not indicated the city
CITY_NOT_FOUND The indicated city does not exist
INCORRECT_EMAIL The email included is not valid
INCORRECT_PASSWORD The password included is not valid
RESELLER_ACCOUNT_REQUIRED The user's account does not have the reseller plan active

Modify a subaccount with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=subaccount'||'&'||'method=addsubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=modifysubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'modifypassword=1'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;
Parameter Description Compulsory / Optional
class=subaccount Class requested: Class to which the request is made Compulsory
method=modifysubaccount 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
accountemail Account email Compulsory
modifypassword Compulsory
accountpassword Account password Optional
namelastname Name and surname of the contact person Compulsory
iscompany (0) If it is a natural person or (1) if it is a company Compulsory
companyname Name of the company (in case it is a company) Optional
documentid Company identification document code Compulsory
language Language of the subaccount. See attached table Compulsory
countrycode ISO country code in ISO-3166-1 ALPHA-2 format Compulsory
cityid City identifier Compulsory
cityname Name of the city or town to which it belongs Compulsory
zipcode Postal Code Compulsory
address Physical address Compulsory
Answer:
  • 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

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
EMPTY_COUNTRYCODE The country code is empty
EMPTY_FIELDS Some mandatory field is empty
COUNTRY_NOT_FOUND There is no country with the indicated code
EMPTY_CITY You have not indicated the city
CITY_NOT_FOUND The indicated city does not exist
INCORRECT_EMAIL The email included is not valid
INCORRECT_PASSWORD The password included is not valid
ACCOUNT_NOT_FOUND User account has not been found

Get list of subaccounts with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=subaccount'||'&'||'method=addsubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=modifysubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'modifypassword=1'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=getsubaccounts'||'&'||'user=user'||'&'||'password=password';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;
Parameter Description Compulsory / Optional
class=subaccount Class requested: Class to which the request is made Compulsory
method=getsubaccounts 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
Answer:
  • 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

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

Delete a subaccount with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=subaccount'||'&'||'method=addsubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=modifysubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'modifypassword=1'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=getsubaccounts'||'&'||'user=user'||'&'||'password=password';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=deletesubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;
Parameter Description Compulsory / Optional
class=subaccount Class requested: Class to which the request is made Compulsory
method=deletesubaccount 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
accountemail Account email Compulsory
Answer:
  • 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

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
ACCOUNT_NOT_FOUND User account has not been found

Transfer balance to a subaccount with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=subaccount'||'&'||'method=addsubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=modifysubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'modifypassword=1'||'&'||'accountpassword=password'||'&'||'namelastname=name+lastname'||'&'||'iscompany=1'||'&'||'companyname=mycompany'||'&'||'documentid=123456789A'||'&'||'language=en'||'&'||'countrycode=us'||'&'||'cityid=1'||'&'||'cityname=town'||'&'||'zipcode=123456'||'&'||'address=address';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=getsubaccounts'||'&'||'user=user'||'&'||'password=password';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=deletesubaccount'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?'||'&'||'class=subaccount'||'&'||'method=transferbalance'||'&'||'user=user'||'&'||'password=password'||'&'||'accountemail=email@email.com'||'&'||'balancetotransfer=10';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
begin     
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
    
	begin
		loop
			utl_http.read_text(l_resp, l_text, 32766);
			dbms_output.put_line(l_text);
		end loop;                
	exception
		when utl_http.end_of_body then
			utl_http.end_response(l_resp);
		end;
end;
Parameter Description Compulsory / Optional
class=subaccount Class requested: Class to which the request is made Compulsory
method=transferbalance 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
accountemail Account email Compulsory
balancetotransfer Indicates the balance to be transferred to the subaccount, a negative value can be used to subtract the balance from the subaccount. Compulsory
Answer:
  • 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

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
ACCOUNT_NOT_FOUND User account has not been found
NOT_ENOUGH_BALANCE ERROR_NOT_ENOUGH_BALANCE
INCORRECT_MIN_BALANCE ERROR_INCORRECT_MIN_BALANCE

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 Oracle, thanks to the possibility of creating accesses and the possibility of activating filtering by IP.

Which API for Oracle should I use?

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

This API allows you to connect to us from Oracle 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 Oracle 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 Oracle 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 Oracle, 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 Oracle, 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 Oracle with our Subaccounts API

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 © 2024 Afilnet · All rights reserved