Integration Technologies - JDE1 (MOSC)

MOSC Banner

E1 Orchestration - How to create nested multi node JSON

edited Apr 23, 2024 2:48PM in Integration Technologies - JDE1 (MOSC) 5 commentsAnswered

I have a requirement to create JSON payload with multi-level/nested segments as follows. I was able to get Header and Detail nodes with two headless-detail forms but limited to two levels only. Please suggest if/how it is possible to generate such structure.

{
"Transaction": {
"Header": {
"TransactionID": "ProcOrder",
"TransactionRefID": "1CA9A176ECFB",
"SourceSiteID": "Denver",
"SourceSystem": "JDE"
},
"Detail": {
"Plant": "Aurora",
"Order": 101401,
"Product": 2323,
"RecipeID": "",
"BatchQuantity": 2700,
"BatchUOM": "EA",
"Items": [
{
"LineNo": 10,
"Item": 303,
"TotQuantity": 1.2,
"UOM": "KG",
"Allocation": {
"Lot": 20161000,
"Quantity": 1.2
}
},
{
"LineNo": 20,
"Item": 304,
"TotQuantity": 4.8,
"UOM": "KG",
"Allocation": [
{
"Lot": 20161000,
"Quantity": 4
},
{
"Lot": 201610012,
"Quantity": 0.8
}
]
}
]
}
}
}

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