Troubleshooting JSON Error in LI Company API Column Parsing Issue | Clay

Troubleshooting JSON Error in LI Company API Column Parsing Issue

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

4 comments

Channeled
APP
·
·
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?
Channeled
APP
·
·
Hi Steven B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Bo (.
·
·
Hey, thanks for reaching out. Looks like that was fixed, right? I can't see any errors anymore :)
Channeled
APP
·
·
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.