WhatsAPP Business API for Oracle

Send WhatsAPP messages with our API for Oracle easily and securely. Try our API for Oracle for free. Our team will help you to integrate the automated sending of WhatsAPP in your application in Oracle.

WhatsAPP Business API functionality

Send a message by WhatsAPP with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=whatsapp'||'&'||'method=sendmessage'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'message=test+message';
	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=whatsapp Class requested: Class to which the request is made Compulsory
method=sendmessage 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
platformid Platform identifier Compulsory
destination whatsapp.sendmessage_destination Compulsory
message whatsapp.sendmessage_message 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
CHANNEL_NOT_FOUND The indicated channel does not exist

Send a file by WhatsAPP with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=whatsapp'||'&'||'method=sendmessage'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendfile'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'type=image'||'&'||'fileurl=https://www.example.com/image.jpg'||'&'||'thumburl=https://www.example.com/thumb.jpg'||'&'||'message=test+message';
	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=whatsapp Class requested: Class to which the request is made Compulsory
method=sendfile 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
platformid Platform identifier Compulsory
destination whatsapp.sendfile_destination Compulsory
type whatsapp.sendfile_type Compulsory
fileurl whatsapp.sendfile_fileurl Compulsory
thumburl whatsapp.sendfile_thumburl Optional
message whatsapp.sendfile_message Optional
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
CHANNEL_NOT_FOUND The indicated channel does not exist
CHAT_NOT_FOUND The indicated chat does not exist
INCORRECT_FILETYPE The file type is wrong, check the possible values
INCORRECT_FILEURL The file url is not valid
INCORRECT_THUMBURL The url of the thumbnail is invalid

Send a template message via WhatsAPP with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=whatsapp'||'&'||'method=sendmessage'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendfile'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'type=image'||'&'||'fileurl=https://www.example.com/image.jpg'||'&'||'thumburl=https://www.example.com/thumb.jpg'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendmessagefromtemplate'||'&'||'user=user'||'&'||'password=password'||'&'||'idtemplate=100'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'options={\"header\":{\"file\":\"url\"}}';
	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=whatsapp Class requested: Class to which the request is made Compulsory
method=sendmessagefromtemplate 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
idtemplate Template identifier Compulsory
platformid Platform identifier Compulsory
destination Recipient of the message (Number in international format) Compulsory
options The options allow you to parameterize and configure the message to be sent (See Annex). Optional
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
CHANNEL_NOT_FOUND The indicated channel does not exist

Get a list of WhatsAPP conversations with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=whatsapp'||'&'||'method=sendmessage'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendfile'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'type=image'||'&'||'fileurl=https://www.example.com/image.jpg'||'&'||'thumburl=https://www.example.com/thumb.jpg'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendmessagefromtemplate'||'&'||'user=user'||'&'||'password=password'||'&'||'idtemplate=100'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'options={\"header\":{\"file\":\"url\"}}';
	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=whatsapp'||'&'||'method=getchats'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100';
	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=whatsapp Class requested: Class to which the request is made Compulsory
method=getchats 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
platformid Platform identifier Compulsory
Answer:
  • status
  • result (if status=success), here you will receive the following values:
    • list
      • platformid
      • message
      • destination
      • messageid
      • sent
      • status
      • datetime
  • 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
CHANNEL_NOT_FOUND The indicated channel does not exist
CHAT_NOT_FOUND The indicated chat does not exist

Get a list of WhatsAPP messages with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=whatsapp'||'&'||'method=sendmessage'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendfile'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'type=image'||'&'||'fileurl=https://www.example.com/image.jpg'||'&'||'thumburl=https://www.example.com/thumb.jpg'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendmessagefromtemplate'||'&'||'user=user'||'&'||'password=password'||'&'||'idtemplate=100'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'options={\"header\":{\"file\":\"url\"}}';
	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=whatsapp'||'&'||'method=getchats'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100';
	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=whatsapp'||'&'||'method=getmessages'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=34600000000';
	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=whatsapp Class requested: Class to which the request is made Compulsory
method=getmessages 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
platformid Platform identifier Compulsory
destination Recipient from which you want to obtain the messages Compulsory
Answer:
  • status
  • result (if status=success), here you will receive the following values:
    • list
      • platformid
      • message
      • destination
      • messageid
      • sent
      • status
      • datetime
  • 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
CHANNEL_NOT_FOUND The indicated channel does not exist
CHAT_NOT_FOUND The indicated chat does not exist

Get a list of unread messages from a WhatsAPP chat with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=whatsapp'||'&'||'method=sendmessage'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendfile'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'type=image'||'&'||'fileurl=https://www.example.com/image.jpg'||'&'||'thumburl=https://www.example.com/thumb.jpg'||'&'||'message=test+message';
	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=whatsapp'||'&'||'method=sendmessagefromtemplate'||'&'||'user=user'||'&'||'password=password'||'&'||'idtemplate=100'||'&'||'platformid=100'||'&'||'destination=3460000000'||'&'||'options={\"header\":{\"file\":\"url\"}}';
	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=whatsapp'||'&'||'method=getchats'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100';
	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=whatsapp'||'&'||'method=getmessages'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=34600000000';
	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=whatsapp'||'&'||'method=getunreadmessages'||'&'||'user=user'||'&'||'password=password'||'&'||'platformid=100'||'&'||'destination=34600000000';
	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=whatsapp Class requested: Class to which the request is made Compulsory
method=getunreadmessages 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
platformid Platform identifier Compulsory
destination Recipient from which you want to obtain the messages Compulsory
Answer:
  • status
  • result (if status=success), here you will receive the following values:
    • list
      • platformid
      • message
      • destination
      • messageid
      • issent
      • status
      • datetime
  • 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
CHANNEL_NOT_FOUND The indicated channel does not exist
CHAT_NOT_FOUND The indicated chat does not exist

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



ANNEX: Additional options in Messages

In this annex you will learn how to send messages from your templates. WhatsAPP templates allow you to send more elaborate messages than text messages, allowing you to attach files, as well as include buttons in your messages.

Options

The options allow you to send interactive messages, attach images, videos, documents and share locations via WhatsApp. To do this, here you will learn how to customize the "options" parameter. The "options" parameter must be a string in JSON format following the following specifications:

Main parameters
header Details about the message header (optional)
params Values to the different values of the template (optional)
Example
{"header":"", "params": ""}

Define the header

Defining a header will allow you to attach different files and services to your WhatsAPP messages

Send an image
file Image URL (Allowed formats: JPG, PNG, WEBP)
The file must be uploaded to the internet and be accessible through a URL
Send a Video
file Video URL (Allowed formats: MP4, MPEG, 3GP)
The file must be uploaded to the internet and be accessible through a URL
Send a Document
file Document URL (Allowed formats: TXT, PDF, PPT, DOC, DOCX, XLS, PPTX, XLSX)
The file must be uploaded to the internet and be accessible through a URL
Send a Location
file Latitude and longitude with the format: (0.0000, 0.0000)
location
name Location name
address Location address

Define the parameters

Using parameters will allow you to customize your templates to each recipient, allowing information related to the recipient to be included in the message. Some examples of this information would be: Personal data, Data related to your account, Tracking information, etc.

JSON example: {"params":{"name":"John", "orderid": "10"}}

Valid JSON Examples

Send a message with custom parameters

In this example we are going to send a parameterized message.

Template message with parameters: Dear {{name}}, your order with ID: {{orderid}} has left our warehouses
JSON example: {"params":{"name":"John", "orderid": "10"}}

Send an image

In this example we are going to use a template that has an image as its header.

JSON example: {"header":{"file":"https:\/\/test.com\/test.jpg"}}

Send an Image and message with custom parameters

In this example we are going to use a template that has an image as its header. We attach an image with the tracking number.

Template message with parameters: Dear {{name}}, your order with ID: {{orderid}} has left our warehouses
JSON example: {"header":{"file":"https:\/\/test.com\/test.jpg"}, "params":{"name":"John", "orderid": "10"}}

Send a Video

In this example we are going to use a template that has a video as a header.

JSON example: {"header":{"file":"https:\/\/test.com\/test.mp4"}}

Send a Document

In this example we are going to use a template that has a document as a header.

JSON example: {"header":{"file":"https:\/\/test.com\/test.mp4"}}

Send a Location

In this example we are going to use a template that has a location as its header.

JSON example: {"header":{"file":"(LATITUDE, LONGITUDE)","location":{"name":"NAME","address":"ADDRESS"}}}
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 WhatsAPP Business 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.
Payment methods
Wire transfer
Credit card
Paypal
Western Union
Skrill
Crypto
Afilnet in your language

Copyright © 2024 Afilnet · All rights reserved