Release Notes

February 2026

We have added the following new tables:

ACTIVITY_ATTENDEES
ACTIVITY_FIELD
ACTIVITY_FIELD_OPTION
ACTIVITY_FIELD_SUBFIELD
PRODUCT_PRICE

Data synced into these new tables will not contribute toward your MAR until March 15, 2026.

We have removed the PRODUCT_PRICE_HISTORY table.

We have made the following changes to the ACTIVITY table:

Removed the following columns:

Column Name	Notes
`assigned_to_user_id`	Data is already available in the `owner_id` column.
`attendees`	Data is now available in the `ACTIVITY_ATTENDEES` table.
`deal_dropbox_bcc`
`last_notification_time`
`last_notification_user_id`
`person_dropbox_bcc`
`reference_id`
`reference_type`
`source_timezone`
`update_user_id`

Renamed the following columns:

Old Name	New Name	Notes
`active_flag`	`_fivetran_deleted`	`_fivetran_deleted = true` indicates the record is inactive.
`busy_flag`	`busy`
`created_date`	`add_time`
`custom_Priority`	`priority`	The renamed column (`priority`) now stores priority IDs instead of labels.
`custom_Project`	`project_id`
`user_id`	`owner_id`

We have made the following changes to the DEAL_HISTORY table:

Removed the following columns:
Column Name Notes
cc_email Pipedrive no longer provides any data for this column.
custom_Currency of ACV
custom_Currency of ARR
custom_Currency of MRR
pipeline_deal_probability
pipeline_name

Column Name	Notes
`cc_email`	Pipedrive no longer provides any data for this column.
`custom_Currency of ACV`
`custom_Currency of ARR`
`custom_Currency of MRR`
`pipeline_deal_probability`
`pipeline_name`

Renamed the following columns:

Old Name	New Name	Notes
`active_flag`	`_fivetran_deleted`	`_fivetran_deleted = true` indicates the record is inactive.
`created_date`	`add_time`
`custom_ACV`	`acv`
`custom_arr`	`arr`
`custom_Archive status`	`is_archived`	The renamed column (`is_archived`) now stores archive IDs instead of labels.
`custom_Archive time`	`archive_time`
`custom_Source channel`	`channel`	The renamed column (`channel`) now stores channel IDs instead of labels.
`custom_Source channel ID`	`channel_id`
`custom_Source origin`	`origin`	The renamed column (`origin`) now stores origin IDs instead of labels.
`custom_Source origin ID`	`origin_id`
`label`	`label_ids`
`user_id`	`user_id`

We have made the following changes to the ORGANIZATION table:

Added a new column, label_ids
Removed the label column

Renamed the following columns:

Old Name	New Name	Notes
`active_flag`	`_fivetran_deleted`	`_fivetran_deleted = true` indicates the record is inactive.
`cc_email`	`smart_bcc_email`
`created_date`	`add_time`
`custom_Annual revenue`	`annual_revenue`
`custom_Industry`	`industry`
`custom_LinkedIn profile`	`linkedin`
`custom_Number of employees`	`employee_count`
`custom_Website`	`website`

We have made the following changes to the PERSON table:

Added a new column, label_ids
Removed the label column

Renamed the following columns:

Old Name	New Name	Notes
`active_flag`	`_fivetran_deleted`	`_fivetran_deleted = true` indicates the record is inactive.
`created_date`	`add_time`
`custom_Birthday`	`birthday`
`custom_City/town/village/locality of Postal address`	`postal_address_locality`
`custom_Country of Postal address`	`postal_address_country`
`custom_District/sublocality of Postal address`	`postal_address_sublocality`
`custom_Full/combined address of Postal address`	`postal_address_formatted_address`
`custom_House number of Postal address`	`postal_address_street_number`
`custom_Instant messenger`	`im`
`custom_Job title`	`job_title`
`custom_Notes`	`notes`
`custom_Postal address`	`postal_address`
`custom_Region of Postal address`	`postal_address_admin_area_level_2`
`custom_State/county of Postal address`	`postal_address_admin_area_level_1`
`custom_Street/road name of Postal address`	`postal_address_route`
`custom_ZIP/Postal code of Postal address`	`postal_address_postal_code`

We have made the following changes to the PIPELINE table:

Removed the selected and url_title columns
Renamed the following columns:
Old Name New Name Notes
active_flag _fivetran_deleted _fivetran_deleted = true indicates the record is inactive.
created_date add_time

We have renamed the following columns of the PRODUCT table:

Old Name	New Name	Notes
`active_flag`	`_fivetran_deleted`	`_fivetran_deleted = true` indicates the record is inactive.
`created_date`	`add_time`

We have made the following changes to the STAGE table:

Removed the pipeline_deal_probability and pipeline_name columns
Renamed the following columns:
Old Name New Name Notes
active_flag _fivetran_deleted _fivetran_deleted = true indicates the record is inactive.
created_date add_time

We now sync only the user ID from the custom fields of the User type. Previously, we synced a JSON file containing user details from these fields. We have made this update to align with Pipedrive changes.

For all renamed columns, we will temporarily maintain two versions of each column, one with the old name and one with the new name, and sync data into both. This dual-column setup will remain in place until March 31, 2026. On March 31, 2026, we will permanently remove the columns with the old names and retain only the columns with the new names.

January 2026

We have discontinued the SUBSCRIPTION and SUBSCRIPTION_PAYMENT tables as Pipedrive has deprecated the associated API endpoints.

August 2025

We have added a new table, DEAL_FIELD. We are gradually rolling out this change to all connections.

We have added a new child table, INSTALLMENT, to the DEAL_HISTORY table. We are gradually rolling out this change to all connections.

July 2025

We have added two new tables, TASKS and PROJECT. We are gradually rolling out this change to all connections.

April 2025

We have added a new table, CALL_LOGS. We are gradually rolling out this change to all connections.

January 2025

We retrieve data only from the past 30 days for the following tables due to a change in the Recents endpoint in Pipedrive:

ACTIVITY
ACTIVITY_TYPE
FILE
NOTE
ORGANIZATION
PERSON
PIPELINE
STAGE
DEAL
PRODUCT
FILTER
USER

To maintain data integrity, we automatically re-sync these tables if they remain deselected for more than 30 days or if the connection is paused for over 30 days. We only re-sync when you select the tables again or unpause the connection.

November 2024

We have added the following new columns to the PRODUCT_DEAL table:

billing_frequency
billing_frequency_cycles
billing_start_date

May 2024

We have changed the data type of the progress column in the GOAL table from INT to DOUBLE.

April 2024

We have changed the data type of the quantity column in the PRODUCT_DEAL table from LONG to DOUBLE.

September 2023

We have added the following new columns to the PRODUCT_DEAL table because Pipedrive has changed its logic of product discounts:

discount
discount_type
tax_method

We now re-import the LEAD_HISTORY table in every sync. Previously, we re-imported this table once a day to capture updates and deletes.

May 2023

We have changed the composite primary key of the PERSON_EMAIL and PERSON_PHONE tables. The new composite key is a combination of the person_id and index columns.

February 2023

We have added two new columns, org_id and lead_id, to the NOTE table.

January 2023

We have changed the datatype of the label column in the DEAL table from INT to STRING, to support Pipedrive changes. For more information, see Pipedrive's documentation.

We have changed the datatype of the category column in the PRODUCT table from INT to STRING, to support Pipedrive changes.

We have removed the product_id column from the primary keys of the PRODUCT_DEAL table as it can contain null values.

September 2022

Pipedrive has changed the data type of the type.params.pipeline_id column in the GOAL table from INTEGER to ARRAY. We will continue to store the type.params.pipeline_id column as a STRING in the destination.

We added a new table, GOAL_PIPELINE, where goal_id and pipeline_id columns are the composite primary keys. The goal_id column refers to the GOAL table, and the pipeline_id column refers to the PIPELINE table. We made this change because in Pipedrive, a single goal can now be associated with multiple pipelines. You can now query all the associated pipelines of a goal from the GOAL_PIPELINE table. Previously, you had to query the pipeline_id column of the GOAL table.

We have moved the progress column from the GOAL_RESULT table to the GOAL table. We no longer populate the GOAL_RESULT table.

We are gradually rolling out these changes to all existing connections. If you'd like to enable this feature on your connector, contact our support team.

July 2022

We have added a new optional field, Personal API token, to the connector setup form. Now, if you want to sync the PERMISSION* tables, you must provide your personal API token. For more information, see our setup instructions. If you don't provide the personal API token, we exclude the tables from the sync. Previously, we synced the PERMISSION* tables without the API token.

We now use the permission_set_id column as the primary key for the PERMISSION_ASSIGNMENT table.

June 2022

We have added the following new columns to the PRODUCT_DEAL table:

active_flag
add_time
comments
currency
discount_percentage
duration
duration_unit
enabled_flag
id
item_price
last_edit
name
order_nr
product_variation_id
quantity
quantity_formatted
sum
sum_formatted
sum_no_discount
tax

September 2021

Our Pipedrive connector is now generally available.

Read our Pipedrive connector documentation.

August 2021

We have added the following new tables:

FILTER
FILTER_HELPER
LEAD_HISTORY
LEAD_LABEL_HISTORY
LEAD_LEAD_LABEL
LEAD_SOURCE
TEAM
TEAM_USER
GOAL
GOAL_RESULT
SUBSCRIPTION
SUBSCRIPTION_PAYMENT
PERMISSION_SET
PERMISSION
PERMISSION_ASSIGNMENT

March 2021

We have added two new tables, PERSON_PHONE_MAPPING and PERSON_EMAIL_MAPPING, to map the phone and email columns in the PERSON table.

We will discontinue the email and phone columns from the PERSON table after June 30, 2021. Be sure to update your queries.

February 2021

Pipedrive is a sales CRM and pipeline management platform.

Read our Pipedrive connector documentation.

December 2020

We have expanded the public API endpoints Create a connection and Update a connection. Now you can authorize the following connectors by adding the auth section to payloads: