How Can I Get the Latest Status of a Deal?

Question

How can I get the most recent status update 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 include, _fivetran_active = true. This entry reflects the latest details of the deal.