JSON Extract Object
This node extracts a JSON object or array from a JSON structure using JSONPath expressions.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| json | json | Yes | The JSON object to extract from |
| path | string | Yes | The JSONPath expression (e.g., "$.user.profile" or "$.store.books[*]") |
| defaultValue | json | No | Default value if no JSON value is found at the path |
Outputs
| Name | Type | Description |
|---|---|---|
| value | json | The extracted JSON value |
| found | boolean | Whether a JSON value was found at the specified path |
Related Nodes in Data Processing
JSON Extract String
Extract a string value from a JSON object using JSONPath
JSON Merge
Merge multiple JSON objects
JSON Template
Create a JSON object using a template with variable injection using ${variableName} syntax
JSON Flatten
Flatten nested JSON structure into a flat object with dot notation
CSV Parse
Parse a CSV string into a Table with schema and data
CSV Stringify
Convert a Table with schema and data into a CSV string
CSV Extract Column
Extract all values from a specific column in a Table
CSV Filter Rows
Filter rows in a Table based on a column value condition
Regex Extract
Extract all matches of a regular expression pattern from a string.
Regex Replace
Replace all matches of a regular expression pattern in a string.
Regex Match
Test if a string matches a regular expression pattern.
String Concat
Concatenate multiple strings together
Calculator
Evaluates mathematical expressions with support for arithmetic, functions, and constants.