contacts search results and total difference

[TKim12]

Hello.

I'm new to HubSpot and trying to integrate HubSpot Contact datas and Company datas.

On left top corner of Contact page (CRM > Contact), total records count displays. ex) 20,276
The response from the endpoint https://api.hubapi.com/crm/v3/objects/contacts/search returns the same total. ex) "total": 20276

However, when I export all contacts in csv file format, it also displays 20,276 rows in 1 file will be exported and once I read the exported file, it only has 20,275 rows of datas(20,276 rows including header).

The "results" count from the endpoint https://api.hubapi.com/crm/v3/objects/contacts/search is also 20,275

Does anyone know why the "total" and actual data counts is different? 

[TKim12]

When I narrowed down the search to the exact same created date time in mili seconds, 
the response displays "total": 2, but only 1 "results" entry.

Is there any possibility of generating duplicate records when importing Contacts by mass data upload?

[PamCotton]

Hey, @TKim12 The difference between the total and results may be due to deduplication or filters in the API response. Duplicates can occur during mass uploads if unique identifiers (like email) aren’t used. Using HubSpot's deduplication tools during import can help avoid this.

Kindly,

Pam

[PamCotton]

Hey @TKim12, thank you for posting in our Community!

The difference in the contact count could be due to deleted or inactive contacts that are still counted in the total but don’t appear in the export. It might also be caused by duplicates or changes during the export process. To our top experts @DanielSanchez and @Anton do you have any recommendations for @TKim12?

Best,

Pam