APIs & Integrations

SamSellars
Participant

V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

SOLVE

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?

0 Upvotes
1 Accepted solution
JBeatty
Solution
Guide | Diamond Partner
Guide | Diamond Partner

V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

SOLVE

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,

✔️ Was I able to help answer your question? Help the community by marking it as a solution.

Joshua Beatty
Software Developer with Pearagon

Still have questions? Let's Talk

View solution in original post

0 Upvotes
2 Replies 2
JBeatty
Solution
Guide | Diamond Partner
Guide | Diamond Partner

V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

SOLVE

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,

✔️ Was I able to help answer your question? Help the community by marking it as a solution.

Joshua Beatty
Software Developer with Pearagon

Still have questions? Let's Talk

0 Upvotes
SamSellars
Participant

V1 Batch Upserted Contacts Not Showing Up After Delete In Sandbox

SOLVE

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

0 Upvotes