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. |