OrganizationsPersons
Get details of organizations 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.
- OrgId supports the '=' operator.
- Id supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM OrganizationsPersons WHERE OrgId = 10
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id |
| ActivitiesCount | Integer | ActivitiesCount |
| ActiveFlag | Boolean | ActiveFlag |
| AddTime | Datetime | AddTime |
| CcEmail | String | CcEmail |
| ClosedDealsCount | Integer | ClosedDealsCount |
| CompanyId | Integer | CompanyId |
| DoneActivitiesCount | Integer | DoneActivitiesCount |
| String | ||
| 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 |
| OrgIdName | String | OrgName |
| OrgownerId | Integer | OrgownerId |
| OrgpeopleCount | Integer | OrgpeopleCount |
| OrgId | Integer | OrgId |
| OwnerActiveFlag | Boolean | OwnerActiveFlag |
| OwnerEmail | String | OwnerEmail |
| OwnerHasPic | Boolean | OwnerHasPic |
| OwnerId | Integer | OwnerId |
| OwnerName | String | OwnerName |
| OwnerPicHash | String | OwnerPicHash |
| OwnerValue | Integer | OwnerValue |
| ParticipantClosedDealsCount | Integer | ParticipantClosedDealsCount |
| ParticipantOpenDealsCount | Integer | ParticipantOpenDealsCount |
| 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 | Followes Count. |
| PrimaryEmail | String | Primary Email. |
| FirstChar | String | First Char. |
| MarketingStatus | String | Marketing Status. |
| OrgName | String | Org name. |