get json key value using powershell

Question

I have the following json output string:

{
    "meta": {
        "limit": 20,
        "next": null,
        "offset": 0,
        "previous": null,
        "total_count": 1
    },
    "objects": [{
        "bcontext": "/api/v2.0/buildercontext/2/",
        "bugs": [],
        "build": {
            "bldtype": "obj",
            "branch": "main",
            "buildstatus": [{
                "build": "/api/v2.0/build/2140634/",
                "failurereason": "_checkfailures (seen: FAIL - /testrun/18647678/ - area[4769] AIM-SANITY)",
                "id": "1294397",
                "lastupdate": "2015-03-31T14:30:18",
                "overridden": false,
                "overridedesc": "",
                "overrideuser": null,
                "recommended": false,
                "resource_uri": "/api/v2.0/buildstatus/1294397/",
                "slatype": {
                    "id": "26",
                    "name": "VA_Bats",
                    "resource_uri": "/api/v2.0/sla/26/"
                }
            }],
            "changeset": "494625",
            "coverage": false,
            "deliverables": ["/api/v2.0/deliverable/4296455/", "/api/v2.0/deliverable/4296956/", "/api/v2.0/deliverable/4296959/", "/api/v2.0/deliverable/4296986/", "/api/v2.0/deliverable/4296992/", "/api/v2.0/deliverable/4296995/", "/api/v2.0/deliverable/4297034/", "/api/v2.0/deliverable/4297058/"],
            "git_host": null,
            "git_repo": null,
            "id": "2140634",
            "p4host": {
                "id": "10",
                "p4port": "perforce-rhino.eng.com:1800",
                "p4weburl": "http://p4web.eng.com:1800",
                "resource_uri": "/api/v2.0/perforceserver/10/"
            },
            "resource_uri": "/api/v2.0/build/2140634/",
            "site": "/api/v2.0/site/25/",
            "site_name": "mbu",
            "slastested": ["/api/v2.0/sla/26/"],
            "submit_time": "2015-03-31T05:40:21",
            "submit_user": "haharonof"
        },
        "builder": "/api/v2.0/builder/1423/",
        "clean": true,
        "componentbuilds": "vcops-vsphere-solution-pak=sb-5242047,vrops=sb-5242013,vscm=sb-5242025,vsutilities=sb-5242029;parentbuilder=1410",
        "deleted": false,
        "endtime": "2015-03-31T06:20:58",
        "helpzillas": [],
        "id": "4296956",
        "location": {
            "httpserver": "sc-prd-cat-services001.eng.com",
            "id": "1",
            "name": "PA",
            "nfsserver": "cat-results.eng.com",
            "pxedir": "/mts/builder-pxe",
            "resource_uri": "/api/v2.0/location/1/",
            "resultspath": "/results"
        },
        "nfsserver": "build-storage60",
        "p4client": "vmktestdevnanny-builder-1423",
        "path": "/storage60/release/sb-5242148",
        "ready": true,
        "resource_uri": "/api/v2.0/deliverable/4296956/",
        "result": "PASS",
        "sbbuildid": 5242148,
        "sbjobid": 5242148,
        "sbuser": "arajamanickam",
        "starttime": "2015-03-31T06:16:50",
        "targetchangeset": "494625",
        "targets": "vcopssuitevm",
        "triagetime": null,
        "vmodl": null
    }]
}

I want to get sbbuildid using powershell. How can I get this?

Mathias R. Jessen · Accepted Answer · 2015-04-07 09:55:03Z

20

By converting your json to an object, using the ConvertFrom-Json cmdlet (assuming $jsonString contains the json above):

$jsonObj = $jsonString | ConvertFrom-Json
$jsonObj.objects.sbbuildid

answered Apr 7, 2015 at 9:55

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

2 Comments

SixOThree Over a year ago

Just a nitpick. This is not the key value. In practice this actually appears to get the entire key, not just the value. Write-Host, for example, will only show you the value. But if you do anything with the object you will find it has the key name and value.

Mathias R. Jessen Over a year ago

@SixOThree I'm afraid I don't understand what you're trying to say here. Does $jsonObj.objects.sbbuildid not resolve the correct value when you try it on your own machine, or...?

Shashi Ranjan · Accepted Answer · 2015-04-08 09:23:52Z

-5

$sb_build_id = $build_info.Substring($build_info.IndexOf("sbbuildid") + 11, 8).trim()

Put whole string in $build_info

edited Apr 8, 2015 at 9:23

answered Apr 7, 2015 at 10:32

Shashi Ranjan

1,5617 gold badges29 silver badges56 bronze badges

3 Comments

Mathias R. Jessen Over a year ago

That's a pretty fragile solution, it captures the space in front of the ID, and breaks once you reach a build id above 9999999 or below 1000000

Shashi Ranjan Over a year ago

I am not sure why it is capturing space. I used a trim() after getting the value.

Chris Watts Over a year ago

using the built in ConvertFrom-Json is a much much better way to go. It improves readability and reduces error prone substring operations.

Collectives™ on Stack Overflow

get json key value using powershell

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related