DealsParticipants
Returns the persons participating in a specific deal, along with their contact details and relationship data.
Table-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| ItemDealId | = |
For example, the following query is processed server-side:
SELECT * FROM DealsParticipants WHERE ItemDealId = 9
INSERT
Execute INSERT by specifying the ItemDealId and PersonId columns. You can also insert any optional columns. For example:
INSERT INTO DealsParticipants (ItemDealId, PersonId) VALUES (4, 6)
DELETE
Execute DELETE by specifying the Id in the WHERE clause. For example:
DELETE FROM DealsParticipants WHERE Id = 14 AND ItemDealId = 17
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier of the participant record. | |
| ActiveFlag | Boolean | True |
Indicates whether this participant record is active. | |
| AddTime | Datetime | True |
The date and time when this participant was added to the deal. | |
| AddedByactiveFlag | Boolean | True |
Indicates whether the user who added this participant is currently active. | |
| AddedByemail | String | True |
The email address of the user who added this participant. | |
| AddedByhasPic | Integer | True |
Indicates whether the user who added this participant has a profile picture. | |
| AddedByid | Integer | True |
The unique identifier of the user who added this participant. | |
| AddedByname | String | True |
The full name of the user who added this participant. | |
| AddedBypicHash | String | True |
The profile picture hash for the user who added this participant. | |
| AddedByvalue | Integer | True |
The numeric user identifier value for the user who added this participant. | |
| PersonActiveFlag | Boolean | True |
Indicates whether the participant's person record is currently active. | |
| ActivitiesCount | Integer | True |
The total number of activities associated with the participant's person record. | |
| PersonAddTime | Datetime | True |
The date and time when the participant's person record was created. | |
| CcEmail | String | True |
The BCC email address that links correspondence to the participant's person record in Pipedrive. | |
| ClosedDealsCount | Integer | True |
The number of closed deals associated with the participant's person record. | |
| CompanyId | Integer | True |
The identifier of the Pipedrive company account associated with the participant's person record. | |
| DoneActivitiesCount | Integer | True |
The number of completed activities linked to the participant's person record. | |
| String | True |
The email addresses associated with the participant's person record. | ||
| EmailMessagesCount | Integer | True |
The number of email messages linked to the participant's person record. | |
| FilesCount | Integer | True |
The number of files attached to the participant's person record. | |
| FirstChar | String | True |
The first character of the participant's name, used for alphabetical indexing. | |
| FirstName | String | True |
The first name of the participant. | |
| FollowersCount | Integer | True |
The number of Pipedrive users following the participant's person record. | |
| Personlabel | String | True |
The label assigned to the participant's person record for categorization. | |
| LastActivityDate | Date | True |
The date of the most recent activity linked to the participant's person record. | |
| LastActivityId | Integer | True |
The unique identifier of the most recent activity linked to the participant's person record. | |
| LastincomingMailTime | String | True |
The timestamp of the most recent incoming email received for the participant's person record. | |
| Lastname | String | True |
The last name of the participant. | |
| LastoutgoingMailTime | String | True |
The timestamp of the most recent outgoing email sent for the participant's person record. | |
| LostdealsCount | Integer | True |
The number of lost deals associated with the participant's person record. | |
| Name | String | True |
The full name of the participant. | |
| NextActivityDate | Date | True |
The scheduled date of the next activity linked to the participant's person record. | |
| NextActivityId | Integer | True |
The unique identifier of the next scheduled activity linked to the participant's person record. | |
| NextActivityTime | String | True |
The scheduled time of the next activity linked to the participant's person record. | |
| NotesCount | Integer | True |
The number of notes attached to the participant's person record. | |
| OpenDealsCount | Integer | True |
The number of open deals associated with the participant's person record. | |
| OrgActiveFlag | Boolean | True |
Indicates whether the organization linked to the participant's person record is currently active. | |
| OrgAddress | String | True |
The address of the organization linked to the participant's person record. | |
| OrgCcEmail | String | True |
The BCC email address for the organization linked to the participant's person record. | |
| OrgName | String | True |
The name of the organization linked to the participant's person record. | |
| OrgownerId | Integer | True |
The unique identifier of the owner of the organization linked to the participant's person record. | |
| OrgpeopleCount | Integer | True |
The number of people associated with the organization linked to the participant's person record. | |
| OrgId | Integer | True |
The unique identifier of the organization associated with the participant's person record. | |
| OwnerActiveFlag | Boolean | True |
Indicates whether the owner of the participant's person record is currently active. | |
| OwnerEmail | String | True |
The email address of the owner of the participant's person record. | |
| OwnerHasPic | Integer | True |
Indicates whether the owner of the participant's person record has a profile picture. | |
| OwnerId | Integer | True |
The unique identifier of the owner of the participant's person record. | |
| OwnerName | String | True |
The full name of the owner of the participant's person record. | |
| OwnerPicHash | String | True |
The profile picture hash for the owner of the participant's person record. | |
| OwnerValue | Integer | True |
The numeric identifier value for the owner of the participant's person record. | |
| ParticipantClosedDealsCount | Integer | True |
The number of closed deals in which this person participates as a non-primary contact. | |
| ParticipantOpenDealsCount | Integer | True |
The number of open deals in which this person participates as a non-primary contact. | |
| Phone | String | True |
The phone numbers associated with the participant's person record. | |
| PictureId | String | True |
The identifier of the profile picture attached to the participant's person record. | |
| RelatedclosedDealsCount | Integer | True |
The number of closed deals related to the participant through organizational or ownership links. | |
| RelatedlostDealsCount | Integer | True |
The number of lost deals related to the participant through organizational or ownership links. | |
| RelatedopenDealsCount | Integer | True |
The number of open deals related to the participant through organizational or ownership links. | |
| RelatedwonDealsCount | Integer | True |
The number of won deals related to the participant through organizational or ownership links. | |
| SyncNeeded | Boolean | True |
Indicates whether the participant's person record requires synchronization with an external system. | |
| UndoneActivitiesCount | Integer | True |
The number of incomplete activities linked to the participant's person record. | |
| UpdateTime | Datetime | True |
The date and time when the participant's person record was last modified. | |
| VisibleTo | String | True |
The visibility setting that controls which users can see the participant's person record. | |
| WonDealsCount | Integer | True |
The number of won deals associated with the participant's person record. | |
| PersonIdActiveFlag | Boolean | True |
Indicates whether the person linked via the participant identifier is currently active. | |
| Personemail | String | True |
The email addresses of the person linked via the participant identifier. | |
| Personname | String | True |
The full name of the person linked via the participant identifier. | |
| Personphone | String | True |
The phone numbers of the person linked via the participant identifier. | |
| PersonValues | Integer | True |
The numeric identifier value for the person linked to this participant. | |
| ItemDealId [KEY] | Integer | False |
Deals.id |
The unique identifier of the deal this participant is associated with. |
| ItemTitle | String | True |
The title of the deal this participant is associated with. | |
| ItemId | Integer | True |
The identifier of the related item linked to this participant record. | |
| ItemType | String | True |
The type of the related item linked to this participant record. | |
| PersonId | Integer | False |
Persons.Id |
The unique identifier of the person participating in the deal. |
| PersonOrgName | String | True |
The name of the organization associated with the participant's person record. | |
| PersonOwnerName | String | True |
The name of the user who owns the participant's person record. |