Merging two json collections in fusion | Community
Skip to main content
S
Adobe Employee
Satya_NarayanaMuAdobe Employee
Adobe Employee
April 25, 2024
Solved

Merging two json collections in fusion

  • April 25, 2024
  • 2 replies
  • 2102 views

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.

Best answer by ChrisStephens

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


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

 

Check out the sample code attached, that should work.

2 replies

lgaertner
lgaertner
Level 9
April 25, 2024

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

S
Adobe Employee
Satya_NarayanaMuAdobe EmployeeAuthor
Adobe Employee
April 25, 2024

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

S
Adobe Employee
Satya_NarayanaMuAdobe EmployeeAuthor
Adobe Employee
April 25, 2024

can you screen shot your input in Fusion?


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

AndyHess
Adobe Employee
AndyHessAdobe Employee
Adobe Employee
October 23, 2024

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

    Terms & ConditionsAccessibility statement

    Loading footer...