Airbyte integration – Greenhouse Support

Airbyte is the modern open-source ELT standard that replicates data from the long tail of APIs, databases & files to data warehouses, lakes and other destinations. Airbyte Cloud disrupts the ELT market with its transparent compute-based pricing and open-source extensibility.

Airbyte integration with Greenhouse Recruiting allows retrieving data from your account and loading it into any data warehouses, lakes or databases, in minutes in the format you need with post-load transformation.

Create a Harvest API key

To configure the integration, you’ll need to create a Harvest API key.

Follow the steps in this article to create the key, and verify that the permissions below are selected when configuring the Airbyte integration. Copy the API key as you’ll need to paste it in Airbyte in the next step.

Credentials

In the Create New Credential box, make the following selections:

API Type: Harvest
Partner: Airbyte or Unlisted Vendor
Description: Airbyte Harvest API Key

Permissions

Verify that the following permissions are selected for the Airbyte integration:

Activity Feed:
- GET: Retrieve Activity Feed
Applications
- GET: List Applications
Scheduled Interviews
- GET: List Scheduled Interviews for Application
Demographic Data
- GET: List Demographic Answers For Application
- GET: List Demographic Answers
- GET: List Demographic Answer Options
- GET: List Demographic Answer Options For Demographic Question
- GET: List Demographic Questions
- GET: List Demographic Question Sets
- GET: List Demographic Questions For Demographic Question Set
Approvals
- GET: List Approvals For Job
Candidates
- GET: List Candidates
Close Reasons
- GET: List Close Reasons
Custom Fields
- GET: List Custom Fields
Departments
- GET: List Departments
Education
- GET: List Degrees
- GET: List Disciplines
- GET: List Schools
EEOC
- GET: List EEOC
Email Templates
- GET: List Email Templates
Scheduled Interviews
- GET: List Scheduled Interviews
Job Posts
- GET: List Job Posts
Job Stages
- GET: List Job Stages
- GET: List Job Stages for Job
Jobs
- GET: List Jobs
Job Openings
- GET: List Job Openings
Offers
- GET: List Offers
Offices
- GET: List Offices
Prospect Pools
- GET: List Prospect Pools
Rejection Reasons
- GET: List Rejection Reasons
Scorecards
- GET: List Scorecards
Sources
- GET: List Sources
Tags
- GET: List Candidate Tags
Users
- GET: List Users
User Permissions
- GET: List Job Permissions
User Roles
- GET: List User Roles

Add the Harvest API key to Airbyte

Go to https://cloud.airbyte.com and login with your credentials

Choose ‘New connection' option:

Choose ‘Setup a new source’ option:

Choose Marketplace type of connectors:

In the input field enter ‘Greenhouse’

Choose Greenhouse connector:

Input your API key in ‘API key’ field and choose ‘Set up source’:

After this need to choose Destination where data should be stored and configure the Greenhouse Source connector schema.

Use the integration

When a Greenhouse user is authenticated, the destination where data from the Greenhouse account should be moved needs to be chosen. Airbyte has a big list of data warehouse destination connectors like BigQuery, SnowFlake, Postgres, S3, Google Sheets, etc.

After Destination setup, users need to define records from which Greenhouse streams (API endpoints) they want to retrieve and move to chosen Destination. Currently we support 36 streams and all of them can be chosen. Also sync mode can be defined. Some streams support Incremental and Fullrefresh modes and some only Fullrefresh mode. More details about sync modes can be found here.