Teams
Retrieve teams from Streak. Users can be on 0 or more teams.
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 Teams is TeamKey. For example:
SELECT * FROM Teams WHERE TeamKey='agxzfm1haWxmb29nYWVyEabSBFRlYW0YgICsv_OxuAoM'
Columns
| Name | Type | References | Description |
| TeamKey [KEY] | String | Key of the team. | |
| Name | String | Name of the team. | |
| CreationDate | Timestamp | When the team was created. | |
| Creator | String | The creator of the team. | |
| PlanInstanceKey | String | Key of the instance plan. | |
| PlanInstance | String | Name of the instance plan. | |
| SharingRestrictedToTeam | Boolean | Whether sharing is restricted to this team or not. | |
| LastSavedTimestamp | Timestamp | When the team record was last saved. |