View JSONata

View JSONata

Overview

JSONata is a lightweight yet powerful query and transformation language designed for JSON data. In OneEnterprise, the JSONata section of the Library allows you to create, manage, and reuse JSONata expressions across your integration designs. Rather than embedding complex data transformation logic inline within individual automation flows, you define named JSONata expressions once in the Library and reference them wherever needed — enabling consistency and maintainability at scale.
The JSONata Library is part of the broader Library module in OneEnterprise, which consolidates reusable assets such as enumerations, flows, objects, value mappings, and XSLT stylesheets. The JSONata section specifically addresses JSON-to-JSON transformations, making it the primary tool for reshaping, filtering, and computing over JSON payloads that move between connected systems.
Business and integration teams use the JSONata Library to standardize data transformation logic across connectors and automations. When a mapping expression changes — such as a field rename or a new calculation — you update it in one place, and every flow that references it inherits the change automatically.

Key Features:
  1. Reusable Expressions: Define JSONata expressions once and reference them across multiple designs without duplication.
  2. Built-in Expression Editor: Write and format JSONata syntax in a full-featured inline code editor with toolbar controls for undo, format, search, and replace.
  3. Named Definitions: Assign each expression a descriptive name and description so team members can easily discover and reuse transformations.
  4. Integrated with Designer: Expressions stored in the Library are immediately available inside the Automation Designer and other design tools.
  5. Full JSONata Support: Supports the complete JSONata specification, including path expressions, operators, built-in functions, conditionals, and user-defined lambda expressions.

Navigate to the JSONata Library

The JSONata Library is accessible from the main Library section in the OneEnterprise left navigation panel.
  1. Select Library in the left sidebar.
  2. The Library landing page displays all available library categories.
  3. Select JSONata to open the JSONata expression list.
  4. The Library landing page lists the following categories:
    1. Enumerations
    2. Flows
    3. JSONata
    4. Objects
    5. Value Mappings
    6. XSLT Stylesheets.
  5. Select the JSONata row to navigate into the JSONata section.


JSONata Expression List

The JSONata list page displays all JSONata expressions saved in the library. Each entry shows the expression name and description, giving you a quick overview of the available transformations.
  1. This provides the list of available JSONata Stylesheets.
  2. Review the list of existing JSONata stylesheets. Each row shows the JSONata icon, the stylesheet name, and its description.
  3. Use the search icon to filter the list by name or description when the list grows large.
  4. Select the band to open the JSONata detail page, where you can edit the definition or update the name and description.

Add a JSONata Expression

  1. To create a new JSONata expression in the Library, click on the Add button on the JSONata list page.
  2. A button is provided in the top-right corner of the JSONata list page.

  1. The Add form opens and contains the following fields:
    1. Name (Required) — A text input field for the expression's identifier. Enter a descriptive, unique name so team members can easily find and reference this expression in designs. Accepts free text.
    2. Description (Required) — A multi-line text area for documenting the expression's purpose, the data it transforms, and where it is used. Accepts up to 400 characters. The character counter displays the current count in the format "0 / 400".
  2. After completing both fields, select Save in the top-right corner.


  1. The system creates the expression and returns you to the JSONata list, where the new expression appears as a band.
Notes
Please note that OneEnterprise provides a basic structure for the JSONata stylesheet; you need to modify it as needed.


Delete a JSONata Expression

You can delete a JSONata expression directly from the list view. The delete action appears when you hover over an expression card.
  1. Hover over the expression card you want to remove on the JSONata list page.
  2. Select the Delete (trash can) icon that appears on the right side of the card.
Notes
Please note that deleting a JSONata expression is permanent. Ensure the expression is not referenced in any active designs before deleting it to avoid breaking existing automations.

  1. A confirmation pop-up will appear. Review the JASONata stylesheet name shown in the message.
  2. Select Yes to permanently remove the JSONata, or select No to cancel and return to the list.


Edit JSONata Expression Settings

  1. Selecting a JSONata expression band from the list opens the expression's settings page.



This page provides two options for managing the expression:
  1. On this screen, you can edit  any of the settings  by navigating into the row:
    1. Definition — The Definition screen contains the JSONata expression editor, where you write and edit the JSONata code that defines the transformation logic for this expression.
    2. Details — The Details screen allows you to update the name and description of an existing JSONata expression without modifying the expression code itself.


Edit Details

  1. Select a JSONata expression band from the list.
  2. Select Details from the expression settings page.


The Details form contains the following fields:
  1. Name (Required) — A text input pre-filled with the expression's current name. Update this field to rename the expression in the library.
  2. Description (Required) — A multi-line textarea pre-filled with the current description. The character counter shows the current length in the format "13 / 400". Accepts up to 400 characters.
Select Save to apply your changes.



Edit Definition

  1. Select a JSONata expression band from the list.
  2. Select Definition from the expression settings page.



The Definition editor provides a code editing environment with a toolbar and a line-numbered code area. The editor toolbar contains the following controls:
  1. Undo — Reverts the most recent change to the expression.
  2. Download — Downloads the current expression content as a file.
  3. Cut — Removes selected text and places it on the clipboard.
  4. Copy — Copies selected text to the clipboard.
  5. Paste — Inserts clipboard content at the cursor position.
  6. Search — Opens a search dialog to locate text within the expression.
  7. Replace — Opens a find-and-replace dialog for making bulk edits.
  8. Format — Auto-formats the JSONata expression for improved readability.
  9. Wrap — Toggles line wrapping within the editor.
  10. Aa (Font toggle) — Adjusts the editor font style.
  11. 16 (Font size) — Sets the editor font size (default: 16).
  12. Expand — Expands the editor to full screen.
  13. 4 (Indent width) — Sets the number of spaces used for indentation (default: 4).
The editor displays line numbers on the left margin. A new expression opens with the default content {} (an empty JSON object), ready for you to write your JSONata expression. Select Save in the top-right corner to save changes to the definition.



    • Related Articles

    • 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 ...

    • View XSLTs

      Overview The XSLT Stylesheet area within the OneEnterprise Library lets you create, view, edit, and delete reusable XSLT transformation scripts. XSLT (Extensible Stylesheet Language Transformations) stylesheets convert XML documents from one ...

    • Edit JSONata Unit

      Edit JSONata Unit

    • JSONata Unit

      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, ...

    • View Authentication

      View Authentication