JSON Extract String
This node extracts a string value from a JSON object using JSONPath.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| json | json | Yes | The JSON object to extract the string from |
| path | string | Yes | The JSONPath expression (e.g., "$.user.profile.name" or "$.store.books[0].title") |
| defaultValue | string | No | Default value if no string value is found at the path |
Outputs
| Name | Type | Description |
|---|---|---|
| value | string | The extracted string value |
| found | boolean | Whether a string value was found at the specified path |
Related Nodes in Data Processing
JSON Extract Object
Extract a JSON 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.