is this a bug on Clay's end?
i already tried duplicating, but that didn't work for me either
how do i do that?
Hi Team, I am having an issue with my Clay table, can someone please take a look? Workspace/Table: https://app.clay.com/workspaces/542459/workbooks/wb_0szjcdiYiXyviEFZJqD/tables/t_0szji6wDejRxCCye8Rw/views/gv_0szji6wwfu6ycrh2Zwe Columns involved:
Hubspot Lead Creation API → returns the entire JSON wrapped in a single value field (desired).
Update Sureconnect HTTP API → returns individual key/value fields (problematic).
Configuration (both columns):
Field Paths to Return / Response values to return: empty for both columns.
Expected behavior (per docs/support guidance):
When “Field Paths to Return” is empty, Clay should return the entire JSON as a single value field.
When specific field paths are listed, Clay should return only those fields expanded.
Actual behavior:
Despite the setting being empty in both columns, one column returns value (desired), while the other expands all fields. This inconsistency is causing downstream JSON parsing issues.
Impact:
I forward Clay outputs through a Make.com webhook to my server. The differing shapes ({ "value": "<json>" } vs expanded fields) break parsing and require special casing.
Steps to reproduce:
Open the table (link above).
Compare outputs from Hubspot Lead Creation API and Update Sureconnect HTTP API columns.
Note that both have “Response values to return” empty, but their outputs differ as described.
What I need:
Confirmation whether this is a bug or if there is another setting that controls whether the response is wrapped in value vs expanded (e.g., a column-level toggle, response handling, content-type expectation, etc.).
Guidance on how to force both columns to consistently return the full response in a single value field.
Contact: murugan@zams.com Optional example (shape only):
Desired: { "value": "{...full JSON string...}" }
Current (problematic): { "company": "...", "domain": "...", ... }
Hi team, i am using a HTTP API column in my Clay table to send data back to my application in JSON format but running into the following error. I also added the JSON content type request header. However, the request doesn't seem to go to my backend. If I issue a curl with the same fields in my backend the request works. Can someone please take a look and help me find the issue?
Clay received a 403 error from the API with Content: <!DOCTYPE html><html lang="en-US"><head><title>Just a moment...</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=Edge"><meta name="robots" content="noindex,nofollow"><meta name="viewport" content="width=device-width,initial-scale=1"><style>*{box-sizing:border-box;margin:0;padding:0}html{line-height:1.15;-webkit-text-size-adjust:100%;color:#313131;font-family:system-ui,-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",Arial,"Noto Sans",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji"}body{display:flex;flex-direction:column;height:100vh;min-height:100vh}.main-content{margin:8rem auto;padding-left:1.5rem;max-width:60rem}@media (width <= 720px){.main-content{margin-top:4rem}}.h2{line-height:2.25rem;font-size:1.5rem;font-weight:500}@media (width <= 720px){.h2{line-height:1.5rem;font-size:1.25rem}}#challenge-error-text{background-image:url("data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIzMiIgaGVpZ2h0PSIzMiIgZmlsbD0ibm9uZSI+PHBhdGggZmlsbD0iI0IyMEYwMyIgZD0iTTE2IDNhMTMgMTMgMCAxIDAgMTMgMTNBMTMuMDE1IDEzLjAxNSAwIDAgMCAxNiAzbTAgMjRhMTEgMTEgMCAxIDEgMTEtMTEgMTEuMDEgMTEuMDEgMCAwIDEtMTEgMTEiLz48cGF0aCBmaWxsPSIjQjIwRjAzIiBkPSJNMTcuMDM4IDE4LjYxNUgxNC44N0wxNC41NjMgOS41aDIuNzgzem0tMS4wODQgMS40MjdxLjY2IDAgMS4wNTcuMzg4LjQwNy4zODkuNDA3Ljk5NCAwIC41OTYtLjQwNy45ODQtLjM5Ny4zOS0xLjA1Ny4zODktLjY1IDAtMS4wNTYtLjM4OS0uMzk4LS4zODktLjM5OC0uOTg0IDAtLjU5Ny4zOTgtLjk4NS40MDYtLjM5NyAxLjA1Ni0uMzk3Ii8+PC9zdmc+");background-repeat:no-repeat;background-size:contain;padding-left:34px}@media (prefers-color-scheme: dark){body{background-color:#222;color:#d9d9d9}}</style><meta http-equiv="refresh" content="360"></head><body><div class="main-wrapper" role="main"><div class="main-content"><noscript><div class="h2"><span id="challenge-error-text">Enable JavaScript and cookies to continue</span></div></noscript></div></div><script>(function(){window._cf_chl_opt = {cvId: '3',cZone: 'dev3-api.zams.com',cType: 'managed',cRay: '9667e5b0aa557000',cH: 'slX.vh17Sw.e0IwK.ANdAnAxZf6gNeBKculaCVARbPI-1753742625-1.2.1.1-2.i7lTrECeJm_q9nea1OaMqtqESav9mL4X.88LnFhbA9WdwP8yTW.ZK8SHLB397K',cUPMDTk:"/api/clay/webhook/test?__cf_chl_tk=pZSTL_K1MWYPuH70QvjkEwroHAXIyazM1bkLRC2l158-1753742625-1.0.1.1-l5NWkMqbkvFK0bThIomDuCFdj.RcqNSPQ3NnEDMjvgw",cFPWv: 'b',cITimeS: '1753742625',cTplC:0,cTplV:5,cTplB: 'cf',fa:"/api/clay/webhook/test?_cf_chl_f_tk=pZSTL_K1MWYPuH70QvjkEwroHAXIyazM1bkLRC2l158-1753742625-1.0.1.1-l5NWkMqbkvFK0bThIomDuCFdj.RcqNSPQ3NnEDMjvgw",md: 'zJbv7dE9v9D0ESkJ59B7kTMc95AtSz3G8pOXG6g5EmQ-1753742625-1.2.1.1-XKz3NcCZ9mt7P1XdKcAkcZSkxcHWCkBTj_qfMss7CG7cpzYh3TeKMcPSwx9d8nii50Nje5TzAxZdEDR.JTn9o5Dxdpu8yY8HOJMpFkQ0vElRl4cyVwvJxBTJlyVhGDYc1.TYP.qjOT7iQ8xmBrCyGzQqgVoOleP0Z0ff8fziYRXYcc6flGLqwBMXXXYXtKiqrKQ74I8Vsikw9sQvI1G_prNM_gi5Ezemdc3f5HT3qvsrU8HBrwWaHmrscsaYrAGCmz5a6.Ao2L.ojjzNUd2dJIr1oE_hGDSYf.aqtDL6zakBXhKST4w2GLrNRw0ycBW4Ia.lwccBoZOL_M3b5ZyT0af836cf8gdAd9L2aSq251Vo2Ps6TWUQgcOk1FLX3tO.dCHOqY7FHPW1csRa_yTUlWmp9RPw.S3Hw_4niW7dGVmRBNZH1tU4nASXt_pa3Jln6bw.MFi6Hstb2t.sT8Lw41WRVyAnLwdcCTfvJ69gRuoddZH.p0ciXLmhM_cTMoHMo4svYq3mxNaNfbbr6D9sFmYxw4VwCdyM0azQL0i9DiyuKP7h0KEGITielY16l9BEQcKErVeHGNerzuGPI0cbekMxFRJ9Kg.AesFLMUFAYbBU1uC.ZEvBw_tUfobT7bo8hq2y1oAglUErIxdabd0f8GoAt37o05Qh6VeRphu292teLAJUcAfrxWXNSKj5Kke8BHIdMDxTSsfSSOwauzUIzNzei.kGvy9jc0M156KzuxDWdHOnZ7Ix.1KIxhVDEXAMD9BWnErv.Ka5TBE9nKAxzf5JrA32xM4prt9f.zkLSjVa.kSfaL4_0169oezs7RsCRs6YYlXaK1IGp5V6Hbq5hWJ3yzBxZvCMbJOwlNU9eNVYs6aQpuDBoP2O0GSjFYj5w5up7V8mvEiwSVKk3obo6GyVQzGYh79gze7RNhtW.5EIteliVB4kn0o1E9BYoX.a4lV5ysZhD0fJ00BEEZ5D3POpI5jgPArfQUP_C6Iv7zczjESUmdiKvAioL8YxyrId9myWsSB3qbkYUZRHV44zTbzAVjhQlDb.ZOmqprzmV1kq7QYQIexq3w66KiL2mR34kEUF3CxfhJ1.Mjf_S6Y9mJi.jALTDK3YN5dbH3nEuvE.f7lFWIAQpnVfj2FyYiyD_cy5TlVoDHRFtoQsRNA...Y_UBYCKFgyLSJjRdf.ec',mdrd: '',};var a = document.createElement('script');a.src = '/cdn-cgi/challenge-platform/h/b/orchestrate/chl_page/v1?ray=9667e5b0aa557000';window._cf_chl_opt.cOgUHash = location.hash === '' && location.href.indexOf('#') !== -1 ? '#' : location.hash;window._cf_chl_opt.cOgUQuery = location.search === '' && location.href.slice(0, location.href.length - window._cf_chl_opt.cOgUHash.length).indexOf('?') !== -1 ? '?' : location.search;if (window.history && window.history.replaceState) {var ogU = location.pathname + window._cf_chl_opt.cOgUQuery + window._cf_chl_opt.cOgUHash;history.replaceState(null, null,"/api/clay/webhook/test?__cf_chl_rt_tk=pZSTL_K1MWYPuH70QvjkEwroHAXIyazM1bkLRC2l158-1753742625-1.0.1.1-l5NWkMqbkvFK0bThIomDuCFdj.RcqNSPQ3NnEDMjvgw"+ window._cf_chl_opt.cOgUHash);a.onload = function() {history.replaceState(null, null, ogU);}}document.getElementsByTagName('head')[0].appendChild(a);}());</script></body></html>