For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Using ORDS to generate the JSON. The file is generated with tags in lowercase instead of uppercase or initcap as provided in SQL query
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.
Can you please try to give some example.
ORDS: How to Return RAW JSON Content for Your REST APIs (0 Bytes) Hierarchical JSON with Stew Ashton & ORDS REST APIs (0 Bytes)
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