Release Noteslink

March 2023link

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 2021link

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

October 2021link

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

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

June 2021link

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

May 2021link

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

April 2021link

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 2021link

We now sync the CONTACT table.

February 2021link

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 2021link

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 2020link

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 2020link

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 2019link

We have added a new field, 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 2019link

• 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 Integer to String in the REQUISITION table because Lever's API returns that data type as a String.

November 2018link

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

Link to Lever Documentation