Clay Icon

Troubleshooting Failed to Create Column in HTTP/API Integration

Ā·
Ā·

Hi Im trying to create an HTTP/API integration but I'm receiving a "failed to create column" message and I don't know why

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    The 'failed to create column' error is typically related to incorrect JSON formatting in your HTTP API request body. Here's how to fix it:1. Ensure all text strings are enclosed in quotation marks 2. Remove any trailing commas at the end of your JSON objects 3. Check that your JSON structure follows this format: ```

    { "name": "John", "age": 30 } ```

    If you're still having trouble, you can: ā€¢ Use a JSON validator like JSONLint to check your formatting ā€¢ Ask an LLM to help identify and fix JSON formatting issues Source: FAQ: Why am I seeing the "failed to parse body" error when using the HTTP API enrichment?

  • Avatar of Franco L.
    Franco L.
    Ā·
    Ā·

    I don't have a body

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    If you're setting up an HTTP API integration without a request body, here's what you should check:1. Verify your HTTP method selection (GET, POST, or PUT) matches your API documentation requirements. 2. Double-check these essential components: ā€¢ Confirm your endpoint URL is correct ā€¢ Ensure all required headers are properly formatted ā€¢ Verify any query parameters are correctly structured 3. If you're using dynamic variables: ā€¢ Make sure string values are enclosed in quotes ā€¢ Numbers should not be in quotes (except for numbers with trailing zeros) ā€¢ Remove any extra spaces or commas ā€¢ Check for any hidden characters that might have been copied overIf you're still having issues, you can click on "Talk to a person" to get help from our support team. 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?

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Hi Franco L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: