JSONPath · lesson 5 of 13 · Selecting many

Slices

[start:end:step] selects a range. end is exclusive, every part is optional, negative values count from the end, and a negative step walks backwards.

Example 1A range

Document

{
  "store": {
    "book": [
      { "title": "Sayings of the Century", "author": "Nigel Rees",
        "category": "reference", "price": 8.95 },
      { "title": "Sword of Honour", "author": "Evelyn Waugh",
        "category": "fiction", "price": 12.99 },
      { "title": "Moby Dick", "author": "Herman Melville",
        "category": "fiction", "price": 8.99, "isbn": "0-553-21311-3" },
      { "title": "The Lord of the Rings", "author": "J. R. R. Tolkien",
        "category": "fiction", "price": 22.99, "isbn": "0-395-19395-8" }
    ],
    "bicycle": { "color": "red", "price": 19.95 }
  }
}

Query

$.store.book[1:3].title

[1:3] Elements at index 1 and 2 — the end is exclusive.

Result

"Sword of Honour"
"Moby Dick"

Try it in the playground

Example 2Every other element

Document

{
  "store": {
    "book": [
      { "title": "Sayings of the Century", "author": "Nigel Rees",
        "category": "reference", "price": 8.95 },
      { "title": "Sword of Honour", "author": "Evelyn Waugh",
        "category": "fiction", "price": 12.99 },
      { "title": "Moby Dick", "author": "Herman Melville",
        "category": "fiction", "price": 8.99, "isbn": "0-553-21311-3" },
      { "title": "The Lord of the Rings", "author": "J. R. R. Tolkien",
        "category": "fiction", "price": 22.99, "isbn": "0-395-19395-8" }
    ],
    "bicycle": { "color": "red", "price": 19.95 }
  }
}

Query

$.store.book[::2].title

[::2] Start and end left open, step 2: elements 0 and 2.

Result

"Sayings of the Century"
"Moby Dick"

Try it in the playground

Good to know

[-2:] is the last two elements, and [::-1] walks the whole array backwards.