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 orde

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 parsingstatus 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 parsingstatus` node inside this workflow.
Download the workflow JSON file after purchase.
Open n8n โ click the menu โ Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.