My Json response is like below. I wanto create report for this data. [{"city":"Stockholm","name":"Lennart Johansson"},{"city":"London","name":"Karl Eriksson"},{"city":"Helsinki","name":"Pekka Hartikainen"},{"city":"Berlin","name":"Mia Svensson"}] My query is SELECT city, name FROM JSON_TABLE ( apex_web_service.make_rest_request(p_url => 'https://api.mocki.io/v1/b043df5a', p_http_method => 'GET'), '$' COLUMNS ( city varchar2(500) PATH '$.city', name varchar2(500) PATH '$.name' ) ) but data is not extracting. Please help
BheemProfessional
Bheem
Got the answer. Thank you
Vinish Kapoor
Below is the correct query:
Abdulkareem
Below query is working fine
SELECT city,name
FROM JSON_TABLE
('[{"city":"Stockholm","name":"Lennart Johansson"},{"city":"London","name":"Karl Eriksson"},{"city":"Helsinki","name":"Pekka Hartikainen"},{"city":"Berlin","name":"Mia Svensson"}]'
, '$[*]' columns(city path '$.city'
,name path '$.name') )