Skip to content
Databraid Docs

JSONAta

The JSONataNode allows querying and transforming JSON data using the JSONata language. JSONata is a lightweight query and transformation language designed specifically for JSON.

Inputs

  • obj: The JSON object to be queried or transformed.
  • query: The JSONata query string to be applied to the input object.

Outputs

  • obj: The result of the JSONata query or transformation applied to the input object.

Properties

  • query: The JSONata query string. This can be set in the node’s properties or provided through the “query” input.

Usage

  1. Connect a JSON object to the “obj” input of the node.
  2. Provide a JSONata query string either through the “query” input or by setting it in the node’s properties.
  3. The node will apply the JSONata query to the input object and output the result through the “obj” output.
  4. The result can be connected to subsequent nodes for further processing.

JSONata Syntax

Refer to the JSONata documentation to learn about the syntax and capabilities of JSONata queries.

Error Handling

If an error occurs during the execution of the JSONata query, it will be logged to the console.