Release Notes

November 2024

The Lever connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

September 2024

You can now select to allow or deny syncing the confidential data while setting up a Lever connector. This functionality is enabled by default for connectors created after July 29, 2024.

July 2024

We have made the following changes to the Schema tab for connectors created on or after July 27, 2024:

• We display all table names in lowercase
• We display all the tables, including the empty tables
• We no longer support table-level selection or deselection for syncing
• The connector will sync only the Opportunity endpoint and its child endpoints

We have made the following schema changes for connectors created on or after July 27, 2024:

• Added the following tables:

  • FEEDBACK_FORM_SCORE_CARD_SUB_FIELD
  • FEEDBACK_FORM_TEMPLATE_FIELD
  • POSTING_FORM_SCORE_CARD_SUB_FIELD
  • POSTING_FORM_TEMPLATE_FIELD
  • PROFILE_FORM_SCORE_CARD_SUB_FIELD
  • PROFILE_FORM_TEMPLATE_FIELD
  • REFERRAL_FORM_SCORE_CARD_SUB_FIELD
  • REFERRAL_FORM_TEMPLATE_FIELD

• Removed the SCORE_CARD_SUB_FIELD and TEMPLATE_FIELD tables

• Renamed the USER table to USERS

• Renamed the primary key tag to tags in the OPPORTUNITY_TAG and POSTING_TAG tables

March 2023

We have added the EU Region toggle to the connector setup form. Set the toggle to ON if your application is in the EU region. For more information, see our setup guide.

December 2021

We have added a new column, hiring_manager_id, to the POSTING table.

October 2021

We have added the following new columns to the REQUISITION table:

• approval_id
• approval_status
• approval_startedAt
• approval_approvedAt
• approval_accountId
• approval_createdBy

June 2021

We can now sync confidential opportunities to the OPPORTUNITY table. Previously, we were only able to sync non-confidential opportunities.

May 2021

We have added a new column, closedAt, to the REQUISITION table.

April 2021

We have added the following new columns to the OFFER table:

• sent_document_file_name
• sent_document_download_url
• sent_document_uploaded_at
• signed_document_file_name
• signed_document_download_url
• signed_document_uploaded_at

March 2021

We now sync the CONTACT table.

February 2021

We have added a new table, POSTING_DISTRIBUTION_CHANNEL, which contains your postings' distribution channel information. The POSTING_DISTRIBUTION_CHANNEL table is a child table of the POSTING table.

January 2021

We have released pre-built, dbt Core-compatible data models for Lever. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

July 2020

We now support Lever's Opportunity endpoint. The Opportunity endpoint replaces the deprecated Candidate endpoint. In addition to our existing access, grant Fivetran access to the Opportunity endpoint in your Lever dashboard, then add the regenerated API key to the connector setup form in your Fivetran dashboard. Fivetran automatically triggers a historical sync when we connect to this endpoint, so you do not need to manually re-sync your data.

We have made some schema changes to support the new Opportunity endpoint. Once you connect Fivetran to the Opportunity endpoint, we will add new tables to replace the following tables:

• OPPORTUNITY will replace CANDIDATE
• CONTACT_EMAIL will replace CANDIDATE_EMAIL
• CONTACT_LINK will replace CANDIDATE_LINK
• CONTACT_PHONE will replace CANDIDATE_PHONE
• OPPORTUNITY_POSITION will replace CANDIDATE_POSITION
• OPPORTUNITY_SCHOOL will replace CANDIDATE_SCHOOL
• OPPORTUNITY_SOURCE will replace CANDIDATE_SOURCE
• OPPORTUNITY_STAGE_HISTORY will replace CANDIDATE_STAGE_HISTORY
• OPPORTUNITY_TAG will replace CANDIDATE_TAG

June 2020

We have fixed a bug where deleted records were incorrectly synced to your destination. Previously, deleted rows had false as their _fivetran_deleted value, but they now have true as their _fivetran_deleted value. Any previously synced deleted records will be corrected in your next sync.

October 2019

We have added a new column, to_stage_index, to the CANDIDATE_STAGE_HISTORY table.

We now sync the REQUISITION table during every data sync. Previously, we synced this table every 24 hours.

In the REQUISITION table, we have converted the target_hire_date column's data type from TIMESTAMP to INSTANT.

April 2019

We have added three new tables:

• PANEL
• PANEL_APPLICATION
• PANEL_INTERVIEW

We have changed the data types of head_count_total, head_count_hired, and head_count_infinite from INT to STRING in the REQUISITION table because Lever's API returns that data type as a STRING.

November 2018

Lever is a modern recruiting software that streamlines the hiring process and simplifies the applicant tracking system.

Read our Lever connector documentation.