PersonsInternal
Get all details of persons.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
Id. |
| ActiveFlag | Boolean | False |
ActiveFlag. |
| ActivitiesCount | Integer | True |
ActivitiesCount. |
| AddTime | Datetime | False |
Optional creation date time of the person Requires admin user API token. Format: YYYY-MM-DD HH:MM:SS |
| CcEmail | String | True |
CcEmail. |
| ClosedDealsCount | Integer | True |
ClosedDealsCount. |
| CompanyId | Integer | True |
CompanyId. |
| CustomeField | String | True |
CustomeField you will get the result of this column only when criteria filter title is used. |
| DoneActivitiesCount | Integer | True |
DoneActivitiesCount. |
| String | False |
Email. | |
| EmailMessagesCount | Integer | True |
EmailMessagesCount. |
| FilesCount | Integer | True |
FilesCount. |
| FirstChar | String | True |
If supplied, only persons whose name starts with the specified letter will be returned. |
| FirstName | String | True |
FirstName. |
| FollowersCount | Integer | True |
FollowersCount. |
| Label | Integer | True |
Label. |
| LastActivityDate | Date | True |
LastActivityDate. |
| LastActivityId | Integer | True |
LastActivityId. |
| LastIncomingMailTime | Datetime | True |
LastIncomingMailTime. |
| LastName | String | True |
LastName. |
| LastOutgoingMailTime | Datetime | True |
LastOutgoingMailTime. |
| LostDealsCount | Integer | True |
LostDealsCount. |
| Name | String | False |
Name. |
| NextActivityDate | Date | True |
NextActivityDate. |
| NextActivityId | Integer | True |
NextActivityId. |
| NextActivityTime | Time | True |
NextActivityTime. |
| Notes | String | True |
Notes. |
| NotesCount | Integer | True |
NotesCount. |
| OpenDealsCount | Integer | True |
OpenDealsCount. |
| OrgActiveFlag | Boolean | True |
OrgActiveFlag. |
| OrgAddress | String | True |
OrgAddress. |
| OrgccEmail | String | True |
OrgccEmail. |
| OrgName | String | True |
OrgName. |
| OrgownerId | Integer | True |
OrgownerId. |
| OrgpeopleCount | Integer | True |
OrgpeopleCount. |
| Orgvalue | Integer | False |
Orgvalue. |
| OwnerActiveFlag | Boolean | True |
OwnerActiveFlag. |
| OwnerEmail | String | True |
OwnerEmail. |
| OwnerHasPic | Integer | True |
OwnerHasPic. |
| OwnerId | Integer | False |
OwnerId. |
| OwnerName | String | True |
OwnerName. |
| OwnerPicHash | String | True |
OwnerPicHash. |
| OwnerValue | Integer | True |
OwnerValue. |
| ParticipantClosedDealscount | Integer | True |
ParticipantClosedDealscount. |
| ParticipantOpenDealsCount | Integer | True |
ParticipantOpenDealsCount. |
| Phone | String | False |
Phone. |
| PictureActiveFlag | Boolean | True |
PictureActiveFlag. |
| PictureAddTime | Datetime | True |
PictureAddTime. |
| PictureAddedByUserId | Integer | True |
PictureAddedByUserId. |
| PictureItemId | Integer | True |
PictureItemId. |
| PictureItemType | String | True |
PictureItemType. |
| Picture128 | String | True |
Picture128. |
| Picture512 | String | True |
Picture512. |
| PictureUpdateTime | String | True |
PictureUpdateTime. |
| Picturevalue | Integer | True |
Picturevalue. |
| RelatedClosedDealsCount | Integer | True |
RelatedClosedDealsCount. |
| RelatedLostDealsCount | Integer | True |
RelatedLostDealsCount. |
| RelatedOpenDealsCount | Integer | True |
RelatedOpenDealsCount. |
| RelatedWonDealsCount | Integer | True |
RelatedWonDealsCount. |
| UndoneActivitiesCount | Integer | True |
UndoneActivitiesCount. |
| UpdateTime | Datetime | True |
UpdateTime. |
| VisibleTo | String | False |
Visibility of the person. The allowed values are 1, 3. |
| WonDealsCount | Integer | True |
WonDealsCount. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| FilterId | Integer |
Filter Id. |
| UserId | Integer |
User Id. |