REST API data to staging table

Hi,

I am able to GET the response from REST API call using the below code

declare

v_response clob;

v_buffer varchar2(32767);

v_buffer_size number := 32000;

v_offset number := 1;

begin

-- Set connection and invoke REST API.

v_response := apex_web_service.make_rest_request(

p_url => 'https://abc-dev1.fa.emx.oraclecloud.com/hcmRestApi/resources/11.13.18.05/majorsLOV?q=LookupType=BLOOD_TYPE',

p_http_method => 'GET',

p_username => '****@gmail.com',

p_password => '[email protected]'

--p_body => '{"LookupType":"BLOOD_TYPE"}'

);

-- Get response.

begin

loop

dbms_lob.read(v_response, v_buffer_size, v_offset, v_buffer);

-- Do something with buffer.