jsonpath find all keys leave contains a string

Question

I'm using the JSON path to my elaborate. I need to find all final leaves nodes which contain a specific string. Suppose you have a json :

{  'nested' :{
              'leaf1' : 'MY_STRING_TO_FIND'
           },
   'leaf2' : 'MY_STRING_TO_FIND'
}

my purpose is to output leaf1 and leaf2

Are you trying to output `leaf1` and `leaf2` if their value is `MY_STRING_TO_FIND`? — Jack Fleeting, Feb 14 '20 at 18:46

score 0 · Answer 1 · answered Feb 16 '20 at 11:54

The json string in your question is invalid, but if I understand your question correctly and assuming the actual json string looks something like this:

{
    "nested": {
        "leaf1": "MY_STRING_TO_FIND",
         "leaf2": "some other string",
        "leaf3": "MY_STRING_TO_FIND"
    }
}

and assuming you can use jsonpath-plus, then the following expression:

*[?(@ === "MY_STRING_TO_FIND")]~

outputs:

[
    "leaf1",
    "leaf3"
]

jsonpath find all keys leave contains a string

1 Answers1