Question
How do I get the most recent status of a deal?
Environment
Connector: 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.