Clay Icon

Troubleshooting JSON Format Issues When Writing to Tables

ยท
ยท

What am I doing that no list is valid when writing to another table? It is in JSON format...

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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

  • Avatar of Channeled
    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.

  • Avatar of Teal B.
    Teal B.
    ยท
    ยท

    Yes, and somehow it is still this: