.png){kind=logo}
Issue: Leads Found but No Rows Added to Database Table
I found 1556 leads, but zero rows were added to a table despite the source showing that 1,556 rows were added.
I found 1556 leads, but zero rows were added to a table despite the source showing that 1,556 rows were added.
This discrepancy occurs because limits are likely applied to your search filter, such as restricting leads per company. While the preview shows 1,556 results as the total count, the final import reflects these limits. Check your search filter settings and adjust any applied restrictions before importing. Also, if you encounter errors when writing lists to tables, ensure the value is formatted as a list by adding it through the "Other data from this table" section. If you see empty rows, try clearing your cache and refreshing your screen to resolve front-end performance issues.
Hi - Leanid K. Leads not showing in table (but source says 1,556 added) – Fix: Check Filters in Table View Top bar: Set to “All rows” not “Only active/incomplete” Refresh Table or Reopen Clay Sometimes UI lags behind. Full browser refresh. Open the Source Block Click source block Scroll Check if data preview shows leads If yes: Click Run Again or Create Rows, Check Column Mapping If no key column (like name/email), rows won’t appear Still not working? Delete block Re-add source Try again
This discrepancy occurs because limits are likely applied to your search filter, such as restricting leads per company. While the preview shows 1,556 results as the total count, the final import reflects these limits. To fix this: Check your search filter settings and adjust any applied restrictions before importing. For UI issues: If you see empty rows, try clearing your cache and refreshing your screen to resolve front-end performance issues. For source updates: Editing the source after it's been run won't retroactively update results. To see updated results, either delete and re-run the step or duplicate the table with the updated source.
Hello Hunain! I tried everything, but the result is the same. My table: https://app.clay.com/workspaces/240608/workbooks/wb_5kPq8kEyG2Bc/tables/t_0t05jsqKi[…]yTableViewId=gv_0szulvvd2AUW7EyoQsr&workbookId=wb_5kPq8kEyG2Bc
This discrepancy occurs because limits are likely applied to your search filter, such as restricting leads per company. While the preview shows 1,556 results as the total count, the final import reflects these limits. Since you've tried the standard troubleshooting steps, the issue is most likely filter restrictions rather than UI problems. Check your search filter settings for any applied limits (like leads per company) and adjust these restrictions before importing. If you're still seeing empty rows after adjusting filters, try clearing your cache and refreshing your screen to resolve potential front-end performance issues.
I can't access or view your table directly, but I can help troubleshoot this issue. The discrepancy between 1,556 leads shown in the source and zero rows in your table typically occurs because limits are applied to your search filter, such as restricting leads per company. Check your search filter settings and adjust any applied restrictions before importing. If you've already tried the standard troubleshooting steps, editing the source after it's been run won't retroactively update results - you'll need to delete and re-run the step or duplicate the table with the updated source. If you see empty rows, try clearing your cache and refreshing your screen to resolve front-end performance issues. If you need further help with this specific table, please request human assistance by clicking on "Talk to a person."
Hi Leanid - thanks so much for reaching out and for your patience here. I can't see the table you sent across anymore, perhaps because it was deleted. Do you mind trying the action again and seeing if you see the same issue? Let us know what you see and happy to help troubleshoot this further if you can send across a table where the issue seems to be coming up
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.