OrganizationsInternal
Get details of organizations.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
Id. | |
| ActiveFlag | Boolean | True |
ActiveFlag. | |
| ActivitiesCount | Integer | True |
ActivitiesCount. | |
| AddTime | Datetime | False |
Optional creation date time of the organization in UTC. Requires admin user API token. Format: YYYY-MM-DD HH:MM:SS | |
| Address | String | True |
Address. | |
| AdminArealevel1 | String | True |
AdminArealevel1. | |
| AdminArealevel2 | String | True |
AdminArealevel2. | |
| Country | String | True |
Country. | |
| FormattedAddress | String | True |
FormattedAddress. | |
| Locality | String | True |
Locality. | |
| PostalCode | String | True |
PostalCode. | |
| Route | String | True |
Route. | |
| StreetNumber | String | True |
StreetNumber. | |
| Sublocality | String | True |
Sublocality. | |
| Subpremise | String | True |
Subpremise. | |
| CcEmail | String | True |
CcEmail. | |
| CustomeField | String | True |
CustomeField you will get the result of this column only when criteria filter title is used. | |
| ClosedDealsCount | Integer | True |
ClosedDealsCount. | |
| CompanyId | Integer | True |
CompanyId. | |
| CountryCode | String | True |
CountryCode. | |
| DoneActivitiesCount | Integer | True |
DoneActivitiesCount. | |
| EmailMessagesCount | Integer | True |
EmailMessagesCount. | |
| FilesCount | Integer | True |
FilesCount. | |
| FirstChar | String | True |
FirstChar. | |
| FollowersCount | Integer | True |
FollowersCount. | |
| Label | Integer | True |
Label. | |
| LastActivityDate | Date | True |
LastActivityDate. | |
| LastActivityId | Integer | True |
LastActivityId. | |
| LostDealsCount | Integer | True |
LostDealsCount. | |
| Name | String | False |
Name. | |
| NextActivityDate | Date | True |
NextActivityDate. | |
| NextActivityId | Integer | True |
NextActivityId. | |
| NextActivityTime | Time | True |
NextActivityTime. | |
| NotesCount | Integer | True |
NotesCount. | |
| OpenDealsCount | Integer | True |
OpenDealsCount. | |
| OwneractiveFlag | Boolean | True |
Owneractive_flag. | |
| OwnerEmail | String | True |
OwnerEmail. | |
| OwnerHasPic | Boolean | True |
OwnerHasPic. | |
| OwnerId | Integer | False |
OwnerId. | |
| OwnerIdName | String | True |
OwnerName. | |
| OwnerPicHash | String | True |
OwnerPicHash. | |
| OwnerIdValue | Integer | True |
OwnerIdValue. | |
| PeopleCount | Integer | True |
PeopleCount. | |
| 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. | |
| PictureId | Integer | True |
PictureIid. | |
| RelatedClosedDealsCount | Integer | True |
RelatedClosedDealsCount. | |
| RelatedLostDealsCount | Integer | True |
RelatedLostDealsCount. | |
| RelatedOpenDealsCount | Integer | True |
RelatedOpenDealsCount. | |
| RelatedWonDealsCount | Integer | True |
RelatedWonDealsCount. | |
| Type | String | True |
Type you will get the result of this column only when criteria filter title is used. | |
| UndoneActivitiesCount | Integer | True |
UndoneActivitiesCount. | |
| UpdateTime | Datetime | True |
UpdateTime. | |
| VisibleTo | Integer | False |
Visibility of the organization. The allowed values are 1, 3, 5, 7. | |
| WonDealsCount | Integer | True |
WonDealsCount. | |
| OwnerName | String | True |
Owner Name. |
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 |
| UserId | Integer |
User Id. |
| FilterId | Integer |
Filter Id. |