merging two Jsons in powershell

Question

I have the following two Objects , which have been got from 2 Json file using:

$Env = ConvertFrom-Json "$(get-content "C:\chef\environments.json")"
$Roles = ConvertFrom-Json "$(get-content "C:\chef\roles.json")"

Heres the out put after conversion :

PS C:\chef> $Env

run_list
--------
{recipe[djin_chef-max_any::default]}


PS C:\chef> $Roles


7-zip             : @{home=%SYSTEMDRIVE%\7-zip}
cookbook_versions :
default           : @{env=development}
modmon            : @{env=dev}
paypal            : @{artifact=%5BINTEGRATION%5D}
seven_zip         : @{url=https://djcm-zip-local/djcm/chef}
task_sched        : @{credentials=XN$q}
windows           : @{password=K1N5}

I need to merge these two Json objects in powershell and I tried the following:

PS C:\chef> $Roles+$Env
Method invocation failed because [System.Management.Automation.PSObject] does not contain a method named 'op_Addition'.
At line:1 char:1
+ $Roles+$Env
+ ~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (op_Addition:String) [], RuntimeException
    + FullyQualifiedErrorId : MethodNotFound

Is there another elegant way of doing it if I am doing it wrong or why am I getting this error ?

Asking to merge two JSONs makes no more sense than asking to merge a photo and a video. It's entirely possible - once you decide whether you want the picture at the start, at the end, as an overlay in a specific place, inserted every other frame, as a transparent watermark in some corner, in a bigger frame next to the video image... JSON isn't a data structure, it's a serialisation format for many data structures. They won't necessarily mash together - you need to unpick what the datastructures are and how exactly you need them to merge. — TessellatingHeckler
– TessellatingHeckler, Commented Aug 3, 2016 at 21:00

briantist · Accepted Answer · 2016-08-03 20:47:26Z

2

$Env only has one property, so you could add a new member to $Roles:

$Roles | Add-Member -NotepropertyName run_list -NotePropertyValue $Env.run_list

This syntax work in PowerShell v3, but you listed v2 and v2 in your tags.. so for v2:

$Roles | Add-Member -MemberType NoteProperty -Name run_list -Value $Env.run_list

answered Aug 3, 2016 at 20:47

briantist

48.3k6 gold badges94 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Scooby Over a year ago

what if Env had more than one property ? Any to add and merge them together ?

briantist Over a year ago

@Scooby you could iterate over $Env.PSObject.Properties and programatically add each member.

Scooby Over a year ago

could you provide an example for that with made up values ??

Collectives™ on Stack Overflow

merging two Jsons in powershell

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related