Filter by nested arrays

[aageneralov]

Problem to solve

I have some trouble with filter elements in json array by nested arrays elements
Data:

{
  "docs": [
    {
      "title": "foo",
      "authors": [
        "one",
        "two"
      ]
    },
    {
      "title": "bar",
      "authors": [
        "one",
        "three"
      ]
    },
    {
      "title": "baz",
      "authors": [
        "two",
        "three"
      ]
    }
  ]
}  

I need to assert that data have doc with author named "two", I tried to use many variants of jsonpath:

$.docs[?(@.authors.indexOf('two') != -1)]
$.docs[?(@.authors[*] == 'two')]
$.docs[?(@.authors[?(@ == 'two')])]

But it doesn't work

Proposal

Please add an indexOf function or something like that

[fabricereix]

Hi @aageneralov,
I agree that we need to find a way of doing it.
We need to look into it. It could be interesting to see how jsonpath.com supports that.
The spec https://www.ietf.org/archive/id/draft-goessner-dispatch-jsonpath-00.html has not defined yet such functions (such as indexOf).

We also plan to add support for combining multiple filter expressions (#1697)
In this case, we could write something like $.docs[?(@.authors[1]=="two" || @.authors[0]=="two")].

[dorryspears]

@fabricereix what do you think about adding a "for all" clause on the on the assert

So for this example you would write

jsonpath $..authors contains "two" for all

[fabricereix]

yes we plan to add predicates that are applied to each element of a list.
you can have a look at #347

[dorryspears]

@fabricereix I will try to tackle the feature

[CrispyDrone]

What do you think about integrating hurl with any arbitrary tools to do processing? So, you could just invoke a jq or yq command during filters, assertions,...