Remove an attribute from the JSON object in powershell

Question

I have following JSON and I would like to remove streets from the JSON object under Address which is an array. I am trying to do this in powershell

{
  "Customer": [
    {
      "id": "123"
    }
  ],
  "Nationality": [
    {
      "name": "US",
      "id": "456"
    }
  ],
  "address": [
    {
      "$type": "Home",
      "name": "Houston",
      "streets": [
        {
          "name": "Union",
          "postalCode": "10",
        }
      ]
    },
    {
      "$type": "Office",
      "name": "Hawai",
      "streets": [
        {
          "name": "Rock",
          "postalCode": "11",
        }
      ]
    }
  ],
  "address": [
    {
      "$type": "Home1",
      "name": "Houston",
      "streets": [
        {
          "name": "Union1",
          "postalCode": "14",
        }
      ]
    },
    {
      "$type": "Office1",
      "name": "Hawaii1",
      "streets": [
        {
          "name": "Rock1",
          "postalCode": "15",
        }
      ]
    }
  ],
}

I would like to remove streets from the JSON object and here is my powershell script but it is not working! I am trying to convert JSON into object and then loop over properties to remove those.

$FileContent = Get-Content -Path "Test.json" -Raw | ConvertFrom-Json
foreach ($content in $FileContent) {
    #Write-Host $content.address
    $content.address = $content.address | Select-Object * -ExcludeProperty streets
}

$FileContent | ConvertTo-Json -Depth 100 | Out-File "Test.json" -Force

TheMadTechnician · Accepted Answer · 2020-10-01 00:12:51Z

7

When you use ConvertFrom-Json it will automatically convert things to objects for you. Once they're objects you can use Select-Object to specify what properties you want to include in the pipeline, with which you can just set $FileContent.address (an array of objects) to equal itself, excluding the streets property from each object in the array.

$FileContent = Get-Content -Path "Test.json" -Raw | ConvertFrom-Json
$FileContent.address = $FileContent.address | Select-Object * -ExcludeProperty streets
$FileContent | ConvertTo-Json

answered Oct 1, 2020 at 0:12

TheMadTechnician

36.5k3 gold badges48 silver badges63 bronze badges

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

5 Comments

Learn AspNet Over a year ago

This is awesome but this does not work if I have multiple address blocks, it only keeps the last address without streets but removes the first address. I updated the JSON. Can you check how will it work in that case. Also if there are multiple customers with multiple addresses, will this work?

TheMadTechnician Over a year ago

Your updated JSON is not valid. That's a duplicate key. Well, it has more issues than that, you have spare commas in it, which you had originally and I removed to test with, but the duplicate address key is not valid JSON. You can check your JSON at jsonlint.com

Learn AspNet Over a year ago

I am having issues when streets property does not exist. Is there a way to check if the property exists before excluding the property

TheMadTechnician Over a year ago

What kind of issues? You could loop through the array of objects and check each one I suppose.

Learn AspNet Over a year ago

Can you answer this. stackoverflow.com/questions/64217264/…

Collectives™ on Stack Overflow

Remove an attribute from the JSON object in powershell

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related