Bypassing Lookup Multiple Rows Record Limit in Tables

Tommy C. · 2025-11-10 20:19:05.992251+00

The Lookup Multiple Rows in a table action only outputs 100 records even though there are way more, how do I go around this limitation?

Bypassing Lookup Multiple Rows Record Limit in Tables | Clay

Clay Support
APP
·
·
The Lookup Multiple Rows action includes an optional Limit parameter that controls the maximum number of rows returned. [1] You can increase this limit or remove it entirely to retrieve more than 100 records. This limit setting is useful to cut down on response size when you have large numbers of columns, but you can adjust it based on your needs. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Tommy C.
·
·
I did not set a limit, it only reaches to 100 records found
Clay Support
APP
·
·
Even without explicitly setting a limit, the Lookup Multiple Rows action may have a default behavior that caps results at 100 records. [1] The Limit parameter is optional but when not specified, the system appears to apply an implicit limit. [2]
To retrieve more than 100 records, you'll need to explicitly set the Limit parameter to a higher value or leave it blank to remove any restrictions entirely. [3]
Clay Support
APP
·
·
Was that helpful?
Tommy C.
·
·
I did set a limit of 1000 but i still get the same output of 100 records
Clay Support
APP
·
·
This sounds like there might be an issue with how the limit parameter is being applied. You can click into the specific cell where you're seeing the 100-record output to expose more details about any error messages that might explain why the 1000 limit isn't working. [1]
The Lookup Multiple Rows action should respect the limit parameter you've set, so if it's still capping at 100 records despite setting 1000, there may be an underlying configuration issue or error preventing the higher limit from taking effect. [2]
Clay Support
APP
·
·
Was that helpful?
Tommy C.
·
·
no
Clay Support
APP
·
·
I understand this is frustrating, so I’m routing you to our human team who can assist further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Tommy C.
·
·
https://app.clay.com/workspaces/493425/workbooks/wb_0t5ix3lWc6NAkYR3NYq/tables/t_0t5iyqdDpda5scrquhZ/views/gv_0t5iyqd7dAMKaDPhfqp
LuisArturo
·
·
Hey there Tommy thanks for reaching out, taking a look here for you.
Tommy C.
·
·
Thank you, I am basically trying to consolidate call activity data from 2 sources and mapped them to our line of businesses to measure call volume week over week in google sheets
LuisArturo
·
·
I see, thank you for clarifying. Let me see if I can think of a workflow here

17 comments