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!
Did the free workspace from apex.oracle.com stop working? I click the free workspace link and it says not available. Is the only option to use the autonomous database?
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