Best Practices to Prevent Duplicate Records from API Data Imports

·Nov 04, 2025 12:41 PM·

Hey everyone, I’m fairly new to Clay and had a question I’ve been wondering about. I’m pulling data from an API and planning to run it on a schedule. When it re-runs, I’m a bit concerned about duplicates - does anyone have best-practice tips for preventing duplicate records from being added to the same table?

🖼️1

2 comments

· Sorted by Oldest

Discuss Anything

Best Practices to Prevent Duplicate Records from API Data Imports

Hannah S.

·Nov 04, 2025 12:41 PM·

Hey everyone, I’m fairly new to Clay and had a question I’ve been wondering about. I’m pulling data from an API and planning to run it on a schedule. When it re-runs, I’m a bit concerned about duplicates - does anyone have best-practice tips for preventing duplicate records from being added to the same table?

🖼️1

2 comments

· Sorted by Oldest

Brendan L.
·
·
You can turn on auto-deduplication for rows from table settings! You need a single column with a unique ID to de-duplicate on.
👍🏼1
Hannah S.
·
·
Oh amazing! Thank you very much
1

Brendan L.
·
·
You can turn on auto-deduplication for rows from table settings! You need a single column with a unique ID to de-duplicate on.
👍🏼1
Hannah S.
·
·
Oh amazing! Thank you very much
1