Process AI Output to Structured JSON with Robust JSON Parser

### How it works This workflow is a robust and forgiving JSON parser designed to handle malformed or dirty JSON strings often returned by AI models or scraped from web pages. It takes a text string as input and attempts to extract and parse a valid JSON object from it. 1. **Cleans Input:** It starts by trimming whitespace and removing common Markdown code fences (like ```json) that might wrap the JSON. 2. **Applies Multiple Fixes:** It systematically attempts to correct common JSON errors in a specific order: - Escapes unescaped control characters (like newlines) within strings. - Fixes invalid backslash escape sequences. - Removes trailing commas. - Intelligently attempts to fix unescaped double quotes inside string values. 3. **Parses Strategically:** If a direct parse fails, it tries to extract a potential JSON object from the text (e.g., finding a `{...}` block inside a larger sentence) and then re-applies the cleaning logic to that extracted portion. 4. **Outputs Clean Data:** If successful, it outputs the parsed JSON fields. By default, it removes the detailed `parsing_status` object, but you can deactivate the final Set node to keep it for debugging. ### Set up steps **Setup time: ~1 minute** This workflow is designed to be used as a sub-workflow and requires no internal setup. 1. In your main workflow, add an **Execute Sub-Workflow** node where you need to parse a messy JSON string. 2. In the **Workflow** parameter, select this Robust JSON Parser workflow. 3. Ensure the data you send to the node is a JSON object containing a `text` field, where the value of `text` is the string you want to parse. For example: `{ "text": {"\\key\\": "\\some broken json...\\} }`. 4. The workflow will return the successfully parsed data. To see a detailed log of the cleaning process, simply deactivate the final `Remove parsing_status` node inside this workflow.

Platform

n8n

Category

AI

Price

Free

Creator

Lucas Peyrin

• set
• code
• stickyNote
• executeWorkflowTrigger