Release Notes

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 connectors. 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 deprecate 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 Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth section to payloads: