Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Pipedrive Data

We’re currently doing some private testing on our Pipedrive integration. Want to be a part of it? Get in touch with us.

Now that Pipedrive is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

Replicating Pipedrive Data

Historical Sync

By default, a historical sync of Pipedrive data goes back one year from the Stitch connection date.

Frequency

Stitch will replicate Pipedrive data based on the frequency you define. The default setting is every 30 minutes, but you can change it better suit your needs.

Replication Method

The majority of Pipedrive data is replicated using Incremental Replication. This means that every time Pipedrive data is queued for replication, only new and updated rows will be replicated to your data warehouse.

There are a few exceptions to this, however. The following tables use Full Table Replication, which means that all rows - including new, existing, and updated - will be replicated during each sync:

  • pipedrive_ctivity_types
  • pipedrive_currencies
  • pipedrive_goals
  • pipedrive_pipelines
  • pipedrive_stages

Pipedrive Tables in Your Data Warehouse

Below is a list of the main and subtables that will be created in your data warehouse. Because Pipedrive uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables. Refer to the Handling of Nested Data Structures doc for more info.

Click the table name to check out the Pipedrive documentation for that table. If you still have your API Token handy, you can enter it on Pipedrive’s website to interact directly with their API and see your data in raw JSON format.

pipedrive_activities
Primary Key:
_id

The pipedrive_activities table contains information about the activities (calls, tasks, lunches, etc.) in your Pipedrive account.

Attributes include the activity ID (id), company ID, user ID, done flag, type, reference type and ID, due date and time, duration, subject, deal ID and title, organization ID and name, person ID and name, active flag, Google Calendar info, notes, assigned to user ID, created by user ID, owner name, person and deal dropbox BCC addresses, and added at and updated at dates.

pipedrive_activity_types
Primary Key:
_id

The pipedrive_activity_types table contains information about the various activity types in your Pipedrive account.

Attributes include the activity type ID (id), order number, name, key string, icon key, active flag, color, custom flag, and added and updated at times.

pipedrive_currency
Primary Key:
_id

The pipedrive_currency table contains information about the currencies listed in your Pipedrive account.

Attributes include the currency ID (id), code, name, decimal point setting, symbol, active flag, and custom flag.

pipedrive_deals
Primary Key:
_id

The pipedrive_deals table contains information about the deals in your Pipedrive account.

Attributes include the deal ID (id), stage ID, title, value, currency, active and deleted flags, status, next activity info, last activity info, lost reason, pipeline ID, won and lost times, product count, file count, note count, follower count, email messages count,  creator info, user info, organization info, and added and updated at dates.

pipedrive_email_messages
Primary Key:
_id

The pipedrive_email_messages table contains information about the email messages sent and received through your Pipedrive account. Your Pipedrive account must have the Mailbox feature enabled to replicate this data.

Attributes include the 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, and include body flags; read time, language code, reply to message ID, sent error, attachment count, draft parameters, person IDs, organization IDs, and message, added, and updated at times.

Subtables
The composite keys for the following tables - made up of the email message ID and row ID - can be used to them to their parent, pipedrive_email_messages: _sdc_source_key_id:_sdc_level_0_id

  • pipedrive_email_messages__to - This subtable contains data about the people email messages iare sent to. This includes the recipient’s name, email address, person ID, and user ID.
  • pipedrive_email_messages__from - This subtable contains data about the people who sent the message. This includes the sender’s name, email address, person ID, and user ID.

pipedrive_email_threads
Primary Key:
_id

The pipedrive_email_threads table contains information about the email threads in your Pipedrive account. Individual emails are organized into threads.

Attributes include the email thread ID (id), company ID, user ID, deal ID, counts for total messages and unread messages, first and last message subjects, last message summary, first and last message times, replied and shared flags, last message attachment count, last message CC and BCC, active flag, attachment count, draft messages count, party (those on the email thread) info, organization IDs, and added and updated at dates.

Subtables
The composite keys for the following tables - made up of the email thread ID and row ID - can be used to join them to their parent, pipedrive_email_threads: _sdc_source_key_id:_sdc_level_0_id

  • pipedrive_email_threads__last_message_from - This subtable contains details about the person who sent the last message in the email thread.
  • pipedrive_email_threads__last_message_to - This subtable contains details about the person who received the last message in the email thread.
  • pipedrive_email_threads__labels - This subtable contains data about the labels applied to email threads.

pipedrive_files
Primary Key:
_id

The pipedrive_files table contains information about the files in your Pipedrive account.

Attributes include the file ID (id), name, type, size, active and inline flags, remote location and ID, cid, S3 bucket, deal name, person name, organization name, product name, URL, description, and added updated at dates.

There are also columns containing the IDs for: user, deal, person, organization, product, email message, activity, and mail message.

pipedrive_filters
Primary Key:
_id

The pipedrive_filters table contains information about the filters that can be applied to Deals, Persons, Organizations, Products, and Activities in your Pipedrive account.

Attributes include the filter ID (id), name, active flag, type, temporary flag, user ID, visibility setting, custom view ID, and added and updated at dates.

pipedrive_goals
Primary Key:
_id

The pipedrive_goals table contains information about the goals, or sales targets, in your Pipedrive account.

Attributes include the goal ID (id), company ID, user ID, stage ID, active goal ID, period, expected, active flag, goal type, expected sum, currency, expected type, created by user ID, pipeline ID, delivered count, delivered sum, period start and end, user name, and added date.

pipedrive_notes
Primary Key:
_id

The pipedrive_notes table contains information about notes associated with deals.

Attributes include the note ID (id), user ID and details, deal ID and title, organization ID and name, note content, active flag, pinned to deal, person, and organization flags, last update user ID, and added and updated at dates.

pipedrive_organizations
Primary Key:
_id

The pipedrive_organizations table contains information about the organizations - or the companies you’re doing deals with - in your Pipedrive account.

Attributes include the organization ID (id), company ID, owner ID, name, active flag, category ID, picture ID, country code, first character, visibility setting, next and last activity details, address info, CC email address,  and added and updated dates.

This table also includes total counts for open/closed deals, email messages, people, done, undone, and reference activities; files, notes, followers, and won/lost deals.

pipedrive_persons
Primary Key:
_id

The pipedrive_persons table contains information about the ‘persons’ in your Pipedrive account. These are the customers you’re doing deals with.

Attributes include the person ID (id), company ID, owner ID, organization ID, first and last name, first character, next/last activity details, last incoming/outgoing mail times, organization name, CC email, and added and updated at dates.

This table also includes counts for: open/closed deals, participant open/closed deals, email messages, done/undone/reference activities, files, notes, followers, and won/lost deals.

Subtables
The composite key for these tables - made up of the person ID and row ID - can be used to tie them back to their parent, pipedrive_persons: _sdc_value_key_id:_sdc_level_0_id

  • pipedrive_persons__phone  - This subtable contains the person’s phone info.
  • pipedrive_persons__email - This subtable contains the person’s email info.

pipedrive_pipelines
Primary Key:
_id

The pipedrive_pipelines table contains information about the pipelines in your account.

Attributes include the pipeline ID (id), name, order number, URL title, active flag, selected flag, and added at date.

pipedrive_products
Primary Key:
_id

The pipedrive_products table contains information about the products in your account. Products must be enabled in your account, or there’ll be no data for Stitch to replicate.

Attributes include the product ID (id), name, code, unit, tax, active flag, selectable flag, first character, visibility setting, owner ID, file count, followers count, and pricing info.

pipedrive_stages
Primary Key:
_id

The pipedrive_stages table contains information about the stages in each of your pipelines.

Attributes include the stage ID (id), order number, name, deal probability, active flag, pipeline ID and name, rotten flag, rotten days, and added and updated at dates.

pipedrive_users
Primary Key:
_id

The pipedrive_users table contains information about the internal users of your Pipedrive account.

Attributes include the user ID (id), name, default currency, locale, language setting, email address, phone number, activation setting, admin setting, role ID, timezone, icon URL, and created, modified, and last login dates.

Related:

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!