Convert multiple json objects into json array by key value

(0) Share

Report

Posted on by Rosie

295

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Rosie 295 on at

Like (0)

Report
Copy link

Link copied!

Hello @SudeepGhatakNZ,

Thanks for your suggestion.

I did get an error with that suggestion.

"The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(item(items('For_each_3')['Key']),item()['Sales-Order'])' failed: 'The template language function 'item' must not have any parameters.'."

I added in a compose to the foreach to convert the key value to an int value, then used that in the

Which resulted in this output.

Then used the output of the Compose GetKeyValue

That seemed to work.

Strangely the Filter Array Output shows "No Outputs", but if I click on "Show raw outputs" I get the filtered json.

My next stage is working out how to collect the Shipping marks, product, # packs to generate an array within a single json object for the sales-order.

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

In your Filter array, do this

Was this reply helpful? Yes No