Users
Query the users of the organization.
SELECT
Note: Filters provided with one of the supported operators listed in the "Operators" column can be processed server-side, all the other filters are processed client-side.
SELECT * FROM Users WHERE Id = 4034588007;
SELECT * FROM Users WHERE PrimaryEmailAddress = '[email protected]';
SELECT * FROM Users WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Users WHERE UpdatedAt >= '2024-01-01 12:00:00.000' AND UpdatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Users WHERE EmployeeId = '5534588007';
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | User ID. |
| Name | String | The full name of the user. | |
| FirstName | String | The first name of the user. | |
| LastName | String | The last name of the user. | |
| PrimaryEmailAddress | String | = | The e-mail address this user has designated as his or her primary e-mail address. |
| CreatedAt | Datetime | >=,>,<,<=,= | The timestamp when the user was created. |
| UpdatedAt | Datetime | >=,>,<,<=,= | The timestamp when the user was last updated. |
| Disabled | Bool | Whether the user is disabled or not. | |
| SiteAdmin | Bool | If true, this user is a site admin, which means the user has full permissions on all non-private jobs. | |
| Emails | String | Comma-delimited list of emails. | |
| EmployeeId | String | = | The employee ID of the user. |
| LinkedCandidateIds | String | Comma-delimited list of IDs of the candidate records. | |
| DepartmentIds | String | Comma-delimited list of department IDs the candidate is associated with. | |
| Departments | String | Array of departments the user is associated with. | |
| OfficeIds | String | Comma-delimited list of office IDs the candidate is associated with. | |
| Offices | String | Array of offices the user is associated with. |