Read an API response

Many APIs wrap their useful records in a data or results field. JQL can start directly from that nested array.

Source JSON

response.json:

{
  "page": 1,
  "data": {
    "users": [
      {"id": 1, "name": "Amina"},
      {"id": 2, "name": "Jon"}
    ]
  }
}

Query

jql "select {name} from 'response.json'[data.users]"

Result

[
  {"name": "Amina"},
  {"name": "Jon"}
]

The source path [data.users] goes straight to the nested array. The surrounding API metadata does not get in the way.