Trigger Column Based on HTTP Status Code in HubSpot Search

Jocelyn R. · 2025-12-09T17:20:24.557Z

Hi every one, I guess I have a pretty simple issue but I'm not able to find the answer... I would like to trigger a column only if a previous HTTP request (Clay HTTP API) from another column has run successfully... I can see "Status Code: 200" or "Error" but I don't know how to use this information : What should I write in the "Only run if" section of my other column to run it only if "Status Code = 200" in HUBSPOT_SEARCH column Thank you a lot for your help

Trigger Column Based on HTTP Status Code in HubSpot Search | Clay

15 comments

· Sorted by Oldest

Clay Support
APP
·
·
In your column's Run Settings, go to the "Only run if" section and use this formula:
{{HUBSPOT_SEARCH}} contains "Status Code: 200"
This will only run the column when your HUBSPOT_SEARCH column shows a successful 200 status code. [1]
Pro tip: You can also click "Use AI" in the Run Settings and type something like "Only run if /HUBSPOT_SEARCH contains Status Code 200" - it'll generate the formula for you. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with setting up your conditional run based on the status code, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other questions you have?
Jocelyn R.
·
·
Nope. I can't write this, it's not a correct formula. Plus I have other conditions I didn't mention for simplicity but it should be written after '&&’
Clay Support
APP
·
·
I understand this can be frustrating. I’ll connect you to one of our human agents who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Amit K.
·
·
Hey Jocelyn- thanks for reaching out! 200 means that the HTTP API request was successful. Error means that the request failed. So if you want to edit a run condition in a different column, I would suggest doing it where {HTTP API column} has results.
Jocelyn R.
·
·
Hi Amit ! Thank you for your help but unfortunately my HTTP request can be successful without result 😕
Amit K.
·
·
Ah I see- then set the run condition to be that the output is 200 or "not null".
Amit K.
·
·
This should handle the edge case!
Vinit
·
·
Jocelyn R. you can create a formula in another colum where you basically ask run only if HTTP API column is not empty.... that means if you get 200 status code... you will have data and if you have data then another column will run otherwise it will not run. Make sense?
Mayato (.
·
·
Hi Jocelyn, thank you for reaching out. One option is to use a formula like Clay.getCellStatus({field id}) and set that result as your run condition. If you need more help, feel free to share your Clay table URL and we’ll take a closer look. Thank you!
Jocelyn R.
·
·
Mayato (. Thank you, I'll have a look at this feature feature but I have already reached the maximum number of columns for a table ^^ To clarify my problem, 4 states are possible for my first query column :
Not run yet, returns nothing
Ran with error, returns nothing
Ran with success (200) but found nothing, returns nothing
Ran with success (200) and found something, returns an object
Vinit and Amit K. the problem with your solutions is the 3rd state... The column can be empty even if the request has been successful
Sayli G.
·
·
Hello Jocelyn! Thanks for reaching out! Can you send your table link URL? Would like to take a look!
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Clay Support
APP
·
·
In your column's Run Settings, go to the "Only run if" section and use this formula:
{{HUBSPOT_SEARCH}} contains "Status Code: 200"
This will only run the column when your HUBSPOT_SEARCH column shows a successful 200 status code. [1]
Pro tip: You can also click "Use AI" in the Run Settings and type something like "Only run if /HUBSPOT_SEARCH contains Status Code 200" - it'll generate the formula for you. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with setting up your conditional run based on the status code, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other questions you have?
Jocelyn R.
·
·
Nope. I can't write this, it's not a correct formula. Plus I have other conditions I didn't mention for simplicity but it should be written after '&&’
Clay Support
APP
·
·
I understand this can be frustrating. I’ll connect you to one of our human agents who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Amit K.
·
·
Hey Jocelyn- thanks for reaching out! 200 means that the HTTP API request was successful. Error means that the request failed. So if you want to edit a run condition in a different column, I would suggest doing it where {HTTP API column} has results.
Jocelyn R.
·
·
Hi Amit ! Thank you for your help but unfortunately my HTTP request can be successful without result 😕
Amit K.
·
·
Ah I see- then set the run condition to be that the output is 200 or "not null".
Amit K.
·
·
This should handle the edge case!
Vinit
·
·
Jocelyn R. you can create a formula in another colum where you basically ask run only if HTTP API column is not empty.... that means if you get 200 status code... you will have data and if you have data then another column will run otherwise it will not run. Make sense?
Mayato (.
·
·
Hi Jocelyn, thank you for reaching out. One option is to use a formula like Clay.getCellStatus({field id}) and set that result as your run condition. If you need more help, feel free to share your Clay table URL and we’ll take a closer look. Thank you!
Jocelyn R.
·
·
Mayato (. Thank you, I'll have a look at this feature feature but I have already reached the maximum number of columns for a table ^^ To clarify my problem, 4 states are possible for my first query column :
Not run yet, returns nothing
Ran with error, returns nothing
Ran with success (200) but found nothing, returns nothing
Ran with success (200) and found something, returns an object
Vinit and Amit K. the problem with your solutions is the 3rd state... The column can be empty even if the request has been successful
Sayli G.
·
·
Hello Jocelyn! Thanks for reaching out! Can you send your table link URL? Would like to take a look!
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!