Removing Objects from JSON using powershell

Question

I have a test.json file which has the below structure:

{
  "name": "test",
  "class": "4",
  "exam": "test",
  "marks": "4"
}

I want to remove some pairs from it like exam and class, and ultimately it should look like below:

{
  "name": "test",
  "marks": "4"
}

How can I do it from PowerShell?

DocZerø · Accepted Answer · 2022-03-17 08:04:18Z

3

Your post was not completely clear if you wanted to remove certain keys, or if you only wanted to retain marks and name. The code below performs the latter:

Get-Content 'test.json' -Raw | 
    ConvertFrom-Json | 
    Select-Object name, marks | 
    ConvertTo-Json

Result:

{
    "name":  "test",
    "marks":  "4"
}

answered Mar 17, 2022 at 8:04

DocZerø

8,61511 gold badges44 silver badges75 bronze badges

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

Comments

Sage Pourpre · Accepted Answer · 2022-03-17 09:18:42Z

2

powershell cmd:

$obj = Get-Content .\aaa.json | ConvertFrom-Json
$obj.psobject.properties.remove('exam')
$obj.psobject.properties.remove('class')
$obj | ConvertTo-Json

output:

{
    "name":  "test",
    "marks":  "4"
}

edited Mar 17, 2022 at 9:18

Sage Pourpre

10.4k3 gold badges30 silver badges43 bronze badges

answered Mar 17, 2022 at 7:28

William

213 bronze badges

Collectives™ on Stack Overflow

Removing Objects from JSON using powershell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related