Unable to Access Person Enrich Column in Database

Mensur · 2025-11-13 09:10:39.121178+00

I can not access the column Person Enrich, it is impossible to find when i try to search for the column.

Unable to Access Person Enrich Column in Database | Clay

12 comments

· Sorted by Oldest

Clay Support
APP
·
·
It looks like your "Person Enrich" column might be hidden or collapsed. Try clicking the Columns button at the top of your table to see all available columns.
You can toggle the visibility of any column using the switches next to each column name, or click "Show all columns" to display everything.
If it's a child column from a parent enrichment, you might need to click on the parent column header and select "Go to parent column" to find the original enrichment.
Clay Support
APP
·
·
Was that helpful?
Tanay M.
·
·
Mensur you might want to create columns out of the “Status Code:200” column and map data out explicitly into new columns. From there you should be able to reference them in the http body request
Clay Support
APP
·
·
You can create new columns from your enrichment data by clicking Add column at the right of your table.
To extract specific data from your enrichment results:
1.
Click the enriched column header
2.
Select Insert right or Insert left to add a new column
3.
Choose your data type and use formulas to reference specific fields from the parent enrichment
You can also use Merge columns to combine data from multiple sources into new columns that you can then reference in your HTTP requests.
If you need to see all available columns, click the Columns button to show/hide specific columns.
Clay Support
APP
·
·
Is that what you were looking for?
Mensur
·
·
Tanay M. i have a huge json, that will fill my entire clay table. I really want just pull the data from json.
Clay Support
APP
·
·
You can filter your JSON response to pull only specific data using the "Field Paths to Return" option in your HTTP API setup.
Use dot notation to specify exactly which fields you want (e.g., object1.object2.name). Separate multiple field paths with commas. This prevents the huge JSON from filling your entire table by returning only the data you need.
Alternatively, use our "Extract Values from Data" integration to pull specific information from your JSON after it's received.
Can you copy and paste your JSON structure so I can help you identify the exact field paths to use?
Mensur
·
·
Found the issue. you can not reference to a column if it's grouped. Seems like a bug for sure. As soon i removed the group i could find the column. Tanay M.
1
Clay Support
APP
·
·
Thanks for figuring that out! You're right - grouped columns can interfere with referencing data from other columns. When columns are grouped, it can make it harder to access individual column data for referencing purposes.
Ungrouping the columns should resolve the issue and allow you to properly reference the column data in your formulas or integrations.
Clay Support
APP
·
·
Did that answer your question?
Tanay M.
·
·
Mensur good to know!! Thanks for sharing
Clay Support
APP
·
·
Glad to hear you found a solution! Let me know if you have any other questions or need further assistance.

Clay Support
APP
·
·
It looks like your "Person Enrich" column might be hidden or collapsed. Try clicking the Columns button at the top of your table to see all available columns.
You can toggle the visibility of any column using the switches next to each column name, or click "Show all columns" to display everything.
If it's a child column from a parent enrichment, you might need to click on the parent column header and select "Go to parent column" to find the original enrichment.
Clay Support
APP
·
·
Was that helpful?
Tanay M.
·
·
Mensur you might want to create columns out of the “Status Code:200” column and map data out explicitly into new columns. From there you should be able to reference them in the http body request
Clay Support
APP
·
·
You can create new columns from your enrichment data by clicking Add column at the right of your table.
To extract specific data from your enrichment results:
1.
Click the enriched column header
2.
Select Insert right or Insert left to add a new column
3.
Choose your data type and use formulas to reference specific fields from the parent enrichment
You can also use Merge columns to combine data from multiple sources into new columns that you can then reference in your HTTP requests.
If you need to see all available columns, click the Columns button to show/hide specific columns.
Clay Support
APP
·
·
Is that what you were looking for?
Mensur
·
·
Tanay M. i have a huge json, that will fill my entire clay table. I really want just pull the data from json.
Clay Support
APP
·
·
You can filter your JSON response to pull only specific data using the "Field Paths to Return" option in your HTTP API setup.
Use dot notation to specify exactly which fields you want (e.g., object1.object2.name). Separate multiple field paths with commas. This prevents the huge JSON from filling your entire table by returning only the data you need.
Alternatively, use our "Extract Values from Data" integration to pull specific information from your JSON after it's received.
Can you copy and paste your JSON structure so I can help you identify the exact field paths to use?
Mensur
·
·
Found the issue. you can not reference to a column if it's grouped. Seems like a bug for sure. As soon i removed the group i could find the column. Tanay M.
1
Clay Support
APP
·
·
Thanks for figuring that out! You're right - grouped columns can interfere with referencing data from other columns. When columns are grouped, it can make it harder to access individual column data for referencing purposes.
Ungrouping the columns should resolve the issue and allow you to properly reference the column data in your formulas or integrations.
Clay Support
APP
·
·
Did that answer your question?
Tanay M.
·
·
Mensur good to know!! Thanks for sharing
Clay Support
APP
·
·
Glad to hear you found a solution! Let me know if you have any other questions or need further assistance.