https://app.clay.com/workspaces/135137/tables/t_3PtwTXM5cTc5/views/gv_s4DFPx5RChXY can’t figure out what JSON error is causing “Failed to parse body input” in “LI Company API” column. have tried as formula and text and keep getting issues, despite using exact same JSON for other tables and working fine
The "Failed to parse body" error occurs when there's an issue with JSON formatting in your Body section. Here are the key things to check:1. Ensure all text strings and keys are enclosed in double quotes 2. Check that values are properly formatted: • Strings need quotes (e.g., "name": "John") • Numbers and booleans don't need quotes (e.g., "age": 30) • Exception: Numbers with leading zeros need quotes 3. Look for common formatting issues: • Remove any trailing commas • Check for proper spacing and colons • Watch for hidden charactersTry pasting your JSON into a validator like JSONLint to spot any formatting issues. If you're using dynamic column references (/column), make sure they follow the same formatting rules - strings need quotes, numbers don't. Sources: HTTP API integration overview | Clay University FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
Hey, thanks for reaching out. Looks like that was fixed, right? I can't see any errors anymore :)
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.