Remove Object from Array of Objects in Json/powershell

Question

I am importing JSON into Powershell to replace some values, but I also need to remove some objects from there.

Import:

$fileJson = Get-Content -path/Template.json  -Encoding UTF8

I have an array of object which looks like this:

{
 "resources": [
   {
     "name": "name1"
     "type": "type1"
     "....": "....."
   }, 
   {
     "name": "name2"
     "type": "type2"
     "....": "....."
   },
   {
     "name": "name3"
     "type": "type1"
     "....": "....."
   }
 ]
}

and I want to remove a specific object from this array of objects. For example I want to remove Object where "type" equals "type2".

I have already tried to replace values with .Replace, however I can only replace single values and not the complete object.

Is it possible to delete or skip entire object with condition?

Mathias R. Jessen · Accepted Answer · 2022-02-17 12:09:45Z

5

Convert the JSON to a custom object:

$fileJson = Get-Content -path/Template.json  -Encoding UTF8
$data = $fileJson |ConvertFrom-Json

Use Where-Object to filter the resources array:

$data.resources = @($data.resources |Where-Object type -ne type2)

Convert the now modified object back to JSON and write to disk:

$data |ConvertTo-Json |Set-Content ./path/to/updatedTemplate.json -Encoding UTF8

answered Feb 17, 2022 at 12:09

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

Comments

MikeSh · Accepted Answer · 2022-02-17 12:15:50Z

0

I suggest to convert json into PowerShell objects, then make desired changes. then convert back to json if needed.

Example

$root = Get-Content -Path "C:\source.json" | ConvertFrom-Json
$root.resources = $root.resources | where type -eq 'type2'
$root | ConvertTo-Json -Depth 5 | Out-File "C:\destination.json"

answered Feb 17, 2022 at 12:15

MikeSh

4422 silver badges6 bronze badges

3 Comments

Mathias R. Jessen Over a year ago

where type -eq 'type2' will produce the inverse of the result OP is asking for :)

MikeSh Over a year ago

yeah, I noticed this typo :) just after noticing you posted the same answer few minutes earlier :)

Mathias R. Jessen Over a year ago

No problem, you can always edit your own posts

Collectives™ on Stack Overflow

Remove Object from Array of Objects in Json/powershell

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related