Plug Database icon

Plug Database

Run Plug Database commands over REST or Socket.

Tools → Transform JSON

AI-generated

Summary

Transform JSON input data using a user-defined JSONata expression and store the transformation result in a specified JSON property.

Inputs

  • Tool Category — Choose the group of tools to use, defaulting to 'documents' but can be set to categories like 'data', 'security', or others.
  • JSONata Expression (required) — A JSONata expression string used to transform the input JSON data. Defaults to '$', which returns the input as is.
  • Output JSON Property — The name of the JSON property where the transformed result will be stored in the output. Defaults to 'result'.

Output shape

a JSON object containing the original input data with an additional property (default 'result') where the JSONata-transformed output is stored

The output JSON will include the result of the JSONata expression under the specified property. If the expression is invalid or evaluation fails, the node will error for that item.

Links

Discussion