TeamMembers
Retrieve members of teams. 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 TeamMembers is TeamKey. For example:
SELECT * FROM TeamMembers WHERE TeamKey='agxzfm1haWxmb29nYWVabQsSBFRlYW0YgICsv_OxuAoM'
Columns
| Name | Type | References | Description |
| TeamKey [KEY] | String |
Teams.TeamKey | Key of the team. |
| UserKey [KEY] | String |
Users.UserKey | Key of the user on the team. |
| DisplayName | String | Display name of the team member. | |
| FullName | String | Full name of the team member. | |
| Role | String | Role of the team member. | |
| InviteDate | Timestamp | When the member was invited. | |
| InviteStatus | String | Status of the invitation. | |
| OrgKey | String | It is a unique encrypted code that identifies the team that you are on. | |
| String | Email address for the team member. | ||
| Image | String | Url to an image of the member. |