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

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. The list view displays each JSONata expression as a card.
  2. The page shows:
    1. Breadcrumb - To navigate
    2. Search - Search for desired JSONata
    3. Help - To get the onscreen help
    4. Add
  3. Each expression card contains the following elements:
    1. JSON icon — A file-type badge identifying this asset as a JSONata expression.
    2. Name — The user-assigned name of the expression.
    3. Description — A summary describing the expression's purpose.
    4. Avatar icon — An indicator showing the creator or associated user for this expression.
    5. Chevron (>) — A navigation arrow indicating the card is selectable to open the expression settings.
  4. Select any expression card to open its settings, where you can edit the definition or update the name and description.
Image

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. Add buton is provided in the top-right corner of the JSONata list page
Image

  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 textarea 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.
  3. The system creates the expression and returns you to the JSONata list, where the new expression appears as a card.
Image

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.

Edit JSONata Expression Settings

Selecting a JSONata expression card 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.

Image

Edit Details

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

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. The system returns you to the JSONata list page, where the updated name and description reflect on the expression card.

Image

Edit Definition

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

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.

Image


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

    • 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

    • View Library

      View Library Click on the Library band. A list of libraries used for the selected enumeration will be listed on the screen. You can add or remove the libraries on this screen. To view the library details, click on the band. View Library Details Upon ...