Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Update JSON file without destroying JSON format

I'm trying to update a Swagger JSON document in Powershell. I need to add a couple of properties and values if they do not already exist on the object.

The code for doing this is pretty simple:

$swaggerDoc = (Get-Content $filePath -raw | ConvertFrom-Json)

$swaggerDoc | Add-Member -Name host -MemberType NoteProperty -Value "swagger.io" -Force
$swaggerDoc | Add-Member -Name schemes -MemberType NoteProperty -Value @("https") -Force

$swaggerDoc | ConvertTo-Json | Set-Content $filePath

The problem I have is that the JSON gets completely destroyed when I save it back to the file: For example

  "get": {
    "tags": [
      "Links"
    ],
    "operationId": "Links_GetAll",
    "parameters": [],
    "responses": {
      "200": {
        "description": "Returns all the available links in the system",
        "schema": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/AdministrativeLink"
          }
        },
        "x-nullable": true
      }
    }
  }

becomes

"get":  "@{tags=System.Object[]; operationId=Links_GetAll; parameters=System.Object[]; responses=}",

I haven't seen any other examples on how to do this in Powershell, is there some syntax or parameter I am missing in order to retain the original format?

like image 941
mclark1129 Avatar asked Jan 17 '17 20:01

mclark1129


People also ask

How do I modify a JSON file?

In the Enterprise Explorer view, right-click your . json file or other file type that contains JSON code and select Open With > JSON Editor. You can compress JSON strings so that the strings display on one line with white space removed between JSON elements.


1 Answers

When using ConvertTo-Json, use -Depth to retain proper format of the JSON.

For Example:

$swaggerDoc | ConvertTo-Json -Depth 10 | Set-Content $filePath

I also had to add brackets around your JSON to make it valid JSON readable by powershell.

like image 194
Matt Avatar answered Oct 17 '22 02:10

Matt