Invoking a RESTful Style Web Service in Oracle APEX

The response can be an XML or text such as a comma separated response or JSON. The following is an example of MAKE_REST_REQUEST being used in an application process that is callable by AJAX.

Code:

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 => 'https://api.covid19india.org/v2/state_district_wise.json',

              p_http_method => 'GET');

    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;

That's it. Happy APEXing!!!...