How to check if a HTTP call ran?

· Sorted by Oldest

Siddhant B.
·
·
1.
If a HTTP call did not run, I want the formula to return false.
2.
If it ran and returned an error, I want it to return true.
3.
Otherwise, it should return the value of {{HTTP API}}?.eligible_for_processing - which returns either true or false.
I'm trying: !{{HTTP API}} ? false : {{HTTP API}}?.error ? true : {{HTTP API}}?.eligible_for_processing === false ? false : true which shows the below:
Channeled
APP
·
·
Here's how you can write a formula to check if an HTTP call ran: LBKS!{{HTTP API}} ? false : {{HTTP API}}?.error ? true : {{HTTP API}}?.eligible_for_processingLBKSThis formula works by: 1. First checking if the HTTP call exists (!{{HTTP API}}) 2. If it doesn't exist, returning false 3. If it exists but has an error, returning true 4. Otherwise, returning the value of eligible_for_processing If you're having issues with the formula, please copy and paste your complete JSON response from the HTTP call so I can help troubleshoot further.
Sources: HTTP API with Clay HTTP API integration overview | Documentation | Clay University
Siddhant B.
·
·
https://app.clay.com/workspaces/39601/workbooks/wb_rYi2eVkahgPD/tables/t_URRUd5qsFqS4/views/gv_gWkPGs3vGetn
Bo (.
·
·
Hey, You can use Clay.getCellStatus({{<Column Name> }}) to check the error code or status of a specific cell. Let me know if you need help with the setup.

Siddhant B.
·
·
1.
If a HTTP call did not run, I want the formula to return false.
2.
If it ran and returned an error, I want it to return true.
3.
Otherwise, it should return the value of {{HTTP API}}?.eligible_for_processing - which returns either true or false.
I'm trying: !{{HTTP API}} ? false : {{HTTP API}}?.error ? true : {{HTTP API}}?.eligible_for_processing === false ? false : true which shows the below:
Channeled
APP
·
·
Here's how you can write a formula to check if an HTTP call ran: LBKS!{{HTTP API}} ? false : {{HTTP API}}?.error ? true : {{HTTP API}}?.eligible_for_processingLBKSThis formula works by: 1. First checking if the HTTP call exists (!{{HTTP API}}) 2. If it doesn't exist, returning false 3. If it exists but has an error, returning true 4. Otherwise, returning the value of eligible_for_processing If you're having issues with the formula, please copy and paste your complete JSON response from the HTTP call so I can help troubleshoot further.
Sources: HTTP API with Clay HTTP API integration overview | Documentation | Clay University
Siddhant B.
·
·
https://app.clay.com/workspaces/39601/workbooks/wb_rYi2eVkahgPD/tables/t_URRUd5qsFqS4/views/gv_gWkPGs3vGetn
Bo (.
·
·
Hey, You can use Clay.getCellStatus({{<Column Name> }}) to check the error code or status of a specific cell. Let me know if you need help with the setup.