Copy Columns with JSON Schema in Another Table: Need Help

Josh Fryszer · 2025-08-11 00:46:00.154507+00

*Copying Columns to Another Table with JSON Schema* I want to copy/use the Claygents I’ve built in another table. Before you ask, yes I’ve tried ‘Write to table’. However, it doesn’t allow me to select the column with the Claygent. Instead, it forces me to select the individual JSON schema outputs underneath instead (see attached). So in the below example, it doesn’t allow me to select ‘Decision Maker Name (2)’. Am I missing something?

Copy Columns with JSON Schema in Another Table: Need Help | Clay

Clay
APP
·
·
You're not missing anything - this is the expected behavior. When using write to table with Claygent columns that have JSON schema outputs, you must select the individual JSON schema properties rather than the entire column. To copy your Claygent data: 1. Use write to table and map the specific JSON schema outputs you need 2. Alternatively, reference the "entire enrichment" by selecting "Insert all properties" to access all data from that Claygent at once For JSON schema results, you can also click into the JSON result, select "Take action on list," and choose "Write each item to a new row in another table" if working with list data.
Sources: Write to Other Table | Documentation | Clay University Referencing dynamic data from other columns | Documentation | Clay University Enrich from Images and Screenshots - Clay University
Josh Fryszer
·
·
How/where do I select “Insert all properties”?
Clay
APP
·
·
The available documentation doesn't show the specific location of an "Insert all properties" option for Claygent JSON schema outputs. The sources focus on using write to table with individual JSON schema properties or using "Take action on list" to write each item to a new row. For JSON schema results, you can click into the JSON result, select "Take action on list," and choose "Write each item to a new row in another table" when working with list data. Are you looking to copy all JSON properties at once, or are you trying to map specific properties from your Claygent output to another table?
Sources: Enrich from Images and Screenshots - Clay University Enrich from Images and Screenshots - Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Josh Fryszer
·
·
Any guidance here Asher (Revenue Journey - Certified Clay Expert) Muhammad? 🙏
Clay
APP
·
·
To select "Insert all properties" for your Claygent JSON schema outputs: 1. Locate your Claygent column with the enrichment results 2. When referencing the data (like in write to table), select Insert all properties to reference the entire enrichment This gives you access to all data returned by the enrichment at once, rather than selecting individual JSON schema properties.
Source: Referencing dynamic data from other columns | Documentation | Clay University
Josh Fryszer
·
·
I see no where in the ‘Add other data from this table’ where I can select ‘Insert all properties’
Clay
APP
·
·
The "Insert all properties" option isn't available in the standard write to table interface for Claygent JSON schema outputs. You need to select individual JSON schema properties when mapping columns. For JSON schema results with lists, click into the JSON result, select "Take action on list," and choose "Write each item to a new row in another table" instead.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Enrich from Images and Screenshots - Clay University
Josh Fryszer
·
·
I don’t want all the schema results copied across as columns though. I simply want the claygment column (that the schema is built for).
Clay
APP
·
·
You can't copy the entire Claygent column with its JSON schema structure intact using write to table. The system requires selecting individual schema properties. To preserve your Claygent setup in another table, create child columns from the parent Claygent column: 1. Click on a cell in your Claygent column to open the Cell details panel 2. Hover over each endpoint you want and click "Add as column" 3. Create new columns for the specific outputs you need Then use write to table to copy these individual child columns to your destination table.
Sources: Table columns | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Josh Fryszer
·
·
No
Asher (Revenue Journey - Certified Clay Expert)
·
·
Hey Josh Fryszer , have to tried to output ‘Decision Maker 2’ as a separate field?
Josh Fryszer
·
·
No. Can you clarify how I’d do that Asher (Revenue Journey - Certified Clay Expert)?
Asher (Revenue Journey - Certified Clay Expert)
·
·
Josh Fryszer Actually, can you click into Decision Maker Name and roughly show me the fields you have in it?
Josh Fryszer
·
·
Loading attachments
Muhammad
·
·
Josh Fryszer I always output the data of the claygent in the array form even its one person this way its easier to push the whole array into another table without issues. Decision maker name (2) is an complex json object(containing arrays and individual keys), you are only allowed to write single columns via send data to table enrichment. You have to individually select the columns you want to push to other table OR output the data of claygent in the array structure which would be really easy to push, if you are unable to get the above huddle me directly and i will help you fix it.

20 comments