Parsing data from array

[Mikael Wallin]

I have following json. (An undetermined size of "action" objects of various kinds).

{

actions:[

• {},
• {},
• {

  • failCount: 1,
  • skipCount: 0,
  • totalCount: 33,
  • urlName: "testReport"

  }

],

}

I want to extract the value if failCount.

So far I have come up with:

"$.actions.[?((@.failCount)&&(@.failCount)&&(@.totalCount))]"

but the result doesn't let me access failCount ie. "$.actions.[?((@.failCount)&&(@.failCount)&&(@.totalCount))].failCount" doesn't work as the result is an array.

[kalle stenflo]

Given JSON:

{
    "actions": [
        {},
        {},
        {
            "failCount": 1,
            "skipCount": 0,
            "totalCount": 33,
            "urlName": "testReport"
        }
    ]
}

Evaluating path

$.actions[?(@.failCount)].failCount

Returns

[ 1 ]

Try it out here http://jsonpath.herokuapp.com

[Rajukamal R]

The expression works fine but returns an array. How do I get the first element in the result array?

$.actions[?(@.failCount)].failCount[0] or $.actions[?(@.failCount)][0].failCount don't work