Data & Analytics
Airbyte HubSpot deals can be missing from a successful sync
Reconcile HubSpot deal IDs after Airbyte CRM Search syncs that finish without errors.
November 9, 2026
A completed sync is not a reconciliation. An Airbyte HubSpot issue reports that CRM Search streams can omit deals modified while a full-refresh sync is in progress. The reporter compared several daily snapshots: missing deals existed before and after a run, yet the run showed no failures. Their analysis points to a last-modified slice ending at sync start and offset paging over a changing result set. This is a reported reproduction on connector 6.13.0, not a claim that every HubSpot stream loses rows.
Prove whether records went missing
Record connector version, stream, sync mode, start time and source object count. Compare a stable sample of HubSpot deal IDs with destination IDs after each completed run, focusing on deals edited during the run. Keep the previous destination snapshot long enough to spot an ID that disappears and returns. A full-refresh overwrite can make one omitted record look like a deletion to downstream reports.
The Airbyte HubSpot changelog helps tie behavior to a precise connector version. Do not infer a fix from a newer release number: check the relevant change entry or issue closure. HubSpot's CRM Search API defines the search boundary, but source changes during pagination still need an application-level reconciliation plan.
Protect decisions while investigating
Alert on an unexpected drop in distinct deal IDs, especially when total row counts look normal. Compare the missing IDs against HubSpot rather than replaying the entire pipeline blindly. If the report affects pipeline or revenue decisions, mark that window provisional until the source and destination agree.
Test any connector configuration or endpoint change on a copied connection first. Keep the exact IDs, timestamps and request slice in an upstream support case. The question to answer is whether the source reader emitted the records, not whether the destination acknowledged what it received.
Adovo’s view
Green jobs are operational signals, not data truth. When a changing CRM feed is paged, reconciliation must be designed into the contract. The valuable dashboard is the one that can explain a missing deal before someone makes a decision from it.
