Why Don't Records Update When the last_viewed_at Field Changes?

Question

The Hex API shows updated last_viewed_at values for some records. Why aren't the corresponding records updating in the destination?

Environment

Connector: Hex

Answer

Fivetran incrementally syncs Hex data based on updates to the last_edited_at field. We use this field because the Hex API ListProjects endpoint does not support sorting by last_viewed_at. For more information, see the Hex API ListProjects documentation.

When a field such as last_viewed_at changes but last_edited_at does not, we don't consider the record updated, and the change won't be synced.