ConvertFrom-Json PowerShell Cmdlet not parsing entire JSON object

Question

I have this JSON in a file called test.txt

{
  "local-dev": {
    "client": {
      "server-url": "http://localhost:3000"
    },
    "server": {
      "renterEndpoint": {
        "rejectUnauthorized": false,
        "host": "blah.blah.com",
        "port": 443,
        "path": "/api/renter"
      },
      "homeownerEndpoint": {
        "rejectUnauthorized": false,
        "host": "blah.blah.com",
        "port": 443,
        "path": "/api/homeowner"
      }
    }
  }
}

When I run this PowerShell command:

Get-Content "test.txt" -Raw | ConvertFrom-Json

The out put I get does not include any of the objects under the second level (i.e. the client and server objects have no properties).

local-dev
---------
@{client=; server=}

Anyone have any ideas?

Matt · Accepted Answer · 2014-11-25 00:07:37Z

13

The data you want is there. You just need to navigate the "nodes" ( dont know the proper terms ) If you return the data from your file into a variable and use Get-Member you can see what you are looking for.

PS C:\Users\Cameron> $json | Get-Member | Select-Object name

Name                                                                                                                                                                                              
----                                                                                                                                                                                              
Equals                                                                                                                                                                                            
GetHashCode                                                                                                                                                                                       
GetType                                                                                                                                                                                           
ToString                                                                                                                                                                                          
local-dev

Lets see whats in local-dev. note the quotes around the property. Need PowerShell to treat this as a string else you will get parsing errors.

PS C:\Users\Cameron> $json."local-dev"

client                                        server                                       
------                                        ------                                       
@{server-url=http://localhost:3000}           @{renterEndpoint=; homeownerEndpoint=}

Let's travel a little farther

PS C:\Users\Cameron> $json."local-dev".server.renterEndpoint

    rejectUnauthorized host                                     port path                  
    ------------------ ----                                     ---- ----                  
                 False blah.blah.com                             443 /api/renter

I'm sure there are other ways to extract the data you are looking for. I only just started looking at this recently. Point being is that if you know what you are looking for just use the properties of the object to get what you need. If that knowledge is not known to you Get-Member can help expose the properties to show you the data structure.

answered Nov 25, 2014 at 0:07

Matt

47k9 gold badges90 silver badges125 bronze badges

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

3 Comments

dprothero Over a year ago

Thanks Matt! It just wasn't immediately obvious that the data was there.

Matt Over a year ago

@dprothero Agreed. Just seemed like it had to be there somewhere :)

Vikas Gupta Over a year ago

Good answer.. FYI, having been bitten myself, I use one trick to confirm things like these.. ConvertTo-Json $json -Depth 10 and it will show the correct and entire structure (Depth 10, can use higher number), nicely formatted.

Collectives™ on Stack Overflow

ConvertFrom-Json PowerShell Cmdlet not parsing entire JSON object

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related