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"
}
]
}