Hi there,
I am trying to get json_value in a loop, but it is giving me an error.. here is my code. What am I doing wrong?
declare
jsondata CLOB;
URL_string clob;
bio_id varchar2(100);
fullname varchar2(100);
party varchar2(100);
statename varchar2(100);
i number;
begin
URL_string := 'https://api.congress.gov/v3/member/congress/118?offset=0&limit=20&format=json&api_key=mykey';
jsondata := APEX_WEB_SERVICE.MAKE_REST_REQUEST(
p_url => URL_string,
p_http_method => 'GET'
);
for i in 0..20 Loop
select json_value(jsondata, '$.members['|| i ||'].bioguideId') , json_value(jsondata, '$.members['|| i ||'].name') into bio_id,fullname from dual;
dbms_output.put_line('BioID: '||bio_id);
dbms_output.put_line('Name: '||fullname);
end loop;
end;