# Pipedrive (v05-10-2016)

Information note **Pipedrive (v05-10-2016) end of life**

This 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.](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive)

## 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](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Sunset on December 18, 2018 | **Supported by**<br><br>the Info icon<br><br>Indicates if the integration is supported by Stitch or the Singer community. | [Singer Community](https://www.singer.io/) |
| **Stitch plan**<br><br>the Info icon<br><br>The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**<br><br>the Info icon<br><br>Indicates if the integration is available as a source in Stitch Connect. | the Remove icon<br><br>This version of the integration isn't available via the API.<br><br><br>Not available |
| **Singer GitHub repository** | Not applicable |  |  |
| **REPLICATION SETTINGS** |  |  |  |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Remove icon<br><br>Anchor Scheduling is not supported for this integration. The only available replication scheduling method is the Replication Frequency setting.<br><br><br>Unsupported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**<br><br>the Info icon<br><br>A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Remove icon<br><br>Advanced Scheduling is not supported for this integration.<br><br><br>Unsupported |
| **Table-level reset**<br><br>the Info icon<br><br>Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon<br><br>Table-level resets are not supported for this integration. Resets are only supported at the integration level.<br><br><br>Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**<br><br>the Info icon<br><br>Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon<br><br>Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.<br><br><br>Unsupported |
| **DATA SELECTION** |  |  |  |
| **Table selection**<br><br>the Info icon<br><br>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. | the Remove icon<br><br>Table selection is not supported for this integration. All available table and fields will be automatically selected for replication.<br><br><br>Unsupported | **Column selection**<br><br>the Info icon<br><br>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. | the Remove icon<br><br>Column selection is not supported for this integration. All available columns in tables set to replicate will be selected.<br><br><br>Unsupported |
| **Select all**<br><br>the Info icon<br><br>Indicates if the integration supports selecting all available tables and columns. | the Remove icon<br><br>As this integration doesn't support table or column selection, all available tables and columns are automatically replicated.<br><br><br>Unsupported |  |  |
| **TRANSPARENCY** |  |  |  |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**<br><br>the Info icon<br><br>Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Remove icon<br><br>This feature is not supported for this version of the integration.<br><br><br>Unsupported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**<br><br>the Info icon<br><br>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. | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |

## Pipedrive table reference

Information note

**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 Replication Method: Full Table Full Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job. Primary Key: id Contains Nested Structures?: No The activity\_types table contains info about the various activity types in your Pipedrive account. Table Info & Attributes

### 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](https://developers.pipedrive.com/v1#methods-ActivityTypes) 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

Full Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `currencies` table contains info about the currencies listed in your Pipedrive account.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#currencies-data)

### 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](https://developers.pipedrive.com/v1#methods-Currencies) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `deals` table contains info about the deals in your Pipedrive account.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#deals-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** Yes

If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.

The `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.**

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#email_messages-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](https://developers.pipedrive.com/v1#methods-Recents) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** Yes

If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.

The `email_threads` table contains info about the email threads in your Pipedrive account. Individual emails are organized into threads.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#email_threads-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `files` table contains info about the files in your Pipedrive account.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#files-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

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

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#filters-data)

### 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](https://developers.pipedrive.com/v1#methods-Filters) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `notes` table contains info about notes associated with deals.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#notes-data)

### 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](https://developers.pipedrive.com/v1#methods-Recent) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

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

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#organizations-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** Yes

If your destination doesn't natively support nested structures, Stitch will de-nest them and create subtables. See Table Info for details.

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

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#persons-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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

Full Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `pipelines` table contains info about the pipelines in your account.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#pipelines-data)

### 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](https://developers.pipedrive.com/v1#methods-Pipelines) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `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.**

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#products-data)

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__currency `
* `prices__usd__id`
* `prices__usd__overhead_cost`
* `prices__usd__price`
* `prices__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](https://developers.pipedrive.com/v1#methods-Recents) 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

Full Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

The `stages` table contains info about the stages in each of your pipelines.

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#stages-data)

### 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](https://developers.pipedrive.com/v1#methods-Stages) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

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

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#users-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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

Key-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.

  
**Primary Key:** `id`   
**Contains Nested Structures?:** No

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

[Table Info & Attributes](https://help.qlik.com/en-US/stitch/integrations/saas/pipedrive/v05-10-2016#activities-data)

### 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](https://developers.pipedrive.com/v1#methods-Recents) 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