Greenhouse

Greenhouse is a recruitment and onboarding platform which optimizes and automates the hiring process.

Data integration: Skyvia supports importing data to and from Greenhouse, exporting Greenhouse data to CSV files, replicating Greenhouse data to relational databases and synchronizing Greenhouse data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Greenhouse.

Query: Skyvia Query supports Greenhouse.

Establishing Connection

To create a connection to Greenhouse, enter your API Key. If you want to load data to Greenhouse, and not just read data from Greenhouse, you also need to specify your User Id.

Getting Credentials

Getting the API Key

API Key — Greenhouse API token. You can read more about creating an Greenhouse API Key here.

You need sign in as a user that has the “Can manage ALL organization’s API Credentials” permission in the “Developer permission” section to create the API key. To get a new Greenhouse API Key, perform the following steps:

  1. Sign in to Greenhouse.

  2. Click the gear icon in the top menu.

    Greenhouse Dashboard menu

  3. Select Dev Center and then API Credential Management.

    Greenhouse Dev Center

  4. Click New API Key.

    Greenhouse API Settings

  5. In the API Type list, select Harvest.

  6. Enter an optional key description, and click Manage Permissions.

    Creating Greenhouse API Key

  7. Copy the API Key and store it in a safe place.

    API Key is available for full copying only once when it is created. Later on it will be half hidden. So paste your API Key to a safe place (word document, etc).

  8. Select the Select All checkbox and click Save at the bottom of the page.

    Greenhouse API Key permissions

Getting the User Id

If you don’t know your User Id, you can omit it for now. The easiest way to find your user Id is to create a read-only connection, first. Then obtain your User Id with above instructions, edit the connection, specify it and save the connection.

The easiest way to obtain your Greenhouse user ID is via one of the Skyvia tools — Query or Export. Both of these ways can be used even within the limits of the free pricing plan.

To get user ids via Query, perform the following steps:

  1. Click +NEW in the top menu.
  2. Under Query, click Builder.
  3. Click Select connection on the left and select your Greenhouse connection.

  4. Scroll down the object list on the left till you see the Users object. Drag it to the Results pane.

    Greenhouse API Key

  5. After this, you can see your Greenhouse users’ data. Find the corresponding user in the table and copy the value from the Id column of the corresponding row.

    Greenhouse Users' data

Alternatively, you can use Skyvia Export to get the contents of the Users object to a CSV file and copy User Id from this file.

Creating Connection

Connection Editor window

To start creating a connection, follow the below steps:

  1. In the Connection Editor, enter your API Key
  2. If you know your User Id (an integer value identifying the Greenhouse user) and want a read-write connection to Greenhouse, enter your User Id. Otherwise, the connection will be read-only.

Connector Specifics

Object Peculiarities

Candidates

When importing data to the Candidates object, specify the Applications field as a JSON array, as in example:

[{"job_id": 215725}, {"job_id": 185289}]

UserJobPermissions and UserFutureJobPermissions

UserJobPermissions and UserFutureJobPermissions objects do not support import of records with UserId containing Ids of a user with the job admin role.

CandidateTags

When importing data to the CandidateTags object, the TagId and CandidateId fields are not displayed in the integration logs after execution.

Applications

Greenhouse API supports several options of creating applications for candidates. Every option may have different set of fields required for mapping. Thus, we defined only the CandidateId as field as required for mapping. Other fields may be required depending on the option of record creation.

DML Operations Support

Skyvia supports DML operations for such Greenhouse objects

Operation Object
INSERT, UPDATE, DELETE Applications, Candidates, ScheduledInterviews
INSERT, UPDATE Departments, Jobs, Offices, Users
INSERT, DELETE CandidateTags, Tags, UserFutureJobPermissions, UserJobPermissions
INSERT JobOpenings
UPDATE JobPosts

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for such Greenhouse objects: Applications, Candidates, EmailTemplates, JobPosts, Jobs, JobStages, Offers, ScheduledInterviews, ScoreCards, Users.

Skyvia supports Synchronization for such Greenhouse objects: Applications, Candidates, Jobs, ScheduledInterviews, Users.

Supported Actions

Skyvia supports all the common actions for Greenhouse.

On This Page