$ npm install jsonquerylanguage

var JQL = require("jsonquerylanguage");
var jql = new JQL();

var sampleJson =
[
    {
        "category": "reference",
        "author": "Nigel Rees",
        "title": "Sayings of the Century",
        "price": 8.95,
        "reviews":
        {
            "nyt": 5,
            "cst": 4
        }
    },
    {
        "category": "fiction",
        "author": "Evelyn Waugh",
        "title": "Sword of Honour",
        "price": 12.99,
        "reviews":
        {
            "nyt": 2,
            "cst": 5
        }
    }
];

var goodTitles = jql.searchAndGetValues(sampleJson, "$.*.reviews[?(@.nyt >= 4)].^.title");
console.log(JSON.stringify(goodTitles, null, 5));

Here are some tools and docs to make JQL easier to use!

JSDOCS: https://developers.adp.com/JQL/JsonQueryLanguage/jsdocs/index.html

JSON Renderer: https://developers.adp.com/JQL/JsonRenderer/index.html
Click the "Render" button, then click an item, and the concrete JQL path is shown at the bottom.

JQL Test Page: https://developers.adp.com/JQL/JsonQueryLanguage/index.html
Use this to test JQL paths and functions.

NOTE: these tools have not gone through any serious QA process. But hey, they're free. Not free as in speech, or free as in beer, but free as in puppy! :-)

• Extracting data from unruly JSON
• Creating, updating, and deleting data
• In other words, CRUD operations

• Started with Stefan Goessner’s JSONPath
• JSONPath was missing a "parent" operator
• Found problem with "all children" (recursive descent) operator
• So, embarked on a rewrite

• A combination of API and toolset for querying JSON docs
• Toolset simplifies process of writing JQL queries (the hardest part)
• Interactive query design
• Instant Gratification UI TM
• API can be used with Node.js or within browser

• Fixed recursive descent operator
• Retained methods for extracting data and paths from input JSON
• Retained idea that returned data is always an array (even when nothing is found)
• Extended Goessner’s JSON example
• Added "^" parent operator

• Added methods for updating and deleting data from given JSON
• Added methods to simplify checking existence of objects deep inside the given JSON
• Provided tools and docs
• Added features requested by users, mostly Jon Wright

• We usually pronounce “JQL” as three individual letters: “Jay Queue Elle”
• Confusing it with SQL, someone here tried calling it “JayQuil” (like Vicks Nyquil, but for congested birds that can’t sleep)
• We figured out that it was French, so we tried "Je Quelle"
• Now back to calling it "JQL" as three individual letters :-)

• $ - the top level object
• .<property> or [<property>]
• [<property1>,<property2>,…]

• [<non_negative_integer>]
• [<non_negative_integer>,<non_negative_integer>,...]

• [*] or * – all children (properties or array elements)
• ~ - current item and all descendants

• ^ - parent of the current object
• Used when we have to first check for a property, then "back up" to get another property

• [?(<condition>)] – select items which satisfy the condition
• Valid Conditions:

•  Current object: @
  

•  Comparison operators: <, <=, ==, !=, >, >=
  

•  Boolean connectives: &&, ||, !
  

•  Grouping symbols: (, )
  

• Only single properties can follow the @

*Note: Parser is not reentrant, so only single properties can follow the @!

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

Expression: $.~.price

Explanation: Get prices of everything

Result:

[
    99.95,
    8.95,
    12.99,
    8.99,
    22.99,
    19.95
]

Goessner’s JSONPath fails here

• Carry-over from original JSONPath
• As Goessner notes, this allows for "fluent" interface and method-chaining

Expression: $.store.book[0]

Explanation: Get book #0

Result:

[
    {
        "category": "reference",
        "author": "Nigel Rees",
        "title": "Sayings of the Century",
        "price": 8.95,
        "reviews":
        {
            "author": "Whoever",
            "title": "Whatever",
            "nyt": 5,
            "cst": 4
        }
    }
]

Expression: $.store.book[?(@.price < 10)].title

Explanation: Get title of all books priced under 10

Result:

[
    "Sayings of the Century",
    "Moby Dick“
]

Expression: $.store.book[?(@.price < 10)].reviews.[?(@.nyt >= 3)].^.title

Explanation: Get title of all books priced under 10 that are rated 3 or above by the NYT

Result:

[
    "Sayings of the Century",
    "Moby Dick"
]

Expression: $.store.book[*].reviews.[?(@.nyt == @.cst)].^.[title,author]

Explanation: Get title and author of all books that received the same reviews from the Chicago Sun-Times and the NYT

Result:

[
    "Moby Dick",
    "Herman Melville"
]

Include script in page:�

<script type="text/javascript" src="scripts/JQL.js"></script>

Create instance:

var jql = new JQL();

Require script:�

var JQL = require("./utils/JQL");

Create instance:�

var jql = new JQL();

jql.insertValue(sourceObj, location, newValue)

Code:

var res = jql.insertValue(sourceObj, "$.store.bicycle.type", "Cannondale");

Results:

...
"bicycle":
{
    "color": "red",
    "price": 19.95,
    "type": "Cannondale"
}
...

Code:

var res = jql.insertValue(sourceObj, "$.store.bicycle.style", {"trim":"black", "highlight":"yellow"});

Results:

...
"bicycle":
{
    "color": "red",
    "price": 19.95,
    "type": "Cannondale",
    "style":
    {
        "trim":"black",
        "highlight":"yellow"
    }
}
...

JQL can retrieve two types of results:

• The values
• Direct paths to the values (no wildcards)

To get values, use �

jql.searchAndGetValues(sourceObj, jsonQuery)

To get paths, use�

jql.searchAndGetPaths(sourceObj, jsonQuery)

Code:

var res = jql.searchAndGetValues(testObj, "$.~.price");��console.log(JSON.stringify(res, null, 5));

Results:

[
    99.95,
    8.95,
    12.99,
    8.99,
    22.99,
    19.95
]

Code:

var res = jql.searchAndGetPaths(testObj, "$.~.price");

Results:

[
   "$['price']",
   "$['store']['book'][0]['price']",
   "$['store']['book'][0]['reviews']['price']",
   "$['store']['book'][1]['price']",
   "$['store']['book'][2]['price']",
   "$['store']['book'][3]['price']",
   "$['store']['bicycle']['price']",
   "$['store']['motorcycle']['price']"
]

Use

jql.update(sourceObj, jsonQuery, replacementValue);

Use�

jql.remove(sourceObj, jsonDeleteQuery);

The MIT License (MIT)

Copyright (c) 2014 ADP, Inc.

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.