Passing Data Arrays Between Tables in API Lookups: Challenges Explained

Can you not pass arrays of data between tables? I'm trying to look up a row in table A, using the look up enrichment in table B, and work with a list that exists in an API response in the row in workbook A. But when I look up the row, the array doesn't appear in Table B.

13 comments

Channeled
APP
·
·
Yes, you can work with arrays of data between tables in Clay using different lookup options: 1. Single Row Lookup: Use this when you need to find one specific matching row in another table. This is the most efficient option when you only need one result. 2. Multiple Row Lookup: This option allows you to find multiple matching rows in another table based on your specified criteria. This is ideal when you need to retrieve multiple records at once. 3. Write to Table: This feature can help you handle lists and parse them across tables. You can break down a list in a cell and map each item to another table, effectively working with arrays of data. Sources: Lookup Single Row in Other Table with Clay Lookup Multiple Rows in Other Table with Clay Write to Table - Clay University
Mathew I.
·
·
I am using single row look up, but the json data does not appear
Channeled
APP
·
·
When using the "Lookup Single Row in Other Table" action, it's designed to retrieve a single row of data, which may not be suitable for array data. For array data or multiple matching records, you should use the "Lookup Multiple Rows in Other Table" action instead.If you're still experiencing issues, it could be related to how the data is formatted or mapped in your tables. The "Write to Other Table" action supports writing lists, single values, or objects, so ensure your data is properly structured for retrieval.Could you provide more details about the specific array data you're trying to retrieve and how it's structured in the source table? This information would help us better understand and address your issue. Sources: Lookup Multiple Rows in Other Table with Clay Lookup Single Row in Other Table with Clay Write to Other Table with Clay Labs
Mathew I.
·
·
I want to look up an array / json object from another table
Channeled
APP
·
·
We offer two options for looking up data from another table: 1. "Lookup Single Row" - Use this when you need to find one specific row in another table. This is the more efficient option if you only need a single match. 2. "Lookup Multiple Rows" - Use this when you need to find multiple matching records from another table. This is ideal when you expect multiple rows to match your criteria.Both options support looking up any type of data, including arrays and JSON objects, from your source table. Simply specify the table you want to search and the criteria for finding the matching row(s). Sources: Lookup Single Row in Other Table with Clay Lookup Multiple Rows in Other Table with Clay
Mathew I.
·
·
Those do not work
Channeled
APP
·
·
I apologize for the inconvenience; could you please provide more details about what didn't work so we can better assist you?
Mathew I.
·
·
person
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Owen C.
·
·
Hey Mathew, thanks for reaching out! If you are using a lookup function in Table A to search through Table B, any nested data in Table B that does not exist in its own column will not be visible from Table A. The workaround here would be mapping this data to their own columns OR using our 'Write to Table' function that allows you to write entire Arrays of data into new or existing tables within your workspace. Quick Video on Write to Table Hope this helps! Let me know if you have any other questions, concerns, or need a hand setting up this workflow. :)
Mathew I.
·
·
Got it thanks
Owen C.
·
·
Of course! Let me know if you have any other questions. In the meantime, I’ll go ahead and close this ticket. :)
1
Channeled
APP
·
·
Hi Mathew I.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Passing Data Arrays Between Tables in API Lookups: Challenges Explained | Clay