How to modify Json using Powershell

Question

I have the following JSON held in a file "test.json":

{
  "metadata": [
    {
      "src": [
        {
          "files": [
            "src/**.csproj"
          ]
        }
      ],
      "dest": "api",
      "disableGitFeatures": false,
      "disableDefaultFilter": false
    }
  ]
}

I'd like to modify the "src" element. Instead of:

  "src": [
    {
      "files": [
        "src/**.csproj"
      ]
    }
  ],

It needs to be:

    "src": [
        {
          "files": [
            "*.csproj"
          ],
          "cwd":".."
        }
      ],

Where I modify the first element of "files" and add "cwd". This should be straight forward but I'm struggling to achieve this in powershell. Can anyone point me in the right direction of any examples of this?

Thanks for any pointers in advance.

AdminOfThings · Accepted Answer · 2020-05-04 14:01:39Z

5

You can do the following:

$JSONObject = Get-Content test.json -Raw | ConvertFrom-Json
$JSONObject.metadata.src.files = ,'*.csproj'
$JSONObject.metadata.src | Add-Member -Name 'cwd' -Value '..' -MemberType NoteProperty
$JSONObject | ConvertTo-Json -Depth 5 | Set-Content test.json

The tricky part is to make sure the .files value is an array of a single element. You can do this with the array subexpression operator @() or the unary operator ,.

edited May 4, 2020 at 14:01

answered May 4, 2020 at 13:50

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

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

1 Comment

Rob Over a year ago

This worked perfectly!! I just added "-force" to the end of the Add-Member in case it was run multiple times but this worked perfectly for me, thanks loads!! :D

Collectives™ on Stack Overflow

How to modify Json using Powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related