Info_Users
Read and write users data in your Smartsheet account.
Table-specific information
SELECT
Retrieve all users.SELECT * FROM Info_Users
Retrieve all users in a specific group.
SELECT * FROM Info_Users WHERE GroupId = '2928085806875091'
INSERT
You can create a user in your Smartsheet account by providing the Email, LicensedSheetCreator and Admin columns as shown in the example query below.INSERT INTO Info_Users (Email, LicensedSheetCreator, Admin) VALUES ('[email protected]', true, true)
UPDATE
You can update user data by providing the Id column in the criteria as shown in the example query below.UPDATE Info_Users SET FirstName = 'My Test', LastName = 'User 1', Admin = false, GroupAdmin = false, LicensedSheetCreator = false WHERE Id = '8307802553771908'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier assigned to each user, used to differentiate them within the system. | |
| AccountId | String | True |
The unique identifier of the account to which the user belongs, establishing account association. | |
| AccountName | String | True |
The name of the account associated with the user, providing a human-readable reference. | |
| String | False |
The email address registered for the user, used for communication and login purposes. | ||
| Name | String | True |
The user's full name as it appears in the system, combining first and last name. | |
| FirstName | String | False |
The user's first name, typically used in personal greetings and identification. | |
| LastName | String | False |
The user's last name, often used for formal identification. | |
| Admin | Boolean | False |
Indicates whether the user is a system administrator with privileges to manage accounts and other users. | |
| Locale | String | True |
The language and regional settings associated with the user, impacting date formats and other locale-specific elements. | |
| TimeZone | String | True |
The user's timezone, used to localize date and time information across the platform. | |
| LicensedSheetCreator | Boolean | False |
Indicates if the user holds a license to create and own sheets within the system. | |
| GroupAdmin | Boolean | False |
Specifies whether the user can create and manage groups, granting them group admin privileges. | |
| ResourceViewer | Boolean | False |
Indicates if the user has access to view resource management features such as workload views. | |
| Status | String | True |
The current status of the user within the system. Possible values include: ACTIVE, PENDING, or DECLINED. | |
| GroupId | String | True |
The unique identifier of the group to which the user belongs, if applicable. | |
| Company | String | True |
The name of the company the user is associated with. Populated only when filtering by user Id. | |
| Department | String | True |
The department within the company that the user is part of. Populated only when filtering by user Id. | |
| MobilePhone | String | True |
The user's mobile phone number. This field is populated only when filtering by user Id. | |
| LastLogin | String | True |
The timestamp of the user's last login. Only populated if the user has logged in and an Id filter is applied. | |
| Role | String | True |
The role or position of the user within their organization. Populated only when filtering by user Id. | |
| Title | String | True |
The professional title of the user within their organization. Populated only when filtering by user Id. | |
| WorkPhone | String | True |
The user's work phone number. This field is populated only when filtering by user Id. | |
| SendEmail | Boolean | False |
Whether to send an email to the user's email address once they are created (invited in the Smartsheet account). This columns always returns null in SELECT statements, and is supposed to be used in INSERT statements only. |