topic V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox in APIs & Integrations

V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

SamSellars — Wed, 12 Jun 2024 19:30:08 GMT

Recently, I experienced some strange behavior in a sandbox environment.

Deleted all the contact records via web UI. 25K
Ran a process to upsert 25K records via V1 batch api in chunks of 500.
Confirmed in our logs and HubSpot logs that all records were recieved without error
The count only showed slightly over 15K records

Upon repeating this test, it did not reproduce. The entire count of 25K was showing. Thoughts anyone?

Re: V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

JBeatty — Wed, 12 Jun 2024 21:33:09 GMT

My instinct here is based on that HubSpot does not delete 25k rows all at once, and it can have some lag. So when you went to upsert 25k contacts, 15K of the contacts were created new, but 10k of the contacts were updated and still yet to be deleted, so when the deletion process continued it deleted some of the contacts that had just been updated. This is all just a hunch though but it would explain why it was not reproducable(or at least is not easily reproducable).

Best,

Re: V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

SamSellars — Wed, 12 Jun 2024 21:37:12 GMT

Yep, @JBeatty I have exactly the same suspicion as you. I went too fast for it. 😀