CData Python Connector for Greenhouse

Build 24.0.9062

Offers

Query the offers 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 Offers WHERE Id = 2230325147;
SELECT * FROM Offers WHERE ApplicationId = 2450155147;
SELECT * FROM Offers WHERE Status = 'accepted';
SELECT * FROM Offers WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Offers WHERE UpdatedAt = '2024-01-01 12:00:00.000';
SELECT * FROM Offers WHERE ResolvedAt <= '2024-01-01 12:00:00.000';
SELECT * FROM Offers WHERE SentAt >= '2024-01-01 12:00:00.000';
SELECT * FROM Offers WHERE StartsAt = '2024-01-01 12:00:00.000';

Columns

Name Type Operators Description
Id [KEY] Int64 = Offer ID.
Version Int The version number of this offer.
ApplicationId Int64 = Application ID.
JobId Int64 Job ID.
CandidateId Int64 Candidate ID.
CreatedAt Datetime >=,>,<,<=,= The timestamp when the offer was created.
UpdatedAt Datetime >=,>,<,<=,= The timestamp when the offer was updated.
ResolvedAt Datetime >=,>,<,<=,= The timestamp when this offer was resolved.
SentAt Date >=,>,<,<=,= The date when this offer was sent to the candidate.
StartsAt Date >=,>,<,<=,= The date when the candidate starts.
Status String = One of: unresolved, accepted, rejected, deprecated.

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