Users
Retrieve users details.
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 Users is UserKey. For example:
SELECT * FROM Users WHERE UserKey='agxzfm1haWxmb29nYWVyLAsSDE9yZ2abaXphdGlvbiIJY2RhdGEuY29tDAsSBFVzZXIYgICs35ruuwkM'
Columns
| Name | Type | References | Description |
| UserKey [KEY] | String | Key of a user. | |
| String | The email address of the the user. | ||
| OrgKey | String | It is a unique encrypted code that identifies the team that you are on. | |
| CreationTimestamp | Timestamp | When the user was created. | |
| LastUpdatedTimestamp | Timestamp | When the user was last updated. | |
| LastSeenTimestamp | Timestamp | When the user last logged into Streak. | |
| TimezoneId | String | Id of current time zone. | |
| UsedPlatforms | String | List of platforms that are being used. | |
| GoogleProfileId | String | ID of the user's google profile. | |
| GoogleProfilePhotoUrl | String | Profile Photo URL on the user's google profile. | |
| GoogleProfileLink | String | Link to the user's google profile. | |
| GoogleProfileFullName | String | Full Name on the user's google profile. | |
| GoogleProfileFirstName | String | First Name on the user's google profile. | |
| GoogleProfileLastName | String | Last Name on the user's google profile. | |
| GoogleProfileGender | String | Gender on the user's google profile. | |
| GoogleProfileLocale | String | Locale on the user's google profile. | |
| GoogleAnalyticsClientId | String | Analytics Client Id on the user's google profile. | |
| IsOauthComplete | Boolean | Whether the user has completed the OAuth process. Useful to determine whether they can successfully share emails. | |
| DisplayName | String | A display friendly name, usually the users full name if it exists in their profile. | |
| Experiments | String | List of experiments. | |
| TourId | String | The tour id. | |
| UserSettingsKey | String | Key to the user's settings information. | |
| LastTrialLength | Integer | Length of a last trial. | |
| OnTrialWithoutCreditCard | Boolean | Whether the trial is without credit card or not. | |
| CanceledTrial | Boolean | Whether the trial is cancelled or not. | |
| FirstOauthTimestamp | Timestamp | When the first OAuth connection was done. | |
| WantsTaskDigestEmail | Boolean | Whether task digest email is required or not. | |
| LastSavedTimestamp | Timestamp | When the user was last saved. |