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