jsonutils

Description

Provides commands for extracting fields from json structures.

jsonutils provides a pair of commands for extracting fields from json data in _raw. jsonkv is smaller and faster, will use less memory and may work on incomplete or invalid json. jsonkvrecursive will parse the json and create a field for every value, including arrays, but will only work on valid json.

jsonkv

jsonkv uses regular expressions to pull field values from a given json.

Examples:

Given this json:

{
  "glossary": {
    "title":"example glossary",
    "ID":"SGML",
    "SortAs":"SGML",
    "GlossTerm":"Standard Generalized Markup Language",
    "Acronym":"SGML",
    "Abbrev":"ISO 8879:1986",
    "GlossDef": {
      "para":"A meta-markup language, used to create markup languages such as DocBook."
    },
    "GlossSee":"markup"
  }
}

jsonkv
will extract the following fields:
title="example glossary"
ID="SGML"
SortAs="SGML"
GlossTerm="Standard Generalized Markup Language"
Acronym="SGML"
Abbrev="ISO 8879:1986"
para="A meta-markup language, used to create markup languages such as DocBook."
GlossSee="markup"

jsonkvrecursive

jsonkvrecursive recursively builds fields from the field name hierarchy.

Examples:

Given this json:

{
  "glossary": {
  "title": "example glossary",
  "GlossDiv": {
    "title": "S",
    "GlossList": {
      "GlossEntry": {
        "ID": "SGML",
        "SortAs": "SGML",
        "GlossTerm": "Standard Generalized Markup Language",
        "Acronym": "SGML",
        "Abbrev": "ISO 8879:1986",
        "GlossDef": {
          "para": "A meta-markup language, used to create markup languages such as DocBook.",
          "GlossSeeAlso": ["GML", "XML"]
        },
        "GlossSee": "markup"
        }
      }
    }
  }
}