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.
Solved! Go to Solution.
Views
Replies
Total Likes
oh, that's not what I was picturing, sorry.
Check out the sample code attached, that should work.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Once you merge everything like that, why not just do get({your array};0)
Views
Replies
Total Likes
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"}
Views
Replies
Total Likes
can you screen shot your input in Fusion?
Views
Replies
Total Likes
sure @ChrisStephens as mentioned above screenshot After the merge I got the array of objects
Views
Replies
Total Likes
oh, that's not what I was picturing, sorry.
Check out the sample code attached, that should work.
Views
Replies
Total Likes
Thanks @ChrisStephens , it's working as expected.
Views
Replies
Total Likes
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
Views
Replies
Total Likes