V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

Develop, Build & Integrate APIs & Integrations
1

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?

2

Hi @SamSellars,

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,

3

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