Power BI Connector for Greenhouse

Build 24.0.9062

JobPosts

Query the job posts 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 JobPosts WHERE Id = 4221228237;
SELECT * FROM JobPosts WHERE JobId = 5831224147;
SELECT * FROM JobPosts WHERE Internal = TRUE;
SELECT * FROM JobPosts WHERE Active = FALSE;
SELECT * FROM JobPosts WHERE Live = TRUE;
SELECT * FROM JobPosts WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM JobPosts WHERE UpdatedAt = '2024-01-01 12:00:00.000';

Columns

Name Type Operators Description
Id [KEY] Int64 = Job post ID.
Title String Title of the job post.
LocationId Int64 The ID of the location of the job.
LocationName String The name of the location of the job.
Internal Bool = If true, the job post has been posted (or is to be posted) on an internal job board.
External Bool If true, the job post has been posted (or is to be posted) on an external job board.
Active Bool = If false, the job post has been deleted.
Live Bool = If true, the job post status is set to live.
FirstPublishedAt Datetime The timestamp when the job post was first set to live.
JobId Int64 = The ID of the job that the job post is for
Content String The text of the job post as posted to the external job board.
InternalContent String The text of the job post if posted to the internal job board, if different than the external job board.
UpdatedAt Datetime >=,>,=,<,<= The timestamp when the job post was last updated.
CreatedAt Datetime >=,>,=,<,<= The timestamp when the job post was created.
DemographicQuestionSetId Int64 The demographic question set associated with the job post.
Questions String An array of questions associated with the job post.

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