Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

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

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

4 comments

· Sorted by Oldest

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 Brady! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Bo (Clay)
·
·
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.