append array of json will mapping in select action

[omargohar]

Hi all.

we have array of object like 

[

{

"Qty": "225",

"_id": "659921c7d8df6256c4365004",

"item": "6599221f4069ad0deeffc462"

},

{

"Qty": "2100",

"_id": "659921c7d8df6256c4365004",

"item": "6599221f4069ad0deeffc461"

}

]

I need to map this array in select action like below mapping.

{

    "to": "_id",

    "variants":

                  [

                     { 

                        "variant": "Item", 

                        "Qty": "Qty"

                    }

                ],

  }

please if you have any idea share it with me thanks.

[Chriddle]

Needs 2 Selects 😉

Data (Compose)

[
{
"Qty": "225",
"_id": "659921c7d8df6256c4365004",
"item": "6599221f4069ad0deeffc462"
},
{
"Qty": "2100",
"_id": "659921c7d8df6256c4365004",
"item": "6599221f4069ad0deeffc461"
}
]

DataEnhanced (Select)

From

outputs('Data')

Map

addProperty(
	item(),
	'variantsString',
	concat(
		'{"variant":"', item()['item'], '","Qty":"', item()['Qty'], '"}'
	)
)

Select

From

union(
	xpath(
		xml(json(concat('{"Root":{"Item":', body('DataEnhanced'),'}}'))),
		'//_id/text()'
	),
	json('[]')
)

Map to

item()

Map variants

json(
	concat(
		'[',
		join(
			xpath(
				xml(json(concat('{"Root":{"Item":', body('DataEnhanced'),'}}'))),
				concat('//Item[_id="', item(), '"]/variantsString/text()')
			),
			','
		),
		']'
	)
)

Result

[
  {
    "to": "659921c7d8df6256c4365004",
    "variants": [
      {
        "variant": "6599221f4069ad0deeffc462",
        "Qty": "225"
      },
      {
        "variant": "6599221f4069ad0deeffc461",
        "Qty": "2100"
      }
    ]
  }
]

[SamLed]

Hi @omargohar,

You can do it this way, I added 2 objects with different ID to the test dataset you gave:

1. Select IDs

2. For each id, filter data matching current id :

Apply to each from: union(body('Select_ID'),body('Select_ID')) (union ensure we get unique IDs)

Filter:

From: outputs('Data')

Right condition operand: items('Apply_to_each')?['_id']

3. Select and rename other object properties:

From: body('Filter_array')

Qty: item()?['Qty']

Variant: item()?['item']

4. Rebuild object

to: items('Apply_to_each')?['_id']

variants: body('Select')

5. Finally, get array from apply to each:

Results:

Overall flow view:

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[SamLed]

Hi @Chriddle,

Lol, you posted a few seconds before me, I like your design, can you improve it to deal with many different IDs without loop ? 

Best regards,

Sam

[SamLed]

Hi @Chriddle, @omargohar,

@Chriddle: forget my previous question, it works with many IDs

@omargohar: Take @Chriddle solution it is far the best one 😉

Regards,

Sam

[Chriddle]

@SamLed This is already included 😉

[SamLed]

@Chriddle  Yes, saw that, I tried giving a solution like yours, but failed due to my XPath low knowledges, you gave me the hints I lacked.  Many thanks 😉