OrganizationsInternal
Get details of organizations.
Columns
| Name | Type | ReadOnly | 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. |
| OwnerName | 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. 使用できる値は次のとおりです。1, 3, 5, 7 |
| WonDealsCount | Integer | True |
WonDealsCount. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| UserId | Integer |
User Id. |
| FilterId | Integer |
Filter Id. |