JSON Parse

The JSON Parse node parses a JSON string field into a structured array/object. Use it when a database column or API response stores JSON as a string that needs to be accessed as structured data.

Configuration

Property	Type	Default	Description
field	string	--	Required. The field containing the JSON string to parse.
outputField	string	_parsed	The field name where the parsed result is stored.

Input

Accepts a single object or an array of rows.

Output

Returns the same rows with an additional field (outputField) containing the parsed JSON data. If parsing fails, the field is set to null.

Example

Input:

[
  { "id": 1, "settings": "{\"theme\": \"dark\", \"lang\": \"en\"}" }
]

Config: field: "settings", outputField: "parsed_settings"

Output:

[
  {
    "id": 1,
    "settings": "{\"theme\": \"dark\", \"lang\": \"en\"}",
    "parsed_settings": { "theme": "dark", "lang": "en" }
  }
]

Example Use Cases

Parse configuration stored as JSON

field: "config_json"
outputField: "config"

Access in templates: { {row.config.theme}}, { {row.config.lang}}

Parse API response body

After an HTTP Request node returns raw JSON in a field:

field: "response_body"
outputField: "data"

Parse tags stored as JSON array

field: "tags_json"
outputField: "tags"

Then use join(row.tags, ', ') to display as a comma-separated list.

TIP

If you need to convert structured data back into a JSON string, use the JSON Stringify node.