59.1.2 Invoking a RESTful-style Web Service
RESTful-style Web services use a simpler architecture than SOAP. Often the input to a RESTful-style Web service is a collection of name/value pairs. The response can be an XML document or simply text such as a comma-separated response or JSON.
Example
The following is an example of MAKE_REST_REQUEST in an application process that is callable by Ajax.
DECLARE
l_clob clob;
l_buffer varchar2(32767);
l_amount number;
l_offset number;
BEGIN
l_clob := apex_web_service.make_rest_request(
p_url => 'http://us.music.yahooapis.com/ video/v1/list/published/popular',
p_http_method => 'GET',
p_parm_name => apex_util.string_to_table('appid:format'),
p_parm_value => apex_util.string_to_table(apex_application.g_x01||':'||apex_application.g_x02));
l_amount := 32000;
l_offset := 1;
BEGIN
LOOP
dbms_lob.read( l_clob, l_amount, l_offset, l_buffer );
htp.p(l_buffer);
l_offset := l_offset + l_amount;
l_amount := 32000;
END LOOP;
EXCEPTION
WHEN no_data_found THEN
NULL;
END;
END;
Parent topic: About the APEX_WEB_SERVICE API