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?
