Clay Icon

Troubleshooting Output Format: Avoiding JSON Errors

ยท
ยท

Hi, I'm trying to get output in normal text (not JSON) yet it keeps giving me error.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To get output in normal text instead of JSON, you'll need to disable the "Return as JSON Object" option in your settings. This is a simple toggle that determines whether your output will be structured as JSON or returned as plain text.When setting up your outputs, make sure to specify "Text" as your data type. This is the default format and will ensure your response comes back as regular text rather than a structured JSON object. Sources: Use AI - Clay University ChatGPT: Generate text with OpenAI/GPT

  • Avatar of Noor S.
    Noor S.
    ยท
    ยท

    Yes, that's already turned off.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    I'm glad to hear that's already taken care of. Is there anything else I can assist you with regarding our app?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

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

  • Avatar of Noor S.
    Noor S.
    ยท
    ยท

    The results are still giving error.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    If you're still getting a "failed to parse body" error, there are a few common formatting issues to check:1. Make sure all text strings are enclosed in double quotes 2. Check that your dynamic column references are properly formatted with quotes for string values 3. Verify there are no extra commas at the end of your JSON entries 4. Look for any hidden characters or extra spacesIf you need to combine plain text with dynamic column tags, first create a Formula column to combine them, then include that column (with quotes) in your body tag.For string values, even when using dynamic variables with /column, you must still follow JSON formatting rules and include quotation marks. However, for number values, don't use quotes unless you have numbers with leading zeros. Sources: HTTP API with JWT Authentication - Clay University HTTP API - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Tanvi R.
    Tanvi R.
    ยท
    ยท

    Hey there, thanks for reaching out! It looks like there might be an error with one of the inputs for your prompt. Do you mind sending the table URL so we can take a closer look?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.