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!

How to Parse a JSON Object in Oracle APEX v5.1 that is Stored within an Array

Tony FatourosJun 21 2017 — edited Jun 26 2017

Hi,

I have the following sample JSON Object array, i.e.:

[
{
"type": "Campaign",
"currentStatus": "Active",
"id": "206",
"depth": "complete",
"folderId": "1428",
"name": "Car Loan",
"isReadOnly": "false"
},
{
"type": "Debate",
"currentStatus": "Active",
"id": "207",
"depth": "pending",
"folderId": "1429",
"name": "House Loan",
"isReadOnly": "true"
}
]

Based on the above, I am unsure how to iterate through each of these JSON objects, inside this array?

For each object, I then need to produce a report showing all columns for these two JSON object records.

I've looked at apex_json.get_count but unsure how to apply to this JSON array.

Any help would be much appreciated.

Thanks.

Tony.

This post has been answered by Kiran Pawar on Jun 22 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2017
Added on Jun 21 2017
4 comments
2,219 views