👋 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?
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").
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)
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.
so, there is no way to stop showing the HTTP status code at the top level?
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.
Hi Daniel, thank you for the info!