.png){kind=logo}
Extracting Structured Data from Master Leads Table for Projects
Hi team - Context: We have a master āLeadsā table where each lead is enriched with the āEnrich Personā column. In a second project table, I need to pull that same āEnrich Personā data for leads that already exist in the master table. What I tried: I used āLookup Single Row in Other Table,ā matched on our unique key, and selected the āEnrich Personā column. This returns a value, but it comes through as plain text. It does not preserve the structured object, for example title, summary, headline, certifications array, and similar fields. Goal: Pull āEnrich Personā from the master table into my project table as the full object, so I can reference nested fields directly, not just a text blob. Questions:
- 1.
Is there a way to return that column in object form through āLookup Single Row in Other Table,ā or a different lookup step that preserves the data type, for example a row link or object lookup that keeps JSON structured?
- 2.
If not, is there a recommended pattern to keep the original object, for example creating a row link column type, then referencing the column with dot notation, or enabling a āraw valueā or āreturn JSONā option?
- 3.
If a transform is required, what is the best practice to parse the returned value back into a usable object for downstream steps?
