how does the clay auto duplicating work in this context, if I am auto-deduplicating it by newest?
Daily webhook to push into clay, day 1: 50 results -> Push into another table
Day 2: 52 results -> Push into another table
Does clay push the additional 2 results
If you’re auto-deduplicating by newest on a specific key like email, domain, or an ID, Clay will compare incoming rows against what already exists in the destination table.
In your example:
• Day 1: 50 results are pushed into the table. All 50 are new, so they’re inserted.
• Day 2: 52 results are pushed.
• The 50 that already exist are recognized as duplicates and deleted.
• Only the 2 new records are added to the table.
So yes, Clay will only push the additional 2 results, assuming the deduplication key is the same and unchanged.