Pipedrive
Pipedrive is a CRM & pipeline management tool that helps you focus on actions that matter.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://www.pipedrive.com/ |
| Privacy policy | https://www.pipedrive.com/privacy |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| API Key | securestring | API Key | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
| Frequency of trigger polls | 1 | 120 seconds |
Actions
| Add activity |
This operation is used to create a new activity for the authorized account. |
| Add deal (V2) (Preview) |
This operation creates a new deal for the authorized account. |
| Add deal [DEPRECATED] |
This action has been deprecated. Please use Add deal (V2) instead.
|
| Get deal by id |
This operation retrieves all details of an existing deal, given its id. |
| Get stage by id |
This operation returns data about a specific stage. |
| Update deal stage (V2) (Preview) |
This operation is used to update the stage associated with a deal, given its id. |
| Update deal stage [DEPRECATED] |
This action has been deprecated. Please use Update deal stage (V2) instead.
|
| Update deal status |
This operation is used to update the status associated with a deal, given its id. |
Add activity
This operation is used to create a new activity for the authorized account.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Type
|
type | True | string |
Activity type. |
|
Subject
|
subject | True | string |
Subject of the activity. |
|
Due Date
|
due_date | string |
YYYY-MM-DD |
|
|
Due Time
|
due_time | string |
HH:MM |
|
|
Duration
|
duration | string |
HH:MM |
|
|
Notes
|
note | string | ||
|
Assigned to
|
user_id | integer |
Id of the user whom the activity will be assigned to. |
|
|
Deal Id
|
deal_id | integer |
ID of deal the activity will be associated with. |
|
|
Contact Id
|
person_id | integer |
Id of person the activity will be associated with. |
|
|
Organization Id
|
org_id | integer |
ID of the organization the activity will be associated with. |
Returns
data
- Body
- ActivityResponse
Add deal (V2) (Preview)
This operation creates a new deal for the authorized account.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Title
|
title | True | string |
Title of the deal. |
|
Pipeline Id
|
pipeline_id | string |
The id of the pipeline to fetch stages from. |
|
|
Stage Id
|
stage_id | string |
Stage of the deal. |
|
|
Status
|
status | string |
Status of the deal. |
|
|
Value
|
value | integer |
Monetary value of the deal. |
|
|
Currency
|
currency | string |
Currency of the deal. |
|
|
Contact Id
|
person_id | string |
User id of person the deal is associated with. |
|
|
Organization Id
|
org_id | string |
Id of the organization associated with the deal. |
|
|
Expected Close Date
|
expected_close_date | string |
yyyy-MM-dd |
|
|
Visiblity
|
visible_to | string |
Owner, followers or entire company. |
Returns
data
- Body
- DealResponseV2
Add deal [DEPRECATED]
This action has been deprecated. Please use Add deal (V2) instead.
This operation creates a new deal for the authorized account.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Title
|
title | True | string |
Title of the deal. |
|
Stage Id
|
stage_id | string |
Stage of the deal. |
|
|
Status
|
status | string |
Status of the deal. |
|
|
Value
|
value | integer |
Monetary value of the deal. |
|
|
Currency
|
currency | string |
Currency of the deal. |
|
|
Contact Id
|
person_id | string |
User id of person the deal is associated with. |
|
|
Organization Id
|
org_id | string |
Id of the organization associated with the deal. |
|
|
Expected Close Date
|
expected_close_date | string |
yyyy-MM-dd |
|
|
Visiblity
|
visible_to | string |
Owner, followers or entire company. |
Returns
data
- Body
- DealResponse
Get deal by id
This operation retrieves all details of an existing deal, given its id.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Deal Id
|
dealId | True | integer |
Deal |
Returns
data
- Body
- DealResponse
Get stage by id
This operation returns data about a specific stage.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Stage Id
|
stageId | True | integer |
Stage Id |
Returns
- Body
- StageResponse
Update deal stage (V2) (Preview)
This operation is used to update the stage associated with a deal, given its id.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Deal Id
|
dealId | True | integer |
Deal |
|
Pipeline Id
|
pipeline_id | True | string |
The id of the pipeline to fetch stages from. |
|
Stage Id
|
stage_id | True | string |
Stage of the deal. |
|
Expected Close Date
|
expected_close_date | string |
yyyy-MM-dd |
Returns
data
- Body
- DealResponseV2
Update deal stage [DEPRECATED]
This action has been deprecated. Please use Update deal stage (V2) instead.
This operation is used to update the stage associated with a deal, given its id.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Deal Id
|
dealId | True | integer |
Deal |
|
Stage Id
|
stage_id | True | string |
Stage of the deal. |
|
Expected Close Date
|
expected_close_date | string |
yyyy-MM-dd |
Returns
data
- Body
- DealResponse
Update deal status
This operation is used to update the status associated with a deal, given its id.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Deal Id
|
dealId | True | integer |
Deal |
|
Status
|
status | True | string |
Status of the deal. |
|
Lost Reason
|
lost_reason | string |
Message about why the deal was lost. |
Returns
data
- Body
- DealResponse
Triggers
| When a new activity is added |
Triggers when a new activity is added to the authorized account. |
| When a new deal is added (V2) (Preview) |
Triggers when a new deal is added to the authorized account (V2). |
| When a new deal is added [DEPRECATED] |
This action has been deprecated. Please use When a new deal is added (V2) instead.
|
When a new activity is added
When a new deal is added (V2) (Preview)
When a new deal is added [DEPRECATED]
This action has been deprecated. Please use When a new deal is added (V2) instead.
Triggers when a new deal is added to the authorized account.
Returns
data
- Body
- DealResponse
Definitions
StageResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Stage Id
|
id | integer |
Stage Id |
|
Stage Name
|
name | string |
Stage name |
ActivityResponse
data
| Name | Path | Type | Description |
|---|---|---|---|
|
Activity Id
|
id | integer |
Unique id of the activity. |
|
User Id
|
user_id | integer |
Id of the user whom the activity is assigned to. |
|
Is Done
|
done | boolean |
0 = Not done, 1 = Done |
|
Type
|
type | string |
Type of the activity. |
|
Due Date
|
due_date | string |
YYYY-MM-DD |
|
Due Time
|
due_time | string |
HH:MM |
|
Duration
|
duration | string |
HH:MM |
|
Subject
|
subject | string |
Subject of the activity. |
|
Deal Id
|
deal_id | integer |
Id of deal the activity is associated with. |
|
Deal Title
|
deal_title | string |
Title of deal the activity is associated with. |
|
Organization Id
|
org_id | integer |
Id of organization the activity is associated with. |
|
Organization Name
|
org_name | string |
Name of organization the activity is associated with. |
|
Contact Id
|
person_id | integer |
Id of person the activity is associated with. |
|
Contact Name
|
person_name | string |
Name of person the activity is associated with. |
|
Created Date-Time
|
add_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Updates Date-Time
|
update_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Completed Date-Time
|
marked_as_done_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Google Calendar Event Id
|
gcal_event_id | string |
Id of the google calendar event. |
|
Google Calendar Id
|
google_calendar_id | string |
Id of the google calendar. |
|
Note
|
note | string |
Note of the activity (HTML format). |
|
Assigned to
|
assigned_to_user_id | integer |
User id of user whom the activity is assigned to. |
|
Created by
|
created_by_user_id | integer |
User id of user that created the activity. |
|
Owner Name
|
owner_name | string |
Name of the activity owner. |
DealResponse
data
| Name | Path | Type | Description |
|---|---|---|---|
|
Deal Id
|
id | integer |
Id of the deal. |
|
Id
|
creator_user_id.id | integer |
Id of the deal creator. |
|
Name
|
creator_user_id.name | string |
Name of the deal creator. |
|
Email
|
creator_user_id.email | string |
Email of the deal creator. |
|
Id
|
user_id.id | integer |
Id of the deal owner. |
|
Name
|
user_id.name | string |
Name of the deal owner. |
|
Email
|
user_id.email | string |
Email of the deal owner. |
|
Name
|
person_id.name | string |
Name of the person associated with the deal. |
|
Id
|
person_id.value | integer |
Id of the person associated with the deal. |
|
Name
|
org_id.name | string |
Name of the organization associated with the deal. |
|
Id
|
org_id.value | integer |
Id of the organization associated with the deal. |
|
Status
|
status | string |
Open, won, lost or deleted. |
|
Deal Title
|
title | string |
Title of the deal. |
|
Deal Value
|
value | number |
Monetary value of the deal. |
|
Currency
|
currency | string |
Currency associated with the deal value. |
|
Created Date-Time
|
add_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Updated Date-Time
|
update_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Stage Id
|
stage_id | integer |
ID of stage the deal is placed in a pipeline. |
|
Stage Name
|
stage_name | string |
Name of stage the deal is placed in a pipeline |
|
Stage Uodated Date-Time
|
stage_change_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Is Active
|
active | boolean |
True if the deal is active. |
|
Is Deleted
|
deleted | boolean |
True if the deal has been deleted. |
|
Next Activity Date
|
next_activity_date | string |
yyyy-MM-dd |
|
Next Activity Time
|
next_activity_time | string |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Next Activity Id
|
next_activity_id | integer |
Id of the next activity. |
|
Last Activity Id
|
last_activity_id | integer |
Id of the last activity. |
|
Last Activity Date
|
last_activity_date | string |
yyyy-MM-dd |
|
Lost Reason
|
lost_reason | string |
Message about why the deal was lost (to be used when status=lost). |
|
Visiblity
|
visible_to | string |
Owner, followers or entire company. |
|
Closed Date-Time
|
close_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Pipeline Id
|
pipeline_id | integer |
Id of pipeline the deal is associated with. |
|
Products Count
|
products_count | integer |
Number of products associated with the deal. |
|
Files Count
|
files_count | integer |
Number of files associated with the deal. |
|
Notes Count
|
notes_count | integer |
Number of notes associated with the deal. |
|
Followers Count
|
followers_count | integer |
Number of followers associated with the deal. |
|
Email Message Count
|
email_messages_count | integer |
Number of email messages associated with the deal. |
|
Activities Count
|
activities_count | integer |
Number of activities associated with the deal. |
|
Done Activities Count
|
done_activities_count | integer |
Number of done activities associated with the deal. |
|
Undone Activities Count
|
undone_activities_count | integer |
Number of undone activitie associated with the deals. |
|
Referenced Activities Count
|
reference_activities_count | integer |
Number of referenced activities associated with the deal. |
|
Participants Count
|
participants_count | integer |
Number of participants associated with the deal. |
|
Expected Close Date
|
expected_close_date | string |
yyyy-MM-dd |
|
Next Activity Subject
|
next_activity_subject | string |
Subject of next activity associated with the deal. |
|
Next Activity Type
|
next_activity_type | string |
Type of next activity associated with the deal. |
|
Next Activity Duration
|
next_activity_duration | string |
Duration of next activity associated with the deal. |
|
Next Activity Note
|
next_activity_note | string |
Notes for next activity associated with the deal |
DealResponseV2
data
| Name | Path | Type | Description |
|---|---|---|---|
|
Deal Id
|
id | integer |
Id of the deal. |
|
Id
|
creator_user_id.id | integer |
Id of the deal creator. |
|
Name
|
creator_user_id.name | string |
Name of the deal creator. |
|
Email
|
creator_user_id.email | string |
Email of the deal creator. |
|
Id
|
user_id.id | integer |
Id of the deal owner. |
|
Name
|
user_id.name | string |
Name of the deal owner. |
|
Email
|
user_id.email | string |
Email of the deal owner. |
|
Name
|
person_id.name | string |
Name of the person associated with the deal. |
|
Id
|
person_id.value | integer |
Id of the person associated with the deal. |
|
Name
|
org_id.name | string |
Name of the organization associated with the deal. |
|
Id
|
org_id.value | integer |
Id of the organization associated with the deal. |
|
Status
|
status | string |
Open, won, lost or deleted. |
|
Deal Title
|
title | string |
Title of the deal. |
|
Deal Value
|
value | number |
Monetary value of the deal. |
|
Currency
|
currency | string |
Currency associated with the deal value. |
|
Created Date-Time
|
add_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Updated Date-Time
|
update_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Stage Id
|
stage_id | integer |
ID of stage the deal is placed in a pipeline. |
|
Stage Uodated Date-Time
|
stage_change_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Is Active
|
active | boolean |
True if the deal is active. |
|
Is Deleted
|
deleted | boolean |
True if the deal has been deleted. |
|
Next Activity Date
|
next_activity_date | string |
yyyy-MM-dd |
|
Next Activity Time
|
next_activity_time | string |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Next Activity Id
|
next_activity_id | integer |
Id of the next activity. |
|
Last Activity Id
|
last_activity_id | integer |
Id of the last activity. |
|
Last Activity Date
|
last_activity_date | string |
yyyy-MM-dd |
|
Lost Reason
|
lost_reason | string |
Message about why the deal was lost (to be used when status=lost). |
|
Visiblity
|
visible_to | string |
Owner, followers or entire company. |
|
Closed Date-Time
|
close_time | date-time |
yyyy-MM-ddTHH:mm:ss.fffZ |
|
Pipeline Id
|
pipeline_id | integer |
Id of pipeline the deal is associated with. |
|
Products Count
|
products_count | integer |
Number of products associated with the deal. |
|
Files Count
|
files_count | integer |
Number of files associated with the deal. |
|
Notes Count
|
notes_count | integer |
Number of notes associated with the deal. |
|
Followers Count
|
followers_count | integer |
Number of followers associated with the deal. |
|
Email Message Count
|
email_messages_count | integer |
Number of email messages associated with the deal. |
|
Activities Count
|
activities_count | integer |
Number of activities associated with the deal. |
|
Done Activities Count
|
done_activities_count | integer |
Number of done activities associated with the deal. |
|
Undone Activities Count
|
undone_activities_count | integer |
Number of undone activitie associated with the deals. |
|
Referenced Activities Count
|
reference_activities_count | integer |
Number of referenced activities associated with the deal. |
|
Participants Count
|
participants_count | integer |
Number of participants associated with the deal. |
|
Expected Close Date
|
expected_close_date | string |
yyyy-MM-dd |
|
Next Activity Subject
|
next_activity_subject | string |
Subject of next activity associated with the deal. |
|
Next Activity Type
|
next_activity_type | string |
Type of next activity associated with the deal. |
|
Next Activity Duration
|
next_activity_duration | string |
Duration of next activity associated with the deal. |
|
Next Activity Note
|
next_activity_note | string |
Notes for next activity associated with the deal |