共用方式為


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.

This operation creates a new deal for the authorized account.

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.

This operation is used to update the stage associated with a deal, given its id.

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

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

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

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

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

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

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

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

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.

Triggers when a new deal is added to the authorized account.

When a new activity is added

Triggers when a new activity is added to the authorized account.

Returns

data

When a new deal is added (V2) (Preview)

Triggers when a new deal is added to the authorized account (V2).

Returns

data

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

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