Adovo

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.

Continue exploring

Data & Analytics

AirbyteAmazon Seller Partner

Airbyte Amazon settlement sync can hide missing posted dates

A successful Amazon Seller Partner sync can null localized posted-date fields; audit _airbyte_meta before finance uses them.

Read more

Data & Analytics

AirbyteAzure Table Storage

Airbyte Azure Table discovery shows only PartitionKey: validate before sync

Investigate incomplete Azure Table schema discovery before accepting a successful but empty sync.

Read more

Data & Analytics

AirbyteData quality

Airbyte MySQL can turn long text into silent NULLs

Audit raw and final tables when Airbyte MySQL typing converts strings longer than 512 characters.

Read more
Explore data and analytics services →