This is old code. Use spath.

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"
        }
      }
    }
  }
}

produces:
glossary_title="example glossary" glossary_GlossDiv_title="S" glossary_GlossDiv_GlossList_GlossEntry_ID="SGML" glossary_GlossDiv_GlossList_GlossEntry_SortAs="SGML" glossary_GlossDiv_GlossList_GlossEntry_GlossTerm="Standard Generalized Markup Language" glossary_GlossDiv_GlossList_GlossEntry_Acronym="SGML" glossary_GlossDiv_GlossList_GlossEntry_Abbrev="ISO 8879:1986" glossary_GlossDiv_GlossList_GlossEntry_GlossDef_para="A meta-markup language, used to create markup languages such as DocBook." glossary_GlossDiv_GlossList_GlossEntry_GlossDef_GlossSeeAlso=["GML","XML"] glossary_GlossDiv_GlossList_GlossEntry_GlossSee="markup"

jsonutils

3