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 ;
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?
.png)