JSONata Unit

JSONata Unit

JSONata Unit Overview

  1. Purpose: The JSONata Unit is an action unit in the Flow Editor/Designer that enables a flow to query, transform, and manipulate JSON data using JSONata expression language. This unit lets you convert data without writing custom code, making it ideal for handling complex JSON structures.
  2. What it does:
    1. Applies JSONata expressions to: 
      1. Extract specific fields from JSON.
      2. Transform JSON into a new structure.
      3. Perform calculations or conditional logic on JSON data.
    2. Outputs the transformed JSON for the next step in the flow.
  3. How it works:
    1. Input: JSON data from a previous step (e.g., API response, document metadata).
    2. Expression: Define a JSONata expression (e.g., Account.Order.Product.(Price * Quantity)).
    3. Execution: The unit evaluates the expression against the input JSON.
    4. Output: Returns the transformed or filtered JSON.
  4. Use case:
    1. API Integration: Extract only required fields from a large JSON response.
    2. Data Mapping: Convert nested JSON into a flat structure for easier processing.
    3. Business Logic: Calculate totals or apply conditions within JSON data.
  5. Visual Representation:

    • Related Articles

    • Edit JSONata Unit

      Edit JSONata Unit

    • Edit JSONata Unit

      Overview The JSONata Unit is an action unit in the Flow Editor/Designer that enables a flow to query, transform, and manipulate JSON data using JSONata expression language. This unit lets you convert data without writing custom code, making it ideal ...

    • Edit XSLT Unit

      Edit XSLT Unit

    • Edit Database Unit

      Edit Database Unit

    • Edit Documents Unit

      Edit Documents Unit