Collecting Full JSON from Clay Table Columns with Escape Characters

Mike J. · 2025-11-05 15:51:57.982612+00

In a Clay table, does anyone know how to collect every column using . or a * character and put it in a JSON structure to pass the entire JSON structure as a string with all the required escape characters? I want the JSON structure to get past as a string with required escape parameters. Mostly from the enriched profile, and then email and phone # . thank you!

Collecting Full JSON from Clay Table Columns with Escape Characters | Clay

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
Clay doesn't support wildcard characters like . or * to collect all columns at once. However, you can reference entire enrichments using "Insert all properties" when setting up dynamic column references. [1]
For JSON formatting in HTTP API requests, you need to follow proper JSON syntax:
Strings must be enclosed in double quotes
When referencing dynamic columns, include quotes around the column tag for strings
Numbers don't need quotes unless they have trailing zeros [2]
Example JSON structure:
{ "profile": /enriched_profile_column, "email": "/email_column", "phone": "/phone_column" }
For proper escape characters, ensure keys are in double quotes and values follow JSON formatting rules. If you need to combine multiple columns, create a Formula column first, then reference it in your JSON body. [3]
Could you copy and paste your current JSON structure so I can help troubleshoot any specific formatting issues?
Clay Support
APP
·
·
If you still need help with formatting your JSON structure or handling escape characters, I’m here to assist. Would you like to share more details or your current JSON so we can troubleshoot together?
Hasnain R.
·
·
Clay formulas don’t support or to select all columns automatically you’ll need to manually combine each column with proper escaping in a formula or use an LLM enrichment to build the JSON string.
1
Clay Support
APP
·
·
You're correct - Clay doesn't support wildcard selection for all columns. You have two main options:
Manual Formula Approach: Create a Formula column combining each column with proper JSON escaping. Use "Insert all properties" for entire enrichments, then manually reference each column like:
{ "profile": /enriched_profile_column, "email": "/email_column", "phone": "/phone_column" }
LLM Enrichment: Use an AI enrichment to automatically build the JSON string from your data.
For proper JSON formatting, ensure keys are in double quotes and follow JSON syntax rules - strings need quotes around column tags, numbers don't unless they have trailing zeros.
Could you copy and paste your current JSON structure so I can help troubleshoot any specific formatting issues?
Clay Support
APP
·
·
If you still need assistance with formatting your JSON structure or combining columns, I’m here to help. Would you like to share your current JSON so we can look into it together?

Clay Support
APP
·
·
Clay doesn't support wildcard characters like . or * to collect all columns at once. However, you can reference entire enrichments using "Insert all properties" when setting up dynamic column references. [1]
For JSON formatting in HTTP API requests, you need to follow proper JSON syntax:
Strings must be enclosed in double quotes
When referencing dynamic columns, include quotes around the column tag for strings
Numbers don't need quotes unless they have trailing zeros [2]
Example JSON structure:
{ "profile": /enriched_profile_column, "email": "/email_column", "phone": "/phone_column" }
For proper escape characters, ensure keys are in double quotes and values follow JSON formatting rules. If you need to combine multiple columns, create a Formula column first, then reference it in your JSON body. [3]
Could you copy and paste your current JSON structure so I can help troubleshoot any specific formatting issues?
Clay Support
APP
·
·
If you still need help with formatting your JSON structure or handling escape characters, I’m here to assist. Would you like to share more details or your current JSON so we can troubleshoot together?
Hasnain R.
·
·
Clay formulas don’t support or to select all columns automatically you’ll need to manually combine each column with proper escaping in a formula or use an LLM enrichment to build the JSON string.
1
Clay Support
APP
·
·
You're correct - Clay doesn't support wildcard selection for all columns. You have two main options:
Manual Formula Approach: Create a Formula column combining each column with proper JSON escaping. Use "Insert all properties" for entire enrichments, then manually reference each column like:
{ "profile": /enriched_profile_column, "email": "/email_column", "phone": "/phone_column" }
LLM Enrichment: Use an AI enrichment to automatically build the JSON string from your data.
For proper JSON formatting, ensure keys are in double quotes and follow JSON syntax rules - strings need quotes around column tags, numbers don't unless they have trailing zeros.
Could you copy and paste your current JSON structure so I can help troubleshoot any specific formatting issues?
Clay Support
APP
·
·
If you still need assistance with formatting your JSON structure or combining columns, I’m here to help. Would you like to share your current JSON so we can look into it together?