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