Clay Icon
Join the Community
02 Support

Any ideas why the HTTP API sometimes works and sometimes doesn't with...

Any ideas why the HTTP API sometimes works and sometimes doesn't with this?

12 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    Hey Kevin! I'll take a look at the setup

  • Avatar of Kevin P.
    Kevin P.
    ·

    thank you arturo!

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    It appears that some of the inputs have additional quotation marks in the text. This was generated by chatGPT, correct? HTTP API is probably trying to parse that as another field and failing

    4970cc63-ccb8-4443-b0c3-c09646983771.png(6 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ·

    You can also use conditional formulas to remove them, let me know if you need help setting that up!

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    In case you're curious, this is the formula I would add to help clean that up: ​.replace(/"/g, '')​

  • Avatar of Kevin P.
    Kevin P.
    ·

    well i'd want to keep those

  • Avatar of Kevin P.
    Kevin P.
    ·

    they are quotes within an article

  • Avatar of Kevin P.
    Kevin P.
    ·

    how do i fix it when i need to keep quotes in the article?

  • Avatar of Clay Team
    Clay Team
    APP
    ·

    Good one! not sure what options we have for that. Keethu R., any ideas for that?

  • Avatar of Keethu R.
    Keethu R.
    ·

    HI Kevin P., just took a look at your table and seems like you've resolved this with your current setup - let me know if you run into any other issues!