multi sales order input from a Portal to an orchestration
Hi Experts,
I need to integrate an external portal, with JDE, using Orchestrator Studio 6.1. The portal is used to create sales order and once a day, it exposes the JSON. Once a day with orchestrator I need to make a GET request to this portal and import all the orders. The responseJSON is structured in this way (in this case we have two orders with 2 lines each:
{
"AN8": "4741",
"SHAN": "4741",
"GridData": [
{
"LITM": "I1001003X4800H",
"SOQS": "3",
},
{
"LITM": "I1001003X4800H",
"SOQS": "2",
}
]
},
{
"AN8": "4741",
"SHAN": "4741",
"GridData": [
{
"LITM": "I10020045",
"SOQS": "3",
},
{
"LITM": "I10020045",
"SOQS": "2",
}
]
}
My problem is that I can only import the first order. I tried to iterate over an array, but I have already an array "GridData" for multiple lines order and I cannot create an Array that contains another array variable. Supposing that I can change the JSON output of the portal, do you have some suggestions, to let me import all the orders?