JSON Kit

This kit contains the following nodes:

Link

schemish

Converts a given JSON schema to Schemish

Link

validateJson

Validates given JSON against a given JSON Schema.

Link

jsonata

Use this node to execute JSONata expressions. JSONata is a versatile JSON query language.

Link

Example

If we send the following inputs to jsonata:

{
  "expression": "$join(items.snippet, '\n')",
  "json": {
    "items": [
      {
        "snippet": "Question: How old is planet Earth?"
      },
      {
        "snippet": "Thought: I wonder how old planet Earth is?"
      }
    ]
  }
}

We will get this output:

{
  "result": "Question: How old is planet Earth?\nThought: I wonder how old planet Earth is?"
}

Link

Inputs

• expression -- required, a string that contains the JSONata expression to be executed.
• raw -- an optional boolean that specifies whether the result of the expression should be passed as-is (true), or it should be passed as the result output property (false, default).
• json -- an optional JSON object that will be used as the context for the expression. If json is not specified, the node will use the input property bag (minus expression and raw) as the context.

Link

Outputs:

• result -- the result of the expression, unless raw is true. In the latter case, the result is passed as-is.

Link

Implementation:

• jsonata.ts

Link

The xmlToJson node

Use this node to convert XML to JSON. Most nodes in the starter kit are designed to work with JSON, so this node is useful when you have XML data.

This nodes takes one required xml property, which it treats as XML and converts to it to JSON as the json output property. The format of JSON follows the alt-json convention that is described in https://developers.google.com/gdata/docs/json.

Link

Example

If we send the following inputs to xml-to-json:

{
  "xml": "<root><question>How old is planet Earth?</question><thought>I wonder how old planet Earth is?</thought></root>"
}

We will get this output:

{
  "json": {
    "root": {
      "question": { "$t": "How old is planet Earth?" },
      "thought": { "$t": "I wonder how old planet Earth is?" }
    }
  }
}

Link

Inputs:

• xml - required, must contain a string that represents XML.

Link

Outputs:

• json - the result of converting XML to JSON.

Link

Implementation:

• xml-to-json.ts