node package manager

json-query

Retrieves values from JSON objects for data binding. Offers params, nested queries, deep queries, custom reduce/filter functions and simple boolean logic. Browserify compatible.

json-query

Retrieves values from JSON objects for data binding. Offers params, nested queries, deep queries, custom reduce/filter functions and simple boolean logic.

Install via npm

$ npm install json-query
var jsonQuery = require('json-query')

Specify a query and what to query - returns an object that describes the result of the query.

 
var data = {
  people: [
    {name: 'Matt', country: 'NZ'},
    {name: 'Pete', country: 'AU'},
    {name: 'Mikey', country: 'NZ'}
  ]
}
 
jsonQuery('people[country=NZ].name', {
  data: data
}) //=> {value: 'Matt', parents: [...], key: 0} ... etc 
  • data or rootContext: The main JS object to query.
  • source or context (optional): The current object we're interested in. Is accessed in query by starting with .
  • parent (optional): An additional context for looking further up the tree. Is accessed by ..
  • locals: Specify an object containing helper functions. Accessed by ':filterName'. Expects function(input, args...) with this set to original passed in options.
  • globals: Falls back to globals when no local function found.
  • force (optional): Specify an object to be returned from the query if the query fails - it will be saved into the place the query expected the object to be.
  • allowRegexp (optional): enable ~ operator. Before enabling regexp match to anyone, consider the user defined regular expression security concerns.

Queries are strings that describe an object or value to pluck out, or manipulate from the context object. The syntax is a little bit CSS, a little bit JS, but pretty powerful.

person.name

people[0]

people.name => return all the names of people

lookup[*]

By default only the first matching item will be returned:

people[name=Matt]

But if you add an asterisk (*), all matching items will be returned:

people[*country=NZ]

You can use comparative operators:

people[*rating>=3]

Or use boolean logic:

people[* rating >= 3 & starred = true]

If options.enableRegexp is enabled, you can use the ~ operator to match RegExp:

people[*name~/^R/i]

You can also negate any of the above examples by adding a ! before the = or ~:

people[*country!=NZ]

person.greetingName|person.name

Search through multiple levels of Objects/Arrays

var data = {
  grouped_people: {
    'friends': [
      {name: 'Steve', country: 'NZ'},
      {name: 'Bob', country: 'US'}
    ],
    'enemies': [
      {name: 'Evil Steve', country: 'AU'}
    ]
  }
}
 
jsonQuery('grouped_people[][country=NZ]', {data: data})
var data = {
  page: {
    id: 'page_1',
    title: 'Test'
  },
  comments_lookup: {
    'page_1': [
      {id: 'comment_1', parent_id: 'page_1', content: "I am a comment"}
    ]
  }
}
 
// get the comments that match page's id 
jsonQuery('comments_lookup[{page.id}]', {data: data})

Allows to to hack the query system to do just about anything.

Some nicely contrived examples:

var helpers = {
  greetingNamefunction(input){
    if (input.known_as){
      return input.known_as
    } else {
      return input.name
    }
  },
  andfunction(inputAinputB){
    return inputA && inputB
  },
  textfunction(inputtext){
    return text
  },
  thenfunction(inputthenValueelseValue){
    if (input){
      return thenValue
    } else {
      return elseValue
    }
  }
}
 
var data = {
  is_fullscreen: true,
  is_playing: false,
  user: {
    name: "Matthew McKegg",
    known_as: "Matt"
  }
}
 
jsonQuery('user:greetingName', {
  data: data, locals: helpers
}).value //=> "Matt" 
 
jsonQuery(['is_fullscreen:and({is_playing}):then(?, ?)', "Playing big!", "Not so much"], {
  data: data, locals: helpers
}).value //=> "Not so much" 
 
jsonQuery(':text(This displays text cos we made it so)', {
  locals: helpers
}).value //=> "This displays text cos we made it so" 
 

Or you could add a select helper:

jsonQuery('people:select(name, country)', {
  data: data,
  locals: {
    selectfunction (input) {
      if (Array.isArray(input)) {
        var keys = [].slice.call(arguments, 1)
        return input.map(function (item) {
          return Object.keys(item).reduce(function (resultkey) {
            if (~keys.indexOf(key)) {
              result[key] = item[key]
            }
            return result
          }, {})
        })
      }
    }
  }
})

You can also use helper functions inside array filtering:

jsonQuery('people[*:recentlyUpdated]', {
  data: data,
  locals: {
    recentlyUpdatedfunction (item) {
      return item.updatedAt < Date.now() - (30 * 24 * 60 * 60 * 1000)
    }
  }
})

Specifying context ('data', 'source', and 'parent' options) is good for databinding and working on a specific object and still keeping the big picture available.

var data = {
  styles: {
    bold: 'font-weight:strong',
    red: 'color: red'
  },
  paragraphs: [
    {content: "I am a red paragraph", style: 'red'},
    {content: "I am a bold paragraph", style: 'bold'},
  ],
}
 
var pageHtml = ''
data.paragraphs.forEach(function(paragraph){
  var style = jsonQuery('styles[{.style}]', {data: data, source: paragraph}).value
  var content = jsonQuery('.content', data: data, source: paragraph) // pretty pointless :) 
  pageHtml += "<p style='" + style "'>" + content + "</p>"
})

Params can be specified by passing in an array with the first param the query (with ? params) and subsequent params.

jsonQuery(['people[country=?]', 'NZ'])

MIT