How to create a nested JSON output using data requests and iterate over
E1 9.2.5.4 E920
Goal: select all items a customer purchased for each item list all serial numbers
DataRequest1: input customer code; retrieve all items, their description and manufacturer; Data Set Variable Name = Items
DataRequest2: input item; retrieve all serial numbers and warehouse code
Orchestration1: input item; call DataRequest2; return all grid rows
Connector to Orchestration1
Orchestration2: input customer code; call DataRequest1; call Connector; iterate over Items ; return all grid rows
End result is all the items from DataRequest1, followed by all the serial numbers for all the items
What I want is
Item1
Description1
Serial1
Serial2
Item2
Description2
Serial3
Serial4
What I get is