Parsing json while executing a curl

Question

I am doing the following curl request in my bash script to get a coverage report for my build :

codeCoverage=$(curl -s $url/job/$jobname/$lastBuildNo/cobertura/api/json?depth=2)

This returns a json reponse which looks like this:

{
"results": {
    "children": [
        {
            "children": [
                {}
            ],
            "elements": [
                {},
                {}
            ],
            "name": "com.test.web"
        },
        {
            "children": [
                {}
            ],
            "elements": [
                {},
                {}
            ],
            "name": "com.test.web.filters"
        }
    ],
    "elements": [
        {
            "name": "Classes",
            "ratio": 37.75
        },
        {
            "name": "Conditionals",
            "ratio": 11.63969
        },
        {
            "name": "Files",
            "ratio": 42.70073
        },
        {
            "name": "Lines",
            "ratio": 16.937233
        },
        {
            "name": "Methods",
            "ratio": 23.67906
        },
        {
            "name": "Packages",
            "ratio": 50
        }
    ],
    "name": "Cobertura Coverage Report"
}

}

I am just interested in the

"name": "Lines",
"ratio": 16.937233

I can parse the text once I get it and extract that value, but is there any way to just get that value when I make the curl request?

do you mean the output will be : Lines, 16.937233 ?

BMW
– BMW

2014-02-18 02:46:43 +00:00
Commented Feb 18, 2014 at 2:46 — BMW
– BMW, Commented Feb 18, 2014 at 2:46
Ideally I would want just 16.937233

Pi Horse
– Pi Horse

2014-02-18 02:53:54 +00:00
Commented Feb 18, 2014 at 2:53 — Pi Horse
– Pi Horse, Commented Feb 18, 2014 at 2:53
Your json file is not valid at line 9.

kev
– kev

2014-02-18 02:54:19 +00:00
Commented Feb 18, 2014 at 2:54 — kev
– kev, Commented Feb 18, 2014 at 2:54
use python for such tasks...

MLSC
– MLSC

2014-02-18 08:02:39 +00:00
Commented Feb 18, 2014 at 8:02 — MLSC
– MLSC, Commented Feb 18, 2014 at 8:02

kev · Accepted Answer · 2014-02-18 02:57:52Z

2

Please use the wonderful json util jq:

jq -r '.results.elements[] | select(.name=="Lines").ratio' input.json

answered Feb 18, 2014 at 2:57

kev

163k49 gold badges286 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Parsing json while executing a curl

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related