Resolving Lookup Multiple Rows Object Error in Claygent

Tim P. · 2025-12-01T22:38:24.459Z

I am thinking about referencing everything that's in the lookup multiple rows object. But the claygent spat out an error (object object) . Why is that? How do i add functionally "the entire text"?

Resolving Lookup Multiple Rows Object Error in Claygent | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
The error likely happens because you're referencing the entire JSON object instead of specific keys within it. When Claygent tries to process the whole lookup object, it can't handle the structured data properly.
To reference all the data from your lookup multiple rows, you can Insert all items to reference the entire list at once. This gives you access to the complete set of data from all 15 records.
You can also use the Combine items into one text field action in the Cell details panel - this joins all items into one line separated by commas.
Click into the specific cell where you're seeing the error to get more details about what's causing the issue.
Clay Support
APP
·
·
Is that what you were looking for?
Tim P.
·
·
So in my example I'd pop in the records item?
Clay Support
APP
·
·
Yes, exactly! You'd use Insert all items to reference the entire "records" list from your lookup multiple rows. This gives you access to all 15 items at once instead of trying to reference the whole object structure.
That should resolve the Claygent error you were seeing.
Clay Support
APP
·
·
Did that answer your question?
Tim P.
·
·
and i'd need to separately add the number of results right...but i cannot just throw in the "lookup" object?
Clay Support
APP
·
·
Correct - you can't reference the entire lookup object directly. You need to reference specific parts separately:
- Use "Insert all items" for the records array to get all your data
- Reference numberOfResults separately as its own field
The lookup object contains structured data that Claygent can't process as a whole. You have to break it down into the specific pieces you need rather than passing the entire object.
Clay Support
APP
·
·
Does that make sense?
Tim P.
·
·
yes
Clay Support
APP
·
·
Glad that makes sense. Let me know if you want to dive deeper or have any other questions about using Claygent or referencing data.

Clay Support
APP
·
·
The error likely happens because you're referencing the entire JSON object instead of specific keys within it. When Claygent tries to process the whole lookup object, it can't handle the structured data properly.
To reference all the data from your lookup multiple rows, you can Insert all items to reference the entire list at once. This gives you access to the complete set of data from all 15 records.
You can also use the Combine items into one text field action in the Cell details panel - this joins all items into one line separated by commas.
Click into the specific cell where you're seeing the error to get more details about what's causing the issue.
Clay Support
APP
·
·
Is that what you were looking for?
Tim P.
·
·
So in my example I'd pop in the records item?
Clay Support
APP
·
·
Yes, exactly! You'd use Insert all items to reference the entire "records" list from your lookup multiple rows. This gives you access to all 15 items at once instead of trying to reference the whole object structure.
That should resolve the Claygent error you were seeing.
Clay Support
APP
·
·
Did that answer your question?
Tim P.
·
·
and i'd need to separately add the number of results right...but i cannot just throw in the "lookup" object?
Clay Support
APP
·
·
Correct - you can't reference the entire lookup object directly. You need to reference specific parts separately:
- Use "Insert all items" for the records array to get all your data
- Reference numberOfResults separately as its own field
The lookup object contains structured data that Claygent can't process as a whole. You have to break it down into the specific pieces you need rather than passing the entire object.
Clay Support
APP
·
·
Does that make sense?
Tim P.
·
·
yes
Clay Support
APP
·
·
Glad that makes sense. Let me know if you want to dive deeper or have any other questions about using Claygent or referencing data.