Skip to Main Content

APEX

Announcement

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!

Possible to display a JSON structure

Paul JorstadDec 23 2020

Hello, I have a ORDS endpoint which returns a JSON structure, let's say DEPT records with EMP records for each DEPT. Is it possible to show this structure in APEX?
When I create a web source for my ORDS endpoint it seems that only the "first" level, I.E. DEPT are detected. But I would like to fetch the EMP records as well. But not sure if that is possible...
Often, a JSON response is like a structure, and it would be really nice to show that structure (like a tree?) in APEX.
I have Ords 20.3 and Apex 20.2

Comments
Post Details
Added on Dec 23 2020
2 comments
525 views