JSONata modules

The Adobe Workfront Fusion JSONata connector allows you to query JSON objects. This module does not require a connection.

Access requirements

Expand to view access requirements for the functionality in this article.
table 0-row-2 1-row-2 2-row-2 layout-auto html-authored no-header
Adobe Workfront package

Any Adobe Workfront Workflow package and any Adobe Workfront Automation and Integration package

Workfront Ultimate

Workfront Prime and Select packages, with an additional purchase of Workfront Fusion.

Adobe Workfront licenses

Standard

Work or higher

Product If your organization has a Select or Prime Workfront package that does not include Workfront Automation and Integration, your organization must purchase Adobe Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

JSONata modules and their fields

Evaluate

This action module queries a JSON object and returns an array.

Expression
Enter the expression that you want to use to evaluate the JSON object.
Data
Enter the JSON object to evaluate.
Stringify output
Enable this option to convert output to a string.
recommendation-more-help

Example:

The goal is to return an array of names from the following JSON object:

{
  "people": [
    { "name": "Alice", "age": 30 },
    { "name": "Bob", "age": 25 },
    { "name": "Charlie", "age": 35 }
  ]
}
  1. In the expression field, enter people.name.
  2. In the data field, enter the JSON object.

The module returns an array of names pulled from the JSON object.

JSONata MCP

This action module generates JSONata expressions by analyzing the specified input and output schemas. You provide the schemas, which Model Context Protocol (MCP) uses to generate the expression that transforms the input to the output.

Connection

Select the connection that you use to connect to the large language model (LLM) that you want to use for this module.

Currently, only the Anthropic API key is supported.

Input schema
Enter or map the input schema to use for this expression.
Output schema
Enter or map the output schema to use for this expression.
7e1891ad-4d59-4355-88ab-a2e62ed7d1a3