Geek Answers Handbook

PowerShell - Merge JSON Files

How to copy objects of one array of a JSON file to an array of another JSON file using PowerShell? For example, I have one JSON file, for example:

"type": "Employee", "Properties": [ { "Name": "Raj", "Id": "18111", "email": "emp1@company.com", "Position": "Manager", "DateOfJoining": "16.10.14", } ], "Description": "Employee details"

and another JSON file:

 "type": "Employee", "Properties": [ { "Name": "Ram", "Id": "44000", "email": "emp2@company.com", "Position": "Admin", "DateOfJoining": "10.12.14", }, { "Name": "Paul", "Id": "44002", "email": "emp3@company.com", "Position": "Programmer", "DateOfJoining": "10.9.14", }, ], "Description": "Employee details"

I want to copy arrays from the 1st JSON file to the second JSON file.

+1
json powershell
source share
1 answer

You can try something like this:

 $c1 = Convert-FromJson (gc file1.json -raw) $c2 = Convert-FromJson (gc file2.json -raw) $c3 = $c1.Properties + $c2.Properties $c3 | ConvertTo-Json
-3
source share

More articles:


All Articles