This article explains how to connect Greenhouse with Pigment to retrieve Greenhouse Offers, Jobs or Openings data into a Pigment block.
Table of contents
As with all other native Pigment integrations, you’ll first need to configure a Connection in the Integration library page. Once configured, this connection can be used by any Application that is authorized as a data source. These authorized Apps are defined during the ‘Import Data’ configuration step. Now, let’s see how to configure and use this native integration!
Prerequisites
You need to be a Pigment Workspace Admin to be allowed to configure the connector.
For Greenhouse you need these Permissions: Basic users and above who can manage ALL organization’s API credentials
Collecting the Greenhouse API Token to set up the connection
Follow these steps to generate an API key in Greenhouse for your connection.
- API Type: Harvest
- Partner: leave this dropdown blank.
- Description: Pigment Harvest API Key
This is the one and only time these API credentials will be available for viewing. Each key is unique, and for security purposes, you won’t be able to view it after it has been generated.
Please store this API key in a safe place.
Don’t forget to grant the following permissions to the key (greenhouse doc):
- Offers > GET: List Offers
- Jobs > GET: List Jobs
- Custom Fields > GET: List Custom Fields
Setting up the Greenhouse Connector
- Once you sign into Pigment, click on Settings in the bottom left corner. Next, navigate to the Integrations page, and click on “+ Add” on the Greenhouse integration.
| 
|
Load Greenhouse Offers data into Pigment
Once the Greenhouse Connection is configured, open an Application that the connection is available on and open the “Import Data” interface for the object you want to import data into. For example, if you were importing data into a Transactions, you would open up list and then select Import and Download and then Import.
Instead of “Upload file”, select the Integration option. From here, select the Greenhouse Connection you just configured.
Note
If you do not see the connection, navigate back to Integrations page, and verify that Application is on the Application Access list.
Now, you just need to select Offers Data Type and click on Start Import. You can filter on the Offer Status, or select All results available regardless of status to load all data.
The data should load in Pigment within a few seconds!
Load Greenhouse Jobs data into Pigment
Follow the same steps as for Offers but select Jobs as Data type.
Note on how the array-type fields in the Jobs object are handled during the import into Pigment
Departments: data from the first 3 elements of this array-type field will be loaded. Even if there is no data in this field, you will still see extra columns, but they will contain null data.
Offices: same as Departments – data from the first 3 elements of this array-type field will be loaded. Even if there is no data in this field, you will still see extra columns, but they will contain null data.
Hiring Team: Data from this field will not be loaded.
Load Greenhouse Openings data into Pigment
Follow the same steps as for Offers but select Openings as Data type. The Job ID is loaded here as well so you can map each opening to the job.