Info_Users
Query the Users in the organization.
Table Specific Information
Select
Retrieve all Users.
SELECT * FROM Info_Users
Retrieve all Users of a specific Group.
SELECT * FROM Info_Users WHERE GroupId = '2928085806875091'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the user. | |
| AccountId | String | The Id of the associated account. | |
| AccountName | String | The name of the associated account. | |
| String | The email address of the user. | ||
| Name | String | The full name of the user. | |
| FirstName | String | The first name of the user. | |
| LastName | String | The last name of the user. | |
| Admin | Boolean | Whether the user is a system admin. A system admin can manage users and accounts. | |
| Locale | String | The locale for the user. | |
| TimeZone | String | The timezone for the user. | |
| LicensedSheetCreator | Boolean | Whether the user is a licensed user. A licensed user can create and own sheets. | |
| GroupAdmin | Boolean | Whether the user is a group admin. A group admin can create and edit groups. | |
| ResourceViewer | Boolean | Whether the user is a resource viewer. A resource viewer can access resource views. | |
| Status | String | The status of the user. Possible values: ACTIVE, PENDING, DECLINED. | |
| GroupId | String | The Id of the group. | |
| Company | String | The company of the user. This column is only populated when an Id filter is specified. | |
| Department | String | The department of the user. This column is only populated when an Id filter is specified. | |
| MobilePhone | String | The mobile phone number of the user. This column is only populated when an Id filter is specified. | |
| LastLogin | String | The last login time of the user. This is only populated if the user has logged in, and when an Id filter is specified. | |
| Role | String | The role of the user. This column is only populated when an Id filter is specified. | |
| Title | String | The title of the user. This column is only populated when an Id filter is specified. | |
| WorkPhone | String | The work phone number of the user. This column is only populated when an Id filter is specified. |