Clay Icon

How to Change the Row Limit When Writing to a Table

ยท
ยท

I'm trying to write to table and its throttling the number of rows to 10, is there a reason for this or a way to change it?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    When setting up a Write to Table action, it defaults to running the first 10 rows as a safety measure. This isn't a permanent limit - tables can actually hold up to 50,000 rows.To run more rows, you have several options:1. Right-click the column and select "Run All Rows that haven't run or have errors" 2. Specify a custom number of rows by right-clicking the column, hovering over "Run Column" and choosing "Choose Number of rows to run" 3. Force run all rows by right-clicking the column, hovering over "Run Column" and selecting "Force Run All Rows" Source: Run Options

  • Avatar of JeanClaude D.
    JeanClaude D.
    ยท
    ยท

    Sorry, let me clarify, I have a column where I used the "Find Contracts" it retrieved 38 profiles. I then want to go and write those 48 profiles to a new table that I'm working in. It's only letting me write 10 of those 38 profiles to the table.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    When using the Find Contacts feature, there's a default limit of 10 results per search. This is a built-in parameter of the system.To get more results, you'll need to adjust your search parameters before importing. You can set limits up to:** 50,000 records per overall search ** Up to 100 records per companyI recommend going back to your Find Contacts search, adjusting the limit parameter to accommodate all 38 profiles you want to import, and then writing them to your new table. Sources: Find Contacts with Clearbit Find People overview | Documentation | Clay University

  • Avatar of JeanClaude D.
    JeanClaude D.
    ยท
    ยท

    It says the maximum is 10

  • Avatar of JeanClaude D.
    JeanClaude D.
    ยท
    ยท
  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This is a built-in parameter limitation of the Find Contacts feature. The maximum limit is set to 10 results for several Find Contact integrations including:** Find Contacts at Company with Companies, People, Jobs (max 10) ** Find Contacts with Clearbit (max 10) * Find People at Company By Job Title with Apollo.io (max 10)If you need to find more contacts, you may want to try using the Find People feature instead, which allows for higher limits (up to 50,000 records per search and up to 100 records per company). Sources: Find Contacts at Company with Companies, People, Jobs Find Contacts with Clearbit Find People at Company By Job Title with Apollo.io Find People overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Yes, instead of using the Find Contacts feature, you can use the Find People feature which allows for much higher limits:** Up to 50,000 records per overall search ** Up to 100 records per companyTo do this, use the Find People feature in Clay rather than Find Contacts. The Find People feature provides the same ability to search and add contacts, but with higher limits.Note: If you specifically want to add people search results as rows in a new table, the Find People feature is the recommended option. Sources: Find Contacts at Company with Companies, People, Jobs Source - Clay Find People with Companies, People, Jobs Find People overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi JeanClaude D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: