JsonPath - how to pull values ​​from Json, except for certain ones?

Question

JSON

Hello.
There is this Json:
[
{
"accID": "3asdasd321asdasdfsadf2",
"test": "one",
"isGood": "true",
},
{
"accID": "Not Found",
"test": "two",
"isGood": "true",
},
{
"accID": "1asdasd121asdasdfsadf5",
"test": "five",
"isGood": "false",
}
]

I want to get all accID values ​​but without 'Not Found' , like this:
[
"3asdasd321asdasdfsadf2",
"


$.[?(@.accID != 'Not Found')] - this one returns the same Json, but without sections containing 'Not Found'
$.accID[?(@.accID != 'Not Found' )] - this does not work.
How can I set up a filter to get the desired result without 'Not Found'?

Help, please, I'm already tormented.

Answer 1

jsonContext = JsonPath.parse(jsonString);

    List<String> data = jsonContext.read("$.[?(@.acc != 'Not Found')].acc");
    assertThat(data, notNullValue());
    assertThat(data.size(), greaterThan(0));
    System.err.println("Results: " + data);

gives

Results: ["3asdasd321asdasdfsadf2","1asdasd121asdasdfsadf5"]

Answer 2

1/ dict inside list right?
try breaking it down into steps:

a= your list
# так как это список, нам нужно посмотреть все элементы в списке
# в вашем случае, элементы - это словарь (ну или json - не важно)
for i in a: 
    if i['accID'] != 'Not Found':
        print(i['accID'])

# в одну строку
print(list(i['accID'] for i in a if i['accID'] != 'Not Found'))