Error: No Content Returned from Claygent - Handling with Fallback Fields

Used claygent to generate a JSON as an response. Now pulled the data out of the JSON, in a separate field. if I now use that data to build a sentence with a formula i get for the field, where the response from claygent was an error no content. because for those fields i wanted to use a fallback.

✅1

10 comments

Robin S.
·
·
https://app.clay.com/workspaces/9574/tables/t_wOBcOkWtKnsY/views/gv_xAJ23ZeGEJ6A
Robin S.
·
·
It’s about the “Message 1 - Final Sentence” column
Robin S.
·
·
an example what i mean is found in row 2 or 26
Clay Team
APP
·
·
Hey, thanks for reaching out, sorry for the delay! Taking a look
Clay Team
APP
·
·
It appears it's just trying to parse the JSON without checking if Claygent has a value or not, so to correct that the formula can be prompted to go step by step and make sure it checks it. I manually corrected the formula to check for that though, hope this helps :)
Robin S.
·
·
Thank you! but which formula did you correct? wanna understand what i did wrong 🙂
Clay Team
APP
·
·
Sorry for the delay, Robin! I'll try to record that for you
Clay Team
APP
·
·
In essence, since these columns had errors because of how they were trying to extract values, this is what I added to the formula, the highlighted text
41b177a5-1f27-4997-9151-366a2b50b345.png(54 kB)
Clay Team
APP
·
·
The logic is: 1. check if the value exists 2. if true then run the Json command 3. otherwise leave it empty
Robin S.
·
·
AAAAH! this makes sense. did you use AI to write this formula?