JSON query (gjson)

Match multiple values in one search

There is no way to match multiple values in one run, but you can use the pipe | operator to run multiple searches in a row.

Query sample

friends.#(first!=Dale)#|#(first!=Roger)#.last
// Result: ["Murphy","Smith"]

Code sample

In template code:

{{ $res.Get "friends.#(first!=Dale)#|#(first!=Roger)#.last" }}
// With more pipes:
{{ $res.Get "friends.#(first!=Dale)#|#(first!=Roger)#.last|@unique|@commaSepStr" }}
// Result: "Murphy,Smith"

While chaining requests:

<input 
    type="hidden"
    name="CustomApi.Api.Query.req2.<-names"
    data-preset-val="req1.Response.friends.#(first!=Dale)#|#(first!=Roger)#.last|@unique|@commaSepStr">

JSON payload for references

{
  "name": {
    "first": "Tom",
    "last": "Anderson"
  },
  "age": 37,
  "children": [
    "Sara",
    "Alex",
    "Jack"
  ],
  "fav.movie": "Deer Hunter",
  "friends": [
    {
      "first": "Dale",
      "last": "Murphy",
      "age": 44,
      "nets": [
        "ig",
        "fb",
        "tw"
      ]
    },
    {
      "first": "Roger",
      "last": "Craig",
      "age": 68,
      "nets": [
        "fb",
        "tw"
      ]
    },
    {
      "first": "Jane",
      "last": "Murphy",
      "age": 47,
      "nets": [
        "fb",
        "ig"
      ]
    },
    {
      "first": "John",
      "last": "Smith",
      "age": 49,
      "nets": [
        "tw"
      ]
    }
  ]
}