What am I doing that no list is valid when writing to another table? It is in JSON format...
If your list is not being recognized as valid when writing to another table, it's likely due to JSON formatting issues. Here's how to fix it: 1. Make sure all text strings are properly enclosed in quotes
2. Remove any trailing commas at the end of lists or objects
3. For dynamic variables using /column
:
โข String values need quotation marks
โข Numbers should not have quotes (except for numbers with trailing zeros like "0004")
โข Boolean values should not have quotesTo verify your JSON formatting: ** Use a JSON validator like JSONLint to check your data structure
** You can also ask an LLM to help spot and fix JSON formatting issuesRemember that when formatting your request body: ** Correct: "name": "Sam"
** Correct: "age": 30
** Incorrect: name: Sam
(missing quotes)
** Incorrect: "age": "30"
(number with unnecessary quotes)
Sources:
FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?
HTTP API integration overview | Documentation | Clay University
HTTP API with JWT authentication | Documentation | Clay University
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.
Yes, and somehow it is still this: