Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

JSON Formatting Issue: Inconsistent Output Results | Clay

JSON Formatting Issue: Inconsistent Output Results

·Dec 03, 2024 09:31 AM·

Hey Team! I have an issue with formatting the output in JSON. Unfortuantly it doesn't give good result consistently. https://www.loom.com/share/3753eb6f362a44c1b7717b0ff60f614b ;

Video thumbnail

3 comments

· Sorted by Oldest

Channeled
APP
·
·
Here's how to fix JSON formatting issues in your output: 1. Always use double quotes around text strings and keys: • Correct: "name": "John" • Incorrect: name: John 2. Follow these JSON formatting rules: • Use quotes for string values • Leave numbers and booleans without quotes • For dynamic variables with trailing zeros (like "0004"), use quotes • Separate key-value pairs with commas 3. Troubleshooting tips: • Check for extra spaces, colons, and brackets • Remove any hidden characters by pasting into a text editor • Ensure all keys are properly separated by commas • If combining plain text with dynamic column tags, create a Formula column firstFor validation, you can use JSONLint (jsonlint.com) to check your formatting before implementation. Sources: HTTP API with JWT Authentication - Clay University HTTP API - Clay University FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
❤️1
Channeled
APP
·
·
Hi Marouane! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Marouane!