Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Print JSON API Results in a Single Column Format | Clay

Print JSON API Results in a Single Column Format

·Nov 25, 2025 12:32 PM·

if I call an api i will get results in json. Is it possible to print out the entire json in a column, rather then adding each output as separate column

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! When you reference data from an API enrichment, you can choose to reference the entire enrichment which gives you access to all the JSON data at once in a single column.
Instead of creating individual child columns for each endpoint, you can select Insert all properties to reference the complete JSON response in one column. This keeps all your API results together rather than splitting them across multiple columns.
Since you mentioned JSON formatting, could you copy and paste your JSON structure into the chat so I can help troubleshoot any specific formatting needs?
Clay Support
APP
·
·
If you still need help with displaying the entire JSON in a single column or troubleshooting your JSON structure, I’m here to assist. Would you like to share more details or the JSON data you’re working with?
Batıkan E.
·
·
Mensur you can use the formula below
Clay.formatForJSON({{COLUMN_NAME_COMES_HERE}})
Clay Support
APP
·
·
Thanks for sharing that! Clay.formatForJSON() is a great function for formatting data as JSON. You can also reference the entire enrichment by selecting "Insert all properties" when referencing your API column, which gives you access to all the JSON data at once.
When working with JSON in Clay, make sure to follow proper formatting rules - string values need quotes around column references like "name": "/Name Column", while numbers don't need quotes.
Clay Support
APP
·
·
Is that explanation clear and helpful?
Clay Support
APP
·
·
If you need any more help with displaying or formatting your JSON data in a column, please let me know. Would you like to provide the JSON you’re working with so I can assist further?