{"type":"doc","content":[{"type":"paragraph","content":[{"text":"The JSON-PATH directive uses a DSL for reading JSON records.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Syntax","type":"text"}]},{"type":"codeBlock","content":[{"text":"json-path :source :destination 'json-path'","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" specifies the column in the record that should be considered as the \"root member object\" or \"$\"","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" is the name of the output column in the record where the results of the expression will be stored","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"'json-path'","type":"text","marks":[{"type":"code"}]},{"text":" is a JSON path expression; see ","type":"text"},{"text":"Usage Notes","type":"text","marks":[{"type":"em"}]},{"text":" below for details","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Usage Notes","type":"text"}]},{"type":"paragraph","content":[{"text":"An expression always refers to a JSON structure in the same way that an XPath expression is used in combination with an XML document. The \"root member object\" is always referred to as ","type":"text"},{"text":"$","type":"text","marks":[{"type":"code"}]},{"text":" regardless if it is an object or an array.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Notation","type":"text"}]},{"type":"paragraph","content":[{"text":"Expressions can use either the \"dot–notation\":","type":"text"}]},{"type":"codeBlock","content":[{"text":"$.name.first","type":"text"}]},{"type":"paragraph","content":[{"text":"or the \"bracket–notation\":","type":"text"}]},{"type":"codeBlock","content":[{"text":"$['name']['first']","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Operators","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"$","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"The root element to query; this starts all path expressions","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"@","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"The current node being processed by a filter predicate","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Wildcard; available anywhere a name or numeric are required","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"..","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Deep scan; available anywhere a name is required","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":".","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Dot-notated child","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"['' (, '')]","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Bracket-notated child or children","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"[ (, )]","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Array index or indexes","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"[start:end]","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Array slice operator","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[281.0]},"content":[{"type":"paragraph","content":[{"text":"[?()]","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[478.0]},"content":[{"type":"paragraph","content":[{"text":"Filter expression; must evaluate to a boolean value","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Functions","type":"text"}]},{"type":"paragraph","content":[{"text":"Functions can be invoked at the tail end of a path: the input to a function is the output of the path expression. The function output is dictated by the function itself.","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[158.0]},"content":[{"type":"paragraph","content":[{"text":"Function","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[350.0]},"content":[{"type":"paragraph","content":[{"text":"Returns","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[254.0]},"content":[{"type":"paragraph","content":[{"text":"Output","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[158.0]},"content":[{"type":"paragraph","content":[{"text":"min()","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[350.0]},"content":[{"type":"paragraph","content":[{"text":"The min value of an array of numbers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[254.0]},"content":[{"type":"paragraph","content":[{"text":"Double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[158.0]},"content":[{"type":"paragraph","content":[{"text":"max()","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[350.0]},"content":[{"type":"paragraph","content":[{"text":"The max value of an array of numbers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[254.0]},"content":[{"type":"paragraph","content":[{"text":"Double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[158.0]},"content":[{"type":"paragraph","content":[{"text":"avg()","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[350.0]},"content":[{"type":"paragraph","content":[{"text":"The average value of an array of numbers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[254.0]},"content":[{"type":"paragraph","content":[{"text":"Double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[158.0]},"content":[{"type":"paragraph","content":[{"text":"stddev()","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[350.0]},"content":[{"type":"paragraph","content":[{"text":"The standard deviation value of an array of numbers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[254.0]},"content":[{"type":"paragraph","content":[{"text":"Double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[158.0]},"content":[{"type":"paragraph","content":[{"text":"length()","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[350.0]},"content":[{"type":"paragraph","content":[{"text":"The length of an array","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[254.0]},"content":[{"type":"paragraph","content":[{"text":"Integer","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Filter Operators","type":"text"}]},{"type":"paragraph","content":[{"text":"Filters are logical expressions used to filter arrays. A typical filter would be:","type":"text"}]},{"type":"codeBlock","content":[{"text":"[?(@.age>18)]","type":"text"}]},{"type":"paragraph","content":[{"text":"where ","type":"text"},{"text":"@","type":"text","marks":[{"type":"code"}]},{"text":" represents the current item being processed.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"More complex filters can be created with the logical operators ","type":"text"},{"text":"&&","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"||","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"String literals must be enclosed by either single or double quotes, such as in ","type":"text"},{"text":"[?(@.color=='blue')]","type":"text","marks":[{"type":"code"}]},{"text":" or ","type":"text"},{"text":"[?(@.color==\"blue\")]","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Filter Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"==","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left is equal in type and value to right (note ","type":"text"},{"text":"1","type":"text","marks":[{"type":"code"}]},{"text":" is not equal to ","type":"text"},{"text":"'1'","type":"text","marks":[{"type":"code"}]},{"text":")","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"!=","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left is not equal to right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"<","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left is less than right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"<=","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left is less than or equal to right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":">","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left is greater than right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":">=","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left is greater than or equal to right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"=~","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left matches regular expression ","type":"text"},{"text":"[?(@.name=~/foo.*?/i)]","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"in","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left exists in right ","type":"text"},{"text":"[?(@.size in ['S', 'M'])]","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"nin","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left does not exist in right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"size","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Size of left (array or string) matches right","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"empty","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Left (array or string) is empty","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Examples","type":"text"}]},{"type":"paragraph","content":[{"text":"Using this record as an example:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"store\": {\n \"book\": [\n {\n \"category\": \"reference\",\n \"author\": \"Nigel Rees\",\n \"title\": \"Sayings of the Century\",\n \"price\": 8.95\n },\n {\n \"category\": \"fiction\",\n \"author\": \"Evelyn Waugh\",\n \"title\": \"Sword of Honour\",\n \"price\": 12.99\n },\n {\n \"category\": \"fiction\",\n \"author\": \"Herman Melville\",\n \"title\": \"Moby Dick\",\n \"isbn\": \"0-553-21311-3\",\n \"price\": 8.99\n },\n {\n \"category\": \"fiction\",\n \"author\": \"J. R. R. Tolkien\",\n \"title\": \"The Lord of the Rings\",\n \"isbn\": \"0-395-19395-8\",\n \"price\": 22.99\n }\n ],\n \"bicycle\": {\n \"color\": \"red\",\n \"price\": 19.95\n }\n },\n \"expensive\": 10\n}","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"JSON Path (click link to test)","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"Result","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$.store.book[*].author","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$.store.book%5B*%5D.author"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"The authors of all books","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..author","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..author"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All authors","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$.store.*","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$.store.*"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All things, both books and bicycles","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$.store..price","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$.store..price"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"The price of everything","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[2]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B2%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"The third book","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[0,1]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B0,1%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"The first two books","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[:2]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B:2%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books from index 0 (inclusive) until index 2 (exclusive)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[1:2]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B1:2%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books from index 1 (inclusive) until index 2 (exclusive)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[-2:]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B-2:%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"Last two books","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[2:]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B2:%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"Book number two from tail","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[?(@.isbn)]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B?(@.isbn"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books with an ISBN number","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[?(@.isbn)]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B?(@.isbn"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books with an ISBN number","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$.store.book[?(@.price<10)]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$.store.book%5B?(@.price%3C10"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books in store cheaper than 10","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[?(@.price<=$['expensive'])]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B?(@.price%3C=$%5B%27expensive%27%5D"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books in store that are not \"expensive\"","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book[?(@.author=~/.*REES/i)]","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book%5B?(@.author=~/.*REES/i"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books matching a regex (ignore case)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..*","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"All books","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[304.0]},"content":[{"type":"paragraph","content":[{"text":"$..book.length()","type":"text","marks":[{"type":"link","attrs":{"href":"http://jsonpath.herokuapp.com/?path=$..book.length()"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[455.0]},"content":[{"type":"paragraph","content":[{"text":"The number of books","type":"text"}]}]}]}]},{"type":"paragraph"}],"version":1}

Browser not supported