Question
How can 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. You may find multiple deal Id entries in this table. However, only one entry will be marked as _fivetran_active = true at a time which reflects the latest details of a deal.