Overview
The Data Extract node is a powerful data transformation node that extracts and transforms data from any input type using JSONata expressions. This node serves as a versatile data manipulation tool that enables users to pull specific fields, reshape data structures, apply filters, and perform lightweight calculations without requiring custom code.
The node accepts any data type as input and uses the JSONata query language to perform sophisticated data operations including field extraction, array manipulation, conditional logic, and aggregations. With configurable output types (Text, JSON object, Number, Boolean), it provides precise control over the resulting data format. This makes it essential for workflows that need to process complex data structures, extract specific information from API responses, or prepare data for downstream nodes with specific input requirements.
Node Specification
Core Properties
| Property |
Value |
| Node Type |
Data extraction |
| Category |
Data flow |
Parameters
| Parameter |
Type |
Options |
Default |
Required |
Description |
| JSONata expression |
Code (JSONata) |
— |
— |
Yes |
JSONata expression to extract/transform data (e.g., value.service.displayName, data[0], $sum(items.price)). |
| Output type |
Choice |
Text, JSON object, Number, Boolean |
Text |
Yes |
Determines the output port’s data type and validation. |
Input Ports
| Port |
Type |
Accepts |
Required |
Description |
| Data |
Any |
All types |
Yes |
Input data to query using the JSONata expression. |
Output Ports
| Port |
Type |
Description |
| Result |
Text/JSON object/Number/Boolean |
Result of the JSONata expression; type set by Output type. |
Process Flow Exits
| Exit |
Condition |
Description |
| Main exit |
On completion |
Continues process flow after extraction. |
Common Flows
Parameter Field Extraction
Launch Parameters → Data Extract (JSONata field query) → Text/Number Output
Extracts specific fields from parameter objects for downstream configuration
Data Structure Transformation
Complex JSON → Data Extract (object restructuring) → JSON Output