Question

How do I get the most recent status of a deal?

Environment

Pipedrive

Answer

You can get the latest status entry from the Deal_History table. Despite multiple entries for a deal Id in this table, there will only be one active entry with _fivetran_active = true at a time which reflects the latest details of a deal.

Cause

The Deal_History table may contain multiple entries for one deal.