Organizations
Retrieve organizations from Streak.
Table Specific Information
Select
Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available column for Organizations is OrganizationKey. For example:
SELECT * FROM Organizations WHERE OrganizationKey='VGVhbU9yZ2FuaXphdGlvbix-fnN0cmVab2xvbmdpZH5-NDkyMjAwNDI3MDE1MzcyOA'
Columns
| Name | Type | References | Description |
| OrganizationKey [KEY] | String |
BoxesOrganizations.OrganizationKey | Key of the organization. |
| TeamKey | String |
Teams.TeamKey | Key of the team. |
| Name | String | Full name of the organization. | |
| Other | String | Extra information about the organization. | |
| Domains | String | List of domains. | |
| NormalizedDomains | String | List of domains normalized. | |
| Industry | String | The industry of the organization. | |
| PhoneNumbers | String | List of phone numbers. | |
| Addresses | String | List of addresses. | |
| EmployeeCount | String | Number of employees. | |
| LogoURL | String | The logo URL. | |
| TwitterHandle | String | The Twitter URL. | |
| FacebookHandle | String | The Facebook URL. | |
| LinkedinHandle | String | Linked-in Handle URL. | |
| LastEnrichmentTimestamp | Timestamp | When the organizations was enriched. | |
| ContactLinks | String | List of contact links. | |
| LastSavedUserKey | String |
Users.UserKey | Key of the user who last modified the organization. |
| CreatorKey | String |
Users.UserKey | Key of the user who created the organization. |
| CreationDate | Timestamp | When the organization was created. | |
| VersionTimestamp | Timestamp | Version of the time stamp. | |
| LastSavedTimestamp | Timestamp | When the organization was last saved. |