JSON: Get Value¶
Extracts a value from JSON data using a dot-separated key path. Supports nested objects and arrays (by numeric index). If the path cannot be resolved, the node returns the provided default value or null if none is provided.
Usage¶
Use this node when you need to pick a specific field from structured JSON data within a workflow. Provide the JSON (as an object, list, or JSON string) and a dot-separated path such as user.name or items.0.title to retrieve the desired value for branching logic, prompts, or downstream processing.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| json_data | True | WILDCARD | JSON data to read from. Can be a dictionary, list, or a JSON-formatted string. | {"user": {"name": "Ada", "age": 37}, "items": [{"title": "First"}]} |
| key_path | True | STRING | Dot-separated path to the target value. Use dot notation for nested keys and numeric segments for array indices. | items.0.title |
| default_value | False | WILDCARD | Value to return if the path is not found or cannot be resolved. | Unknown |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| value | WILDCARD | The value found at the specified path. Returns the default value (or null if none provided) when the path is invalid or not found. | First |
Important Notes¶
- Path format: Use dot-separated keys; use numeric segments to index arrays (e.g., "items.0.name").
- JSON input types: Accepts dicts, lists, or JSON strings. JSON strings are parsed before accessing.
- Empty path behavior: If key_path is empty, the entire json_data is returned.
- Missing path handling: If any segment is missing, out-of-range, or type-mismatched, the node returns default_value (or null if not provided).
- None values: If a resolved segment is None, the node returns default_value.
- Invalid JSON strings: If parsing json_data as a string fails, the node returns default_value.
Troubleshooting¶
- Got null instead of a value: Provide a default_value or verify the key_path matches your data structure exactly.
- Array index errors: Ensure array positions exist and use numeric indices in the path (e.g., "items.2").
- No output change: If key_path is empty, the node returns the original input. Provide a valid path to extract a specific field.
- JSON string not parsed: Confirm json_data is a valid JSON string. Invalid JSON returns the default_value.