🛠️ 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 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.