Pipedrive
Pipedrive ETL connector for data replication
Features | Details |
Release Status | Released |
Source API Version | 2.0 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Pipedrive email
pipedrive password |
Replication Type | Full Replication
Key based replication |
Replication Key | NA
lastRunDate |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | ​ |
Deals | DealsSummary |
DealActivities | Notes |
Activities | Stages |
Persons | Files |
Pipelines | Users |
Organisations | Leads |
LeadLabels | LeadSources |
- 1.Signin to Daton
- 2.Select Pipedrive from Integrations page
- 3.Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide your pipedrive email and password to authorize Daton to periodically extract data Pipedrive.
- 5.Post successful authentication you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Deals
Purpose: Returns all deals. For more information on how to get all deals,
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
deal_participants | RECORD |
deal_activities | RECORD |
deal_persons | RECORD |
deal_followers | RECORD |
deal_details | RECORD |
deal_updates | RECORD |
id | NUMERIC |
creator_user_id | RECORD |
user_id | RECORD |
person_id | RECORD |
org_id | RECORD |
stage_id | RECORD |
title | STRING |
value | NUMERIC |
currency | STRING |
add_time | TIMESTAMP |
update_time | TIMESTAMP |
stage_change_time | STRING |
active | BOOLEAN |
deleted | BOOLEAN |
status | STRING |
probability | NUMERIC |
next_activity_date | STRING |
next_activity_time | STRING |
next_activity_id | STRING |
last_activity_id | STRING |
last_activity_date | STRING |
lost_reason | STRING |
visible_to | STRING |
close_time | STRING |
pipeline_id | NUMERIC |
won_time | TIMESTAMP |
first_won_time | TIMESTAMP |
lost_time | TIMESTAMP |
products_count | NUMERIC |
files_count | NUMERIC |
notes_count | NUMERIC |
followers_count | NUMERIC |
email_messages_count | NUMERIC |
activities_count | NUMERIC |
done_activities_count | NUMERIC |
undone_activities_count | NUMERIC |
participants_count | NUMERIC |
expected_close_date | DATE |
last_incoming_mail_time | TIMESTAMP |
last_outgoing_mail_time | TIMESTAMP |
label | STRING |
stage_order_nr | NUMERIC |
person_name | STRING |
org_name | STRING |
next_activity_subject | STRING |
next_activity_type | STRING |
next_activity_duration | STRING |
next_activity_note | STRING |
formatted_value | STRING |
weighted_value | NUMERIC |
formatted_weighted_value | STRING |
weighted_value_currency | STRING |
rotten_time | TIMESTAMP |
owner_name | STRING |
cc_email | STRING |
org_hidden | BOOLEAN |
person_hidden | BOOLEAN |
custom_fields | RECORD |
DealsSummary
Purpose: Returns summary of all the deals.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
values_total | RECORD |
weighted_values_total | RECORD |
total_count | NUMERIC |
total_currency_converted_value | NUMERIC |
total_weighted_currency_converted_value | NUMERIC |
total_currency_converted_value_formatted | STRING |
total_weighted_currency_converted_value_formatted | STRING |
DealActivities
Purpose: Lists activities associated with a deal.
Source-Api documentation: https://developers.pipedrive.com/docs/api/v1/#!/Deals/get_deals_id_activities​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
company_id | NUMERIC |
user_id | NUMERIC |
done | BOOLEAN |
type | STRING |
reference_type | STRING |
reference_id | STRING |
conference_meeting_client | STRING |
conference_meeting_url | STRING |
due_date | DATE |
due_time | STRING |
duration | STRING |
busy_flag | STRING |
add_time | TIMESTAMP |
marked_as_done_time | STRING |
last_notification_time | STRING |
last_notification_user_id | STRING |
notification_language_id | NUMERIC |
subject | STRING |
public_description | STRING |
calendar_sync_include_context | STRING |
location | STRING |
org_id | STRING |
person_id | STRING |
deal_id | NUMERIC |
lead_id | STRING |
lead_title | STRING |
active_flag | BOOLEAN |
update_time | TIMESTAMP |
update_user_id | NUMERIC |
gcal_event_id | STRING |
google_calendar_id | STRING |
google_calendar_etag | STRING |
source_timezone | STRING |
rec_rule | STRING |
rec_rule_extension | STRING |
rec_master_activity_id | STRING |
conference_meeting_id | STRING |
note | STRING |
created_by_user_id | NUMERIC |
location_subpremise | STRING |
location_street_number | STRING |
location_route | STRING |
location_sublocality | STRING |
location_locality | STRING |
location_admin_area_level_1 | STRING |
location_admin_area_level_2 | STRING |
location_country | STRING |
location_postal_code | STRING |
location_formatted_address | STRING |
attendees | RECORD |
participants | RECORD |
series | STRING |
note_clean | STRING |
org_name | STRING |
person_name | STRING |
deal_title | STRING |
owner_name | STRING |
person_dropbox_bcc | STRING |
deal_dropbox_bcc | STRING |
assigned_to_user_id | NUMERIC |
file | STRING |
Notes
Purpose: Returns all notes.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
id | STRING |
user_id | NUMERIC |
deal_id | NUMERIC |
person_id | NUMERIC |
org_id | NUMERIC |
content | STRING |
add_time | TIMESTAMP |
update_time | TIMESTAMP |
active_flag | BOOLEAN |
pinned_to_deal_flag | BOOLEAN |
pinned_to_person_flag | BOOLEAN |
pinned_to_organization_flag | BOOLEAN |
last_update_user_id | STRING |
organization | RECORD |
person | RECORD |
deal | RECORD |
user | RECORD |
Activities
Purpose: Activities are appointments/tasks/events on a calendar that can be associated with a Deal, a Person and an Organization. Activities can be of different type (such as call, meeting, lunch or a custom type - see ActivityTypes object) and can be assigned to a particular User.
Source API Documentation https://developers.pipedrive.com/docs/api/v1/#!/Activities/get_activities​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
activity_details | RECORD |
id | NUMERIC |
company_id | NUMERIC |
user_id | NUMERIC |
done | BOOLEAN |
type | STRING |
reference_type | STRING |
reference_id | STRING |
conference_meeting_client | STRING |
conference_meeting_url | STRING |
due_date | DATE |
due_time | STRING |
duration | STRING |
busy_flag | STRING |
add_time | TIMESTAMP |
marked_as_done_time | TIMESTAMP |
last_notification_time | TIMESTAMP |
last_notification_user_id | STRING |
notification_language_id | NUMERIC |
subject | STRING |
public_description | STRING |
calendar_sync_include_context | STRING |
location | STRING |
org_id | STRING |
person_id | STRING |
deal_id | NUMERIC |
lead_id | STRING |
lead_title | STRING |
active_flag | BOOLEAN |
update_time | TIMESTAMP |
update_user_id | NUMERIC |
gcal_event_id | STRING |
google_calendar_id | STRING |
google_calendar_etag | STRING |
source_timezone | STRING |
rec_rule | STRING |
rec_rule_extension | STRING |
rec_master_activity_id | STRING |
conference_meeting_id | STRING |
note | STRING |
created_by_user_id | NUMERIC |
location_subpremise | STRING |
location_street_number | STRING |
location_route | STRING |
location_sublocality | STRING |
location_locality | STRING |
location_admin_area_level_1 | STRING |
location_admin_area_level_2 | STRING |
location_country | STRING |
location_postal_code | STRING |
location_formatted_address | STRING |
attendees | RECORD |
participants | RECORD |
series | STRING |
org_name | STRING |
person_name | STRING |
deal_title | STRING |
owner_name | STRING |
person_dropbox_bcc | STRING |
deal_dropbox_bcc | STRING |
assigned_to_user_id | NUMERIC |
file | STRING |
Stages
Purpose: Returns data about all stages.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
dealsInStages | RECORD |
id | NUMERIC |
order_nr | NUMERIC |
name | STRING |
active_flag | BOOLEAN |
deal_probability | NUMERIC |
pipeline_id | NUMERIC |
rotten_flag | BOOLEAN |
rotten_days | STRING |
add_time | STRING |
update_time | STRING |
pipeline_name | STRING |
pipeline_deal_probability | BOOLEAN |
Persons
Purpose: Returns all persons
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
person_details | RECORD |
person_deals | RECORD |
person_updates | RECORD |
person_followers | RECORD |
id | NUMERIC |
company_id | NUMERIC |
owner_id | RECORD |
org_id | RECORD |
name | STRING |
first_name | STRING |
last_name | STRING |
open_deals_count | NUMERIC |
related_open_deals_count | NUMERIC |
closed_deals_count | NUMERIC |
related_closed_deals_count | NUMERIC |
participant_open_deals_count | NUMERIC |
participant_closed_deals_count | NUMERIC |
email_messages_count | NUMERIC |
activities_count | NUMERIC |
done_activities_count | NUMERIC |
undone_activities_count | NUMERIC |
files_count | NUMERIC |
notes_count | NUMERIC |
followers_count | NUMERIC |
won_deals_count | NUMERIC |
related_won_deals_count | NUMERIC |
lost_deals_count | NUMERIC |
related_lost_deals_count | NUMERIC |
active_flag | BOOLEAN |
phone | RECORD |
email | RECORD |
first_char | STRING |
update_time | TIMESTAMP |
add_time | TIMESTAMP |
visible_to | STRING |
picture_id | STRING |
next_activity_date |