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?

· Sorted by Oldest

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 😉
Kevin P.
·
https://app.clay.com/workspaces/13479/tables/t_wA1QeObZYfnP/views/gv_0NiXlIjXwVSR
Clay Team
APP
·
Hey Kevin! I'll take a look at the setup
Kevin P.
·
thank you arturo!
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)
Clay Team
APP
·
You can also use conditional formulas to remove them, let me know if you need help setting that up!
Clay Team
APP
·
In case you're curious, this is the formula I would add to help clean that up: .replace(/"/g, '')
Kevin P.
·
well i'd want to keep those
Kevin P.
·
they are quotes within an article
Kevin P.
·
how do i fix it when i need to keep quotes in the article?
Clay Team
APP
·
Good one! not sure what options we have for that. Keethu R., any ideas for that?
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!

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 😉
Kevin P.
·
https://app.clay.com/workspaces/13479/tables/t_wA1QeObZYfnP/views/gv_0NiXlIjXwVSR
Clay Team
APP
·
Hey Kevin! I'll take a look at the setup
Kevin P.
·
thank you arturo!
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)
Clay Team
APP
·
You can also use conditional formulas to remove them, let me know if you need help setting that up!
Clay Team
APP
·
In case you're curious, this is the formula I would add to help clean that up: .replace(/"/g, '')
Kevin P.
·
well i'd want to keep those
Kevin P.
·
they are quotes within an article
Kevin P.
·
how do i fix it when i need to keep quotes in the article?
Clay Team
APP
·
Good one! not sure what options we have for that. Keethu R., any ideas for that?
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!