Delete contact from a group with Oracle

Delete a contact of a group with Oracle


Example in Oracle:

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;



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


Removes a contact from the group


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

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
NOT_ACCESS_TO_GROUP You are not allowed into the indicated group
Parameters:
  • class: group
  • method: deletecontact
  • user: user
  • password: password
  • idgroup: 1000
  • idcontact: 1000
Request:
https://www.afilnet.com/api/http/?class=group&method=deletecontact&user=user&password=password&idgroup=1000&idcontact=1000
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