Using ORDS to generate the JSON. The file is generated with tags in lowercase instead of upperc

User_KYPIT

Using ORDS to generate the JSON. The file is generated with tags in lowercase instead of uppercase or initcap as provided in SQL query

thatJeffSmith-Oracle

ORDS will always generate lowercase attributes. If you want to enforce case, you'll need to generate the JSON in your handler block and return that, and tell ORDS you're dealing with JSON so it doesn't try to turn your JSON...into JSON.

User_KYPIT

Can you please try to give some example.

thatJeffSmith-Oracle

https://www.thatjeffsmith.com/archive/2017/09/ords-returning-raw-json/

https://www.thatjeffsmith.com/archive/2022/02/hierarchical-json-with-stew-ashton-ords-rest-apis/

Olafur T

Also,

Try creating a single item GET service with

select json_arrayagg(json_object('TYPE' :object_type, 'NAME' :object_name, 'STATUS' :status)) as "{}items"
  from all_objects o
where owner = 'ORDS_METADATA'
fetch next 20 rows only