Oracle Application Express (MOSC)

MOSC Banner

Nested Loop JSON

Oracle Apex 23.2

Hi,

I have a JSON File as below is there a way to read the data in the nested loop JSON "OrderDetail" like the "item.code" and  "item.nameEN" in the Rest Data Source, I was able to read the main data but for the data in the nested loop JSON it faild:

{

 "code": "00004093",

 "docDate": "03/05/2023",

 "approval": "Posted",

 "contact": "000100",

 "contact.name": "Customer X",

 "totalNet": "100",

 "comment": "Test",

 "orderDetail": [

  {

   "item.code": "000000100",

   "item.nameEN": "Item X"

  },

  {

   "item.code": "000000205",

   "item.nameEN": "Item Y"

  },

  {

   "item.code": "000000207",

   "item.nameEN": "Item Z"

  }

 ]

}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center