JSON array syntax for orchestrations/data requests
I have used a data request to create an array to then iterate over in subsequent data requests which works wonderfully. I now need to generate the same type of array as input for an orchestration so that it will iterate through the list running a second orchestration.
A single run with the following JSON input works beautifully:
{
"inputs" : [ {
"name" : "EDIDoc",
"value" : "104681"
}, {
"name" : "EDIType",
"value" : "OZ"
}, {
"name" : "POLine",
"value" : "2"
}, {
"name" : "POItem",
"value" : "220"
}, {
"name" : "PORcpt",
"value" : "12/26/19"
}, {
"name" : "POQty",
"value" : "1"
}, {
"name" : "POCost",
"value" : "527.8817"
} ]
}
How should I format multiple sets of the above 7 data items so that my orchestration will recognize it as a data set called Ack_List? I have tried several variations and all were validated by the Orchestrator Client. I also checked using 3rd party JSON validators and came up clean there as well. No variation used to date will iterate in an orchestration to provide the desired results. Orchestration 1 needs to receive Ack_List as input and run Orchestration 2 for each set of 7 variables illustrated above. Orchestration 2 works perfectly over one set at a time. There could