How to check if a HTTP call ran?
If a HTTP call did not run, I want the formula to return false.
If it ran and returned an error, I want it to return true.
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:
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_processingLBKS
This 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.
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.