declare
  l_ws_response_clob CLOB;
  l_ws_url VARCHAR2(500) := 'https://YourURL';
  l_list json_list;
  l_col1 VARCHAR2(100);
  l_col2 VARCHAR2(100);
  l_col3 VARCHAR2(100);
  l_col4 VARCHAR2(100);

begin
  --get JSON
  apex_web_service.g_request_headers(1).name := 'Accept';
  apex_web_service.g_request_headers(1).value := 'application/json; charset=utf-8';
  apex_web_service.g_request_headers(2).name := 'Content-Type';
  apex_web_service.g_request_headers(2).value := 'application/json; charset=utf-8';
  l_ws_response_clob := apex_web_service.make_rest_request(
  p_url => l_ws_url,
 p_http_method => 'GET'
  );
  --dbms_output.put_line(dbms_lob.substr(l_ws_response_clob,24000,1));
  --dbms_output.put_line(dbms_lob.substr(l_ws_response_clob,24001,24000));

  --convert clob to json_list
  l_list := json_list(l_ws_response_clob);
  for i in 1..l_list.count LOOP
    l_col1   := json_ext.get_string(json(l_list.get(i)),'attributes.Name');
    l_col2   := json_ext.get_string(json(l_list.get(i)),'attributes.Status');
    l_col3   := json_ext.get_string(json(l_list.get(i)),'attributes.Manufacturer');
    l_col4   := json_ext.get_string(json(l_list.get(i)),'attributes.Model');

  INSERT INTO PRINTER_INFO(RECORD_NUM,Name,Status,Manufacturer,Model) VALUES (i,l_col1,l_col2,l_col3,l_col4);
  end loop;
end;