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