DealsPersons
Get details of deals persons.
Select
The add-in will use 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 add-in.
- Id supports the '=' operator.
- DealId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM DealsPersons SELECT * FROM DealsPersons WHERE DealId = 8
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id. |
| DealId | Integer | Deal Id. |
| ActivitiesCount | Integer | ActivitiesCount. |
| ActiveFlag | Boolean | ActiveFlag. |
| AddTime | Datetime | AddTime. |
| CcEmail | String | CcEmail. |
| ClosedDealsCount | Integer | ClosedDealsCount. |
| CompanyId | Integer | CompanyId. |
| DoneActivitiesCount | Integer | DoneActivitiesCount. |
| String | Email. | |
| EmailMessagesCount | Integer | EmailMessagesCount. |
| FilesCount | Integer | FilesCount. |
| Label | Integer | label. |
| LastActivityDate | Date | LastActivityDate. |
| LastActivityId | Integer | LastActivityId. |
| LastincomingMailTime | String | LastincomingMailTime. |
| Lastname | String | Lastname. |
| LastoutgoingMailTime | String | LastoutgoingMailTime. |
| LostdealsCount | Integer | LostdealsCount. |
| Name | String | Name. |
| NextActivityDate | Date | nextActivityDate. |
| NextActivityId | Integer | nextActivityId. |
| NextActivityTime | String | nextActivityTime. |
| NotesCount | Integer | NotesCount. |
| OpenDealsCount | Integer | OpenDealsCount. |
| OrgActiveFlag | Boolean | OrgActiveFlag. |
| OrgAddress | String | OrgAddress. |
| OrgCcEmail | String | OrgCcEmail. |
| OrgName | String | OrgName. |
| OrgownerId | Integer | OrgownerId. |
| OrgpeopleCount | Integer | OrgpeopleCount. |
| OrgId | Integer | OrgId. |
| OwnerActiveFlag | Boolean | OwnerActiveFlag. |
| OwnerEmail | String | OwnerEmail. |
| OwnerHasPic | Integer | OwnerHasPic. |
| OwnerId | Integer | OwnerId. |
| OwnerName | String | OwnerName. |
| OwnerPicHash | String | OwnerPicHash. |
| OwnerValue | Integer | OwnerValue. |
| ParticipantClosedDealsCount | Integer | ClosedDealsCount. |
| ParticipantOpenDealsCount | Integer | OpenDealsCount. |
| Phone | String | Phone. |
| PictureActiveFlag | Boolean | PictureActiveFlag. |
| PictureaddTime | Datetime | PictureaddTime. |
| PictureaddedByUserId | Integer | PictureaddedByUserId. |
| PictureItemId | Integer | PictureItemId. |
| PictureitemType | String | PictureitemType. |
| Picture128 | String | Picture128. |
| Picture512 | String | Picture512. |
| PictureupdateTime | String | PictureupdateTime. |
| Picturevalue | Integer | Picturevalue. |
| PictureId | String | PictureId. |
| RelatedclosedDealsCount | Integer | RelatedclosedDealsCount. |
| RelatedlostDealsCount | Integer | RelatedlostDealsCount. |
| RelatedopenDealsCount | Integer | RelatedopenDealsCount. |
| RelatedwonDealsCount | Integer | RelatedwonDealsCount. |
| UndoneActivitiesCount | Integer | UndoneActivitiesCount. |
| UpdateTime | Datetime | UpdateTime. |
| VisibleTo | String | visibleTo. |
| WonDealsCount | Integer | WonDealsCount. |
| FirstName | String | First Name. |
| FollowersCount | Integer | Followers Count. |
| PrimaryEmail | String | Primary Email. |
| FirstChar | String | First Char. |
| MarketingStatus | String | Marketing Status. |