JSON Flatten
This node flattens nested JSON objects into a single-level object using dot notation for nested keys.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| value | json | Yes | The JSON value to flatten |
| separator | string | No | Separator for nested keys (default: '.') |
| includeArrays | boolean | No | Whether to include array indices in flattened keys (default: true) |
Outputs
| Name | Type | Description |
|---|---|---|
| result | json | The flattened JSON object |
| keyCount | number | Number of keys in the flattened object |
| success | boolean | Whether the flattening was successful |
Related Nodes in Data Processing
JSON Extract String
Extract a string value from a JSON object using JSONPath
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
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.