Why Aren't Some Company Details Updated in the COMPANY_HISTORY Table?

Question

Why aren't updates to some companies reflected in the COMPANY_HISTORY table?

Environment

Connector: Intercom

Answer

Fivetran uses the Intercom companies/scroll endpoint to sync company data, as recommended by Intercom. The companies/scroll endpoint only returns companies associated with at least one user, and excludes companies with where user_count=0. As a result, we can't sync those updates to the COMPANY_HISTORY table in your destination.

To include a company in syncs, associate it with at least one user in Intercom.