Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Parse Nested JSON in Oracle Apex

Hi All,
I need to parse a dynamic JSON in Apex . I have to include checkboxes in the nested Json so that the user can select some child nodes and they have to be stored back again in DB.
Eg,.
Sample Json below, (the json nodes may different)
{"Description": "Sample", "Item": "SampleItem", "Samples": "XXX", "Number": {"ItemA (s)": {"ValA": 2, "ValB": 1}, "ItemB (s)": {"ValA": 3, "ValB": 1}}, "SampleRun": ["RunA (s)", "RunB (s)"]}
I have to include checkboxes in all the nodes that ends with (s) and when user selects I have to store the value with the node details in DB table.
Either I can add checkbox while rendering Json in Apex enabling user to select checkbox and store the value back to DB
Or I can parse the Json data, create a table with key value details along with path and later construct a region with checkbox in required places.
Not sure if my approaches are right. Please assist me further.