Json Path - Filter on List of List

Question

I have a JSON like this:

{
"DATA": [
  {
    "docName": "xyz",
    "result": [
      {
        "attribute": "attr1",
        "value": true
      },
      {
        "attribute": "attr2",
        "value": true
      }
    ]
  },
  {
    "docName": "abc",
    "result": [
      {
        "attribute": "attr1",
        "value": false
      },
      {
        "attribute": "attr2",
        "value": true
      }
    ]
  }]
}

My use case is to find all the docNames for which the attr1 = true

I tried a couple of filter expressions but I am unable to get the doc names. I tried something like this: $.DATA[?(@.result[0].attribute=='attr1' && @.result[0].value == true)].docName and I get the docNames, but I can't rely on the 1st element of the list. I need to verify if attr1 is present anywhere in the list with value of true.

Any help would be appreciated.

Helping hand · Accepted Answer · 2018-08-01 19:18:57Z

3

After some coding & then figuring out why this is not working, what exactly I found out is that, currently its not possible with jsonpath to get parent element from filtering child node (nested json). Open Issue Link

Otherwise this might have worked,

$.DATA[?(@.result[?(@.attribute=="attr1" && @.value==true)])].docName

edited Aug 1, 2018 at 19:18

answered Aug 1, 2018 at 19:10

Helping hand

2,9602 gold badges21 silver badges33 bronze badges

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

Comments

peak · Accepted Answer · 2018-08-02 05:39:13Z

2

jq is quite similar to JSONpath so perhaps a jq solution will be of help. It is, at least, very simple:

# find all the docNames for which the attr1 == true
.DATA[]
| select( any(.result[]; .attribute == "attr1" and .value == true) )
| .docName

Java bindings

https://github.com/eiiches/jackson-jq
https://github.com/arakelian/java-jq (available from Maven Central)
Java Native Access wrapper https://github.com/bskaggs/jjq . Supported platform is Linux only.

edited Aug 2, 2018 at 5:39

answered Aug 2, 2018 at 2:02

peak

119k21 gold badges185 silver badges218 bronze badges

1 Comment

peak Over a year ago

See update, but please note that I have no personal experience with any of these. Let us know about any pros and cons that you encounter.

Collectives™ on Stack Overflow

Json Path - Filter on List of List

2 Answers 2

Comments

Java bindings

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Java bindings

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related