Pipedrive
Pipedrive ETL connector for data replication

Snapshot

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

Integrate Pipedrive with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Pipedrive from Integrations page
  3. 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. 4.
    Provide your pipedrive email and password to authorize Daton to periodically extract data Pipedrive.
  5. 5.
    Post successful authentication you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Pipedrive Data

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
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.
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
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.
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
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
Files
Purpose: Returns data about all files.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
id
NUMERIC
user_id
NUMERIC
deal_id
STRING
person_id
NUMERIC
org_id
NUMERIC
product_id
STRING
activity_id
STRING
log_id
STRING
add_time
TIMESTAMP
update_time
TIMESTAMP
file_name
STRING
file_type
STRING
file_size
NUMERIC
active_flag
BOOLEAN
inline_flag
BOOLEAN
remote_location
STRING
remote_id
STRING
cid
STRING
s3_bucket
STRING
Pipelines
Purpose: Returns data about all pipelines.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
dealConversionRatesInPipelines
RECORD
dealsInPipelines
RECORD
id
NUMERIC
name
STRING
url_little
STRING
order_nr
NUMERIC
active
BOOLEAN
deal_probability
BOOLEAN
add_time
TIMESTAMP
update_time
TIMESTAMP
selected
BOOLEAN
Users
Purpose: Returns data about all users within the company.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
id
NUMERIC
name
STRING
default_currency
STRING
locale
STRING
email
STRING
phone
STRING
created
TIMESTAMP
modified
TIMESTAMP
lang
NUMERIC
active_flag
BOOLEAN
is_admin
NUMERIC
last_login
STRING
signup_flow_variation
STRING
role_id
NUMERIC
has_created_company
BOOLEAN
activated
BOOLEAN
timezone_name
STRING
timezone_offset
STRING
icon_url
STRING
Organisations
Purpose: Returns all organizations
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
organisation_updates
RECORD
organisation_persons
RECORD
organisation_followers
RECORD
organisation_activities
RECORD
organisation_deals
RECORD
organisation_details
RECORD
id
NUMERIC
company_id
NUMERIC
owner_id
RECORD
name
STRING
open_deals_count
NUMERIC
related_open_deals_count
NUMERIC
closed_deals_count
NUMERIC
related_closed_deals_count
NUMERIC
email_messages_count
NUMERIC
people_count
NUMERIC
activities_count
NUMERIC
done_activities_count
NUMERIC
undone_activities_count
NUMERIC
Leads
Purpose: Returns multiple Leads.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
STRING
title
STRING
owner_id
NUMERIC
creator_id
NUMERIC
label_ids
STRING
value
RECORD
expected_close_date
DATE
note
STRING
person_id
STRING
organization_id
STRING
is_archived
BOOLEAN
source_name
STRING
was_seen
BOOLEAN
next_activity_id
STRING
add_time
TIMESTAMP
update_time
TIMESTAMP
LeadLabels
Purpose: Returns details of all Lead Labels.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
STRING
name
STRING
color
STRING
add_time
TIMESTAMP
update_time
TIMESTAMP
LeadSources
Purpose: Returns all Lead Sources.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
name
STRING
Last modified 1yr ago