Release Noteslink

September 2023link

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 reimport the LEAD_HISTORY table in every sync. Previously, we re-imported this table once a day to capture updates and deletes.

May 2023link

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 2023link

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

January 2023link

We have changed the datatype of the label column in the DEAL table from INTEGER 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 INTEGER, 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 2022link

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 2022link

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 2022link

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 2021link

Our Pipedrive connector is now generally available.

Read our Pipedrive connector documentation.

August 2021link

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 2021link

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 2021link

Pipedrive is a sales CRM and pipeline management platform.