Contacts API

Manage your groups (create, modify or delete groups) and contacts with our API for contacts.

Create group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group Class requested: Class to which the request is made Compulsory
method=creategroup 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
name Name of the group Compulsory
type Type of group (email or mobile) Compulsory
fields List of fields separated by commas. It's compulsory to include a mobile field if type=mobile and an email field if type = 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
INCORRECT_TYPE Incorrect type. The type must be mobile or email
MISSING_MAIN_FIELD Main field missing (mobile if type = mobile or email if type = email)

Get field of a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group Class requested: Class to which the request is made Compulsory
method=getgroupcolumns 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 Group ID 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Add field to a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group Class requested: Class to which the request is made Compulsory
method=addcolumntogroup 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 Group ID Compulsory
field Group field 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Delete field from a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group Class requested: Class to which the request is made Compulsory
method=deletecolumnfromgroup 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 Group ID Compulsory
field Group field 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Delete a contact from a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group Class requested: Class to which the request is made Compulsory
method=deletegroup 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 Group ID 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Assign country to a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group Class requested: Class to which the request is made Compulsory
method=assigncountrytogroup 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 Group ID Compulsory
countryiso3 Country ISO code 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group
COUNTRY_NOT_FOUND There is no country with the indicated code

Get group contacts with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group'||'&'||'method=getcontacts'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group Class requested: Class to which the request is made Compulsory
method=getcontacts 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 Group ID 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Get a contact from a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group'||'&'||'method=getcontacts'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=getcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000';
	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=group Class requested: Class to which the request is made Compulsory
method=getcontact 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 group id Compulsory
idcontact Contact ID 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group
NOT_ACCESS_TO_CONTACT ERROR_NOT_ACCESS_TO_CONTACT

Add a contact to a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group'||'&'||'method=getcontacts'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=getcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000';
	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=group'||'&'||'method=addcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contact=mobile:123456789,name:testname';
	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=group Class requested: Class to which the request is made Compulsory
method=addcontact 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 Group ID Compulsory
contact Contact to be added with its fields separated by commas, see example 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
CONTACT_EXISTS The contact already exists in the group
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Add a contact list to a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group'||'&'||'method=getcontacts'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=getcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000';
	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=group'||'&'||'method=addcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contact=mobile:123456789,name:testname';
	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=group'||'&'||'method=addcontactlist'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contacts=[{"name":"Test","mobile":"34600000000"},{"name":"Test","mobile":"34600000001"}]';
	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=group Class requested: Class to which the request is made Compulsory
method=addcontactlist 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 group id Compulsory
contacts Contact list in JSON format 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Modify contact of a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group'||'&'||'method=getcontacts'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=getcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000';
	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=group'||'&'||'method=addcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contact=mobile:123456789,name:testname';
	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=group'||'&'||'method=addcontactlist'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contacts=[{"name":"Test","mobile":"34600000000"},{"name":"Test","mobile":"34600000001"}]';
	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=group'||'&'||'method=modifycontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000'||'&'||'contact=mobile:123456789,name:testname';
	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=group Class requested: Class to which the request is made Compulsory
method=modifycontact 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 Group ID Compulsory
idcontact Contact ID Compulsory
contact Contact to be added with its fields separated by commas, see example 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

Delete contact from a group with Oracle

declare 
	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=group'||'&'||'method=creategroup'||'&'||'user=user'||'&'||'password=password'||'&'||'name=test name'||'&'||'type=mobile'||'&'||'fields=mobile,name,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=group'||'&'||'method=getgroupcolumns'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=addcolumntogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletecolumnfromgroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'field=name';
	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=group'||'&'||'method=deletegroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=assigncountrytogroup'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'countryiso3=esp';
	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=group'||'&'||'method=getcontacts'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000';
	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=group'||'&'||'method=getcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000';
	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=group'||'&'||'method=addcontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contact=mobile:123456789,name:testname';
	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=group'||'&'||'method=addcontactlist'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'contacts=[{"name":"Test","mobile":"34600000000"},{"name":"Test","mobile":"34600000001"}]';
	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=group'||'&'||'method=modifycontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000'||'&'||'contact=mobile:123456789,name:testname';
	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=group'||'&'||'method=deletecontact'||'&'||'user=user'||'&'||'password=password'||'&'||'idgroup=1000'||'&'||'idcontact=1000';
	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=group Class requested: Class to which the request is made Compulsory
method=deletecontact 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 Group ID Compulsory
idcontact Contact ID 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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group

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