Create group with Oracle

Create a group of contacts with Oracle

Oracle : API DOCUMENTATION



Create group with Oracle

Example in 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;



See example in:

PHP Java C Sharp Unix Ruby on rails Python Android Objective C / iPhone SQL Server Oracle Node JS Go lang Scala lang Swift Delphi



Method details

Parameter Description Compulsory / Optional
class=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

When you make requests you will receive the following fields:


  •  status
  •   result (if status=success), here you will receive the following values:
    • No additional values will be sent to you
  • error (if status=error), here you will receive the error code

The possible error codes are listed below


Code Description
MISSING_USER User or email not included
MISSING_PASSWORD Password not included
MISSING_CLASS Class not included
MISSING_METHOD Method not included
MISSING_COMPULSORY_PARAM Compulsory parameter not included
INCORRECT_USER_PASSWORD Incorrect user or password
INCORRECT_CLASS Incorrect class
INCORRECT_METHOD Incorrect method
INCORRECT_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)
Parameters:
  • class : group
  • method : creategroup
  • user : user
  • password : password
  • name : test name
  • type : mobile
  • fields : mobile,name,address

Request:
https://www.afilnet.com/api/http/?class=group&method=creategroup&user=user&password=password&name=test name&type=mobile&fields=mobile,name,address

IMPORTANT INFORMATION ABOUT COOKIES: If you continue to use this web we will assume that you accept the terms of use. You will find more information in our Cookies Policy. Continue