Pipedrive (v05-10-2016)
Last updated: 9/15/2026This version of Pipedrive reached end of life on December 18, 2018 and is no longer functioning.
Upgrade to the latest version (v2) to continue replicating data.
Pipedrive feature snapshot
A high-level look at Stitch's Pipedrive (v05-10-2016) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status |
Sunset on December 18, 2018 |
Supported by
Indicates if the integration is supported by Stitch or the Singer community. |
|
|
Stitch plan
The type of Stitch plan required to use the integration. |
Standard |
API availability
Indicates if the integration is available as a source in Stitch Connect. |
This version of the integration isn't available via the API. |
| Singer GitHub repository |
Not applicable |
||
| REPLICATION SETTINGS | |||
|
Anchor Scheduling
A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. |
Anchor Scheduling is not supported for this integration. The only available replication scheduling method is the Replication Frequency setting. |
Advanced Scheduling
A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. |
Advanced Scheduling is not supported for this integration. |
|
Table-level reset
Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. |
Table-level resets are not supported for this integration. Resets are only supported at the integration level. |
Configurable Replication Methods
Indicates if Replication Methods can be defined by you for tables in the integration. |
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate. |
| DATA SELECTION | |||
|
Table selection
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. |
Table selection is not supported for this integration. All available table and fields will be automatically selected for replication. |
Column selection
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. |
Column selection is not supported for this integration. All available columns in tables set to replicate will be selected. |
|
Select all
Indicates if the integration supports selecting all available tables and columns. |
As this integration doesn't support table or column selection, all available tables and columns are automatically replicated. |
||
| TRANSPARENCY | |||
|
Extraction Logs
Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. |
This feature is not supported for this version of the integration. |
Loading Reports
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. |
This feature is supported for this version of the integration. |
Pipedrive table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 05-10-2016 of this integration.
Want to check out what your data looks like in Pipedrive’s API? If you still have your API Token handy, you can enter it on Pipedrive’s website to interact directly with the API and see your data in raw JSON format.
In the Attributes section for each table is a link to Pipedrive’s documentation for that endpoint. Use those links to interact with Pipedrive’s API.
activity_types Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Activity Type ID (
id)active_flag
add_time
icon_key
is_custom_flag
key_string
name
order_nr
currencies
Replication Method: Full Table
Primary Key:
id
Contains Nested Structures?: No
currencies table contains info about the currencies listed in your Pipedrive account.currencies Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Currency ID (
id)active_flag
code
decimal_points
is_custom_flag
name
symbol
deals
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
deals table contains info about the deals in your Pipedrive account.deals Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Deal ID (
id)active
activites_count
add_time
cc_email
creator_user_id
currency
deleted
done_activities_count
expected_close_date
followers_count
formatted_value
formatted_weighted_value
last_activity_date
last_activity_id
next_activity_date
next_activity_duration
next_activity_id
next_activity_note
next_activity_subject
next_activity_time
next_activity_type
notes_count
org_hidden
org_id
org_name
owner_name
participants_count
person_hidden
person_id
person_name
pipeline_id
reference_activites_count
rotten_time
stage_id
stage_order_nr
status
title
undone_activites_count
update_time
user_id
value
visible_to
weighted_value
email_messages
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: Yes
email_messages table contains info about the email messages sent and received through your Pipedrive account. Your Pipedrive account must have the Mailbox feature enabled to replicate this data.email_messages & Nested Structures
This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a *
email_messages Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Email Message ID (
id)company_id
user_id
message_id
external_message_id
thread_id
mailbox
subject
summary
active
read
replied
sent
draft
has_body
include_body
read_time
language_code
reply_to_message_id
messages_to
*messages_from
*sent_error
attachment_count
draft_parameters
person_id
org_id
message_time
update_time
add_time
email_threads
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: Yes
email_threads table contains info about the email threads in your Pipedrive account. Individual emails are organized into threads.email_threads & Nested Structures
This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a *
email_threads Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Email Thread (
id)company_id
user_id
deal_id
first_message_subject
last_message_subject
total_messages
unread_messages
last_message_summary
first_message_time
last_message_time
replied
shared
last_message_attachment
last_message_cc
last_message_bcc
active
attachment
draft_messages
org_id
add_time
update_time
last_message_from
*last_message_to
*labels
*
files
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
files table contains info about the files in your Pipedrive account.files Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
File ID (
id)name
type
active
inline
remote_location
remote_id
cid
s3_bucket
deal_name
person_name
org_name
product_name
url
description
add_time
update_time
user_id
person_id
org_id
product_id
email_message
activity
mail_message
filters
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
filters table contains info about the filters that can be applied to Deals, Persons, Organizations, Products, and Activities in your Pipedrive account.filters Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Filter ID (
id)active_flag
add_time
name
type
update_time
user_id
visible_to
notes
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
notes table contains info about notes associated with deals.notes Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Note ID (
id)active_flag
add_time
content
deal__title
deal_id
org_id
organization_name
pinned_to_deal_flag
pinned_to_organization_flag
pinned_to_person_flag
update_time
user__email
user__is_you
user__name
user_id
organizations
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
organizations table contains info about the organizations - or the companies you’re doing deals with - in your Pipedrive account.organizations Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Organization ID (
id)active_flag
activities_count
add_time
address
address_admin_area_level_1
address_admin_area_level_2
address_country
address_formatted_address
address_locality
address_postal_code
address_route
address_street_number
address_sublocality
address_subpremise
cc_email
company_id
done_activities_count
email_messages_count
first_char
followers_count
last_activity_date
last_activity_id
lost_deals_count
name
next_activity_date
next_activity_id
next_activity_time
notes_count
open_deals_count
owner_id
people_count
reference_activites_count
undone_activities_count
update_time
visible_to
won_deals_count
persons
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: Yes
persons table contains info about the ‘persons’ in your Pipedrive account. These are the customers you’re doing deals with.persons & Nested Structures
This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.
These items are marked with a *
persons Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Person ID (
id)active_flag
activities_count
add_time
cc_email
company_id
done_activities_count
email
*email_messages_count
first_char
followers_count
last_activity_date
last_activity_id
last_incoming_mail_time
last_name
lost_deals_count
name
next_activity_date
next_activity_id
next_activity_time
notes_count
open_deals_count
org_id
org_name
owner_id
participant_closed_deals_count
participant_open_deals_count
phone
*reference_activities_count
undone_activities_count
update_time
visible_to
won_deals_count
pipelines
Replication Method: Full Table
Primary Key:
id
Contains Nested Structures?: No
pipelines table contains info about the pipelines in your account.pipelines Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Pipeline ID (
id)active
add_time
name
order_nr
selected
url_title
products
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
products table contains info about the products in your account. Products must be enabled in your account, or there’ll be no data for Stitch to replicate.A set of the prices__[currency]__[attribute] columns will be created for every currency enabled in your account.
If USD, for example:
prices__usd__cost-prices__usd__currencyprices__usd__idprices__usd__overhead_costprices__usd__priceprices__usd__product_id
products Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Product ID (
id)active
add_time
code
first_char
followers_count
name
owner_id
prices__[currency]__cost
prices__[currency]__currency
prices__[currency]__id
prices__[currency]__overhead_cost
prices__[currency]__price
prices__[currency]__product_id
selectable
tax
update_time
visible_to
stages
Replication Method: Full Table
Primary Key:
id
Contains Nested Structures?: No
stages table contains info about the stages in each of your pipelines.stages Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Stage ID (
id)active_flag
add_time
deal_probability
name
order_nr
pipeline_id
pipeline_name
rotten_days
rotten_flag
update_time
users
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
users table contains information about the internal users of your Pipedrive account.users Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
User ID (
id)activated
active_flag
created
default_currency
email
is_admin
is_you
lang
last_login
locale
modified
name
phone
role_id
timezone_name
activities
Replication Method: Key-based Incremental
Primary Key:
id
Contains Nested Structures?: No
activities table contains info about the activities (calls, tasks, lunches, etc.) in your Pipedrive account.activities Attributes
While we try to include everything Pipedrive has here, this may not be a full list of attributes. Refer to Pipedrive's documentation for a full list and description of each attribute.
Activity ID (
id)active_flag
add_time
assigned_to_user_id
company_id
created_by_user_id
deal_dropbox_bcc
deal_id
deal_title
done
due_date
due_time
duration
marked_as_done_time
note
org_id
org_id
owner_name
person_dropbox_bcc
person_id
person_name
reference_type
subject
type
update_time
user_id
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!