Hello,
I am receiving a json file that has multiple objects. Each object has a sales-order number, there can be multiple objects with the same sales-order, I want to produce one json file per sales-order.
I have been able to produce the unique sales-order numbers, and now I am trying to filter the incoming json by the sales-order.
The next step would be creating an array within the new json file - one step at a time.
I am using compose to get the sales-order and made it so I get one of each value:
This uses the expression: union(body('Select_KeyValuePair'),body('Select_KeyValuePair'))
When I filter on the output of Compose MakeUnique I get no output.
I have tried various options in the value field, but even the sales-order vale 393195 still returns no output.
From: body('ParseNPIJSON')
Filter Query: item()['Sales-Order']
The original json is in the following format:
I would like to turn it into this format:
This is my flow so far
Thanks
Rosie
