I am trying to write to table from enriched person data. Specifically, the latest experience list elements. The latest experience write to table selection only shows 8 elements available for "Select column from this table to write from". We know that the JSON and the cell details page shows 11 list elements. The one that's missing for me which I need is "summary".
The "write to table" feature in Clay allows you to select specific data points from a list to send to a new table. However, it seems you're experiencing an issue where not all elements are visible in the selection process. This discrepancy between the number of elements shown (8) and the actual number in the JSON (11) could be due to a formatting issue or a temporary display problem. To resolve this: 1. Ensure the data is correctly formatted as a list. 2. Try adding the list through the "Other data from this table" section. 3. Clear your cache and refresh your screen to rule out any front-end performance issues. If the "summary" element is still not appearing after these steps, can you provide more details about the structure of your data and how you're accessing the "latest experience" list?
I'm using "Add other data from this table". My "Select column from this table to write from" is wanting to reference the Enirch Person data. I've done it with no issues for most data points. The current experiences are showing fine...as each demonstrate 11 data elements. However, the latest experience is only showing 8 elements to select from. We know that the JSON and cell details do show 11 elements and include "summary" which is omitted from the write to table selection criteria in "Select column from this table to write from". My workbook is https://app.clay.com/workspaces/89103/workbooks/wb_YS5EHygfQja9/tables/t_xQVDnbARzkwh/views/gv_2RWJcSuK2eW9 and the table is "FIND FILTER ENRICH PERSON". You can see how I've selected lots of other Enrich Person elements with no issue. This is writing to the "ENRICH PERSON EXPANDED" table.
Hey Brian, Because the data is nested, you need to add the list object inside the Write to Other Table's list part. This will repeat each time there's a new value in that list. In your example with eight elements, if you map all of the list objects inside the list input, you'll get eight of each item repeated in your table.
Hey Bo (. thx for the screen recording. The issue wasn't how to select or write. It was that the latest experience array (your chose current experience in your recording) shows only 8 properties but there should be 11. The cell details UI shows 11 and the JSON shows 11....but when you go to select from the write to table functionality...there are only 8 properties showing which I know is false. That's why I raised it as a bug. I'm specifically looking to add the "summary" property from the latest experience array.
Hey Brian - Thank you for explaining the issue more clearly. I see the problem now.
I've flagged this as a bug to our engineering team. We'll follow up as soon as we have more information.