Why Are Contacts Missing or Outdated in the CONTACT_HISTORY Table?

Question

Why are some contacts missing or outdated in the CONTACT_HISTORY table?

Environment

Connector: Intercom

Answer

Fivetran uses the Intercom Contact Search API to sync data to the CONTACT_HISTORY table. The API returns contacts based on their updated_at timestamp.

However, due to a limitation in the Contact Search API, contacts updated within minutes of the UTC day boundary may not be returned. As a result, we can't sync those contacts. They may be missing from the CONTACT_HISTORY table or show outdated values from the last successful sync.

The affected contacts sync again after they are updated in Intercom and receive a new updated_at timestamp outside the affected period.