Merging two json collections in fusion

[Satya_NarayanaMu]

I'm facing one challenge while merging two JSON collections. For example collection1--> {"key1":"value1","key2":"value2"} and Collection2-->{"key3":"value3"}. I need output like {"key1":"value1","key2":"value2","key3":"value3"}. I tried by converting this object into an array and merging these but I'm getting an array of objects like [{"key1":"value1"},{"key2":"value2"},{"key3":"value3"}]. I need all the elements in a single object. Please let me know if anyone is facing the same challenge and if you have a solution, please share it. I really appreciate any help you can provide.

[lgaertner]

Hello Satya,

your approach is correct. Using:

{{merge(toArray(4.firstVar); toArray(4.secondVar))}}

gives me

{
        "result": [
            {
                "key1": "value1"
            },
            {
                "key2": "value2"
            },
            {
                "key3": "value3"
            }
        ]
    }

Regards

Lars

[Satya_NarayanaMu]

Hi @lgaertner ,

Thanks for your response. yeah, I'm also using the same expression. But I need this output {"key1":"value1","key2":"value2","key3":"value3"}. All keys and values in a single object.

Thanks,

Satya v

[ChrisStephens]

Once you merge everything like that, why not just do get({your array};0)

[Satya_NarayanaMu]

Hi @ChrisStephens ,

when we merge two collections we get this output result: [{"key1":"value1"},{"key2":"value2"},{"key3":"value3"}] . If we use get(result[];1) we get the only first object  {"key1":"value1"}  

[ChrisStephens]

can you screen shot your input in Fusion?

[Satya_NarayanaMu]

sure @ChrisStephens  as mentioned above screenshot After the merge I got the array of objects

[ChrisStephens · Accepted solution]

oh, that's not what I was picturing, sorry.

Check out the sample code attached, that should work.

[Satya_NarayanaMu]

Thanks @ChrisStephens , it's working as expected.

[AndyHess]

Hi All,

There is a new feature just released in Fusion that will manage this requirement much better.

We’re excited to announce the addition of a new function called mergeCollections under General Functions 

This function allows you to seamlessly merge two collections into one by combining their key-value pairs, making your data manipulation even more efficient