CData Python Connector for Greenhouse

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062