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!

APEX 24.1.0 REST Data Source - Nested JSON Discovery unexpected result

HoekDec 1 2024

Inspired by this great article APEX 24.1: REST Data Sources and nested JSON responses
and since we've recently upgraded to APEX 24.1 I am exploring this new area, because we can clearly benefit from this powerful feature.

However, based on the REST response I used as input for my REST Data Source, the resulting Data Profile doesn't contain any arrays and a lot of columns were omitted.
Is this expected behaviour given my input json (response3.txt) or am I missing something?

response3.txt

The resulting Data Profile:



Based on viewing the json response in a json (tree) viewer I would have expected a different result (nested arrays).
Or do I need to make manual adjustments?

All ideas/tips/pointers/etc are welcome and highly appreciated!

TIA, regards,
Hoek

This post has been answered by Carsten Czarski-Oracle on Dec 2 2024
Jump to Answer
Comments
Post Details
Added on Dec 1 2024
2 comments
291 views