Merging Two Arrays of Objects With Different Properties and Same IDs

[MatheusAntunes]

Hello everyone, 

I am new to handling datasets using JSON and expressions, so I will need your help with this case. 

I need to join two arrays of objects. 

Array 1: 

[

    {

        "Article": "01",

        "Description": "Product Name 1",

        "Target Weight": "0.1"

    },

   

    {

        "Article": "02",

        "Description": "Product Name 2",

        "Target Weight": "0.15"

    },

    {

        "Article": "03",

        "Description": "Product Name 3",

        "Target Weight": "0.9"

    }

]

Array 2:

[

    {

        "Article": "01",

        "Price": "5.00"

    },

    {

        "Article": "02",

        "Price": "15.00"

    },

    {

        "Article": "03",

        "Price": "3.50"

    }

]

Expected Output:

[

    {

        "Article": "01",

        "Description": "Product Name 1",

        "Target Weight": "0.1",

        "Price": "5.00"

    },

   

    {

        "Article": "02",

        "Description": "Product Name 2",

        "Target Weight": "0.15",

        "Price": "15.00"

    },

    {

        "Article": "03",

        "Description": "Product Name 3",

        "Target Weight": "0.9",

        "Price": "3.50"

    }

]

I saw a video showing how to do with XPath, but I was wondering if it is possible to achieve that without using XPath or XML. 

[edgonzales · Accepted solution]

@MatheusAntunes 

Ok, this one is a little 'involved' - there might be a more elegant way to manage this, but this is what I came up with:

First thing I did was initialize an array variable.  (I also created two compose actions to house the sample data for array01 and array02)

I used Parse JSON on each of those to get into the details a bit easier:

Next, the fun:

Basically, I worked through each row in Array01, and filtered Array02 on the article from Array01 that I was looking at...

but this produces an array, so I added the 'first()' bit to mitigate that.  Then, for each row, I would append a new line to my array variable including the data from both arrays (essentially building a third array).  This is the final output:

Hopefully, the pictures explain it well enough.  Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[MatheusAntunes]

Thank you @edgonzales! Very well explained. 

I still had some trouble setting this up. My array 02, is not in the same order as my array 01.

When applying the filter to match each article number, the flow is creating a nested loop. Based on your screenshot, you only had to use one loop.  Considering my dataset will have about +20k rows, I am concerned about performance. 

What is that body you put for the filter?

[TimFe]

Hi @MatheusAntunes 

I ran into the same situation as you did. In case you have not figured it out yet:

You need to place the body of parsearray02 into the filter array.

This way for each Object in your 01 Array you will filter the second array so that the object or objects which have the same article number as the one selected in your for each loop will be shown. 

After this you can join them by using addProperty in a compose action before they are appened to the array variable. 

[Raphael4]

@TimFe Is there a way you could post a image of what you are suggesting? I am having the same issue but i am bot being able to replicate what you suggested.

[TimFe]

Hi @Raphael4 sure:

I have the Dev and the Test Array: which I filter and parse. 

After this I have to loop through the Dev Array in order to filter the Items from the Test Array:

So the Output of this Step are all the Objects from Dev which are included in the Test Array.

After This you can build a new Object and append it into your JSON or use addproperty to append a single item into your array:

{
"Name": @{items('Apply_to_each_3')['Name']},
"StatusDev": @{items('Apply_to_each_3')['StatusDev']},
"LinkDev": @{outputs('LinkToBase')},
"StatusTest": @{items('Apply_to_each_4')?['StatusTest']},
"LinkTest": @{outputs('LinkToTarget')}
}