JsonPath get length of array after filter

Question

Hi I want get legth of array after Filter with JsonPath.

Is it possible ?

My filter is $.issues.[?(@.severity == 'MAJOR')].length()

My Json is

{
  "issues": [
        {
            "severity": "MAJOR"
        },
                {
            "severity": "MINOR"
        },
                {
            "severity": "MAJOR"
        },
                {
            "severity": "MAJOR"
        },
                {
            "severity": "MAJOR"
        }
]
  
}

Can you please tag your question with the language you are working in? See stackoverflow.com/help/tagging. In the original JSONPath proposal goessner.net/articles/JsonPath a query returns (array|false) : Array holding either values or normalized path expressions matching the input path expression, which can be used for lazy evaluation. false in case of no match. So there is nothing that returns the count of matches in the proposal itself. But maybe your language & framework supports something. Or you can just count the number of items returned afterwards. — dbc
– dbc, Commented Apr 23, 2018 at 13:58
What about Jayway JsonPath implementation: the following JsonPath expression seems to be valid yet it returns incorrect result: see sample — begie
– begie, Commented Jun 6, 2018 at 12:50
@begie that example returns the count of keys of the map (category, author, title, price). — Joaquín Fernández
– Joaquín Fernández, Commented Apr 24, 2019 at 14:02
It's been some time but I believe that's why my comment says incorrect result is returned... — begie
– begie, Commented Apr 26, 2019 at 7:03
Any update on this? I think length is just for basic approaches — JRichardsz
– JRichardsz, Commented Jan 22, 2021 at 15:35

Akshay G · Accepted Answer · 2023-11-06 09:17:23Z

8

Possible workaround for Jayway JsonPath implementation

$.length($.issues.[?(@.severity == 'MAJOR')].length())

edited Nov 6, 2023 at 9:17

answered Mar 28, 2022 at 9:45

Akshay G

2,3601 gold badge19 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

JsonPath get length of array after filter

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