Get started with a free trial today
Already have an account? Sign in
This version of Pipedrive reached end of life onDecember 18, 2018 and is no longer functioning.
Upgrade to the latest version (v1) to continue replicating data.
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 | |
| Stitch plan | Standard | API availability | Not available |
| Singer GitHub repository | Not applicable | ||
| REPLICATION SETTINGS | |||
| Anchor Scheduling | Unsupported | Advanced Scheduling | Unsupported |
| Table-level reset | Unsupported | Configurable Replication Methods | Unsupported |
| DATA SELECTION | |||
| Table selection | Unsupported | Column selection | Unsupported |
| Select all | Unsupported | ||
| TRANSPARENCY | |||
| Extraction Logs | Unsupported | Loading Reports | Supported |
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 forversion 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 theAttributes section for each table is a link to Pipedrive’s documentation for that endpoint. Use those links to interact with Pipedrive’s API.
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.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
Replication Method: Full Table
Primary Key:id
Contains Nested Structures?: No
activity_types table contains info about the various activity types in your Pipedrive account.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
Replication Method: Full Table
Primary Key:id
Contains Nested Structures?: No
currencies table contains info about the currencies listed in your Pipedrive account.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive's documentation for a full list and description of each attribute.
Currency ID (id)
active_flag
code
decimal_points
is_custom_flag
name
symbol
Replication Method: Key-based Incremental
Primary Key:id
Contains Nested Structures?: No
deals table contains info about the deals in your Pipedrive account.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
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.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*
While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
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.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*
While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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*
Replication Method: Key-based Incremental
Primary Key:id
Contains Nested Structures?: No
files table contains info about the files in your Pipedrive account.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
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.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
Replication Method: Key-based Incremental
Primary Key:id
Contains Nested Structures?: No
notes table contains info about notes associated with deals.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
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.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
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.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*
While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
Replication Method: Full Table
Primary Key:id
Contains Nested Structures?: No
pipelines table contains info about the pipelines in your account.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive's documentation for a full list and description of each attribute.
Pipeline ID (id)
active
add_time
name
order_nr
selected
url_title
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 theprices__[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_idWhile we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
Replication Method: Full Table
Primary Key:id
Contains Nested Structures?: No
stages table contains info about the stages in each of your pipelines.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive'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
Replication Method: Key-based Incremental
Primary Key:id
Contains Nested Structures?: No
users table contains information about the internal users of your Pipedrive account.While we try to include everything Pipedrive has here,this may not be a full list of attributes. Refer toPipedrive's documentation for a full list and description of each attribute.
User ID (id)
activated
active_flag
created
default_currency
is_admin
is_you
lang
last_login
locale
modified
name
phone
role_id
timezone_name
| Related | Troubleshooting |
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.