Limited Access to Properties in Table Lookup Explained

Tom O. · 2025-11-10T10:32:19.052Z

I did a lookup of a single row in a table but I can only access a few properties via that look up and not all. Why?

Limited Access to Properties in Table Lookup Explained | Clay

Clay Support
APP
·
·
When using the Lookup Single Row in Other Table action, you get access to all data from the matched row, but the specific properties available depend on what columns exist in the target table and how the data is structured.
If you're only seeing limited properties, this could be because:
• The target table may not contain all the columns you expect
• Some enrichment data might be nested within specific endpoints that need to be referenced individually
• You may need to reference the entire enrichment or drill down to specific endpoints within the returned data
You can click into the specific cell where you're seeing the lookup results to expose more details about what data is actually available.
Clay Support
APP
·
·
Was that helpful?
Tom O.
·
·
I just added it to the table where I do the lookup in but I still cant see it. How can I ensure I see all properties?
Clay Support
APP
·
·
To see all properties from your lookup, click the Columns button at the top of your table and select Show all columns.
You can also reference the entire enrichment by selecting Insert all properties when setting up your lookup column, which gives you access to every endpoint within that enrichment.
Clay Support
APP
·
·
Is that what you were looking for?
Tom O.
·
·
How can I add properties to be seen in the {} record?
Clay Support
APP
·
·
To add properties from a {} record (list data) to your table:
1.
Click on the cell containing the {} record to open the Cell details panel
2.
Hover over the specific endpoint you want to add and click "Add as column"
3.
Enter a column description and click "Create column" to generate a new column
Alternatively, you can reference all properties from an enrichment by selecting "Insert all properties" when setting up your column
Clay Support
APP
·
·
Is that what you were looking for?
Tom O.
·
·
The property I want to add as a column is not shown in the cell.
Clay Support
APP
·
·
If the property you want isn't visible in the cell, click into the specific cell to expose more details about what data is actually available.
The property might be nested within the enrichment data structure. When you click on the cell containing your lookup results, this opens the Cell details panel where you can see all available endpoints and data.
If you're still not seeing the expected property, the issue might be that the data structure contains nested objects that need specific referencing, or the property may not exist in the source data.
Clay Support
APP
·
·
Was that helpful?
Hunain F.
·
·
That usually happens because Clay lookups only return the fields properties that are enabled or mapped in the connected table not every column by default.
Clay Support
APP
·
·
You're correct! To see all available properties from your lookup, click the Columns button at the top of your table and select Show all columns.
You can also reference the entire enrichment by selecting Insert all properties when setting up your lookup column, which gives you access to every endpoint within that enrichment.
If specific properties still aren't visible, click on the cell containing your lookup results to open the Cell details panel, then hover over the desired endpoint and click Add as column to create a new column for that property.
Clay Support
APP
·
·
Is that what you were looking for?
Tom O.
·
·
Hey Hunain, thanks for your input! Do you know how solve this?

18 comments