You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

REST API data to staging table

Accepted answer
11
Views
7
Comments
edited Dec 9, 2021 6:51PM in HCM REST APIs 7 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!