Displaying 'status' Value from CLAY HTTP API in Cells

👋 Hello, team! I have a question about the CLAY HTTP API The endpoint I am using returns a json with body containing 'status' field and some other data. is it possible to display the 'status' value instead of the HTTP status code (i.e 200 or some other one) in the cell where the HTTP API is called?

9 comments

Channeled
APP
·
·
Yes, you can display specific fields from the API response using the "Field Paths to Return" option. If your API response contains a 'status' field, you can enter "status" in the Field Paths to Return input to display only that value. For nested fields, use dot notation (e.g., "response.status").
Sources: HTTP API with Clay HTTP API with JWT authentication | Documentation | Clay University
Mykola M.
·
·
if I add 'status' in the "Field Paths to Return" the cell would contain the 'status' value but at the top level it still shows me the HTTP status code (200)
Channeled
APP
·
·
The "Field Paths to Return" option in the HTTP API column only filters which fields are displayed from the response body, but it doesn't affect the HTTP status code display. The HTTP status code (like 200) is a standard part of the HTTP response metadata and will always be shown at the top level of the cell. You can still access specific response fields like 'status' from the response body by entering the appropriate field path in the "Field Paths to Return" input.
Sources: HTTP API with Clay HTTP API integration overview | Documentation | Clay University
Mykola M.
·
·
so, there is no way to stop showing the HTTP status code at the top level?
Daniel K.
·
·
Hey there, thanks for reaching out! 😊 Yes, absolutely! You can either map it out in a new column or create an AI formula column to return a specific value if the status is 200, for instance. Here’s a video guide that walks you through the process: AI Formulas & Conditional Runs. Note: However, you cannot change the display of the HTTP status code on the UI. Hope this helps! Let me know if you have any questions.
Mykola M.
·
·
Hi Daniel, thank you for the info!
Channeled
APP
·
·
Thank you so much for sharing your feedback Mykola M.!
Bo (.
·
·
Hey — just a heads-up that you can now reference HTTP API status codes directly in formulas! Thought you’d be into that one.
(318 kB)
(182 kB)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Displaying 'status' Value from CLAY HTTP API in Cells | Clay