Lever integration summary

Stitch’s Lever integration replicates data using the Lever API (v1). Refer to the Schema section for a list of objects available for replication.

Lever feature snapshot

A high-level look at Stitch's Lever (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on June 1, 2020

Supported by

Singer Community

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-lever

REPLICATION SETTINGS
Anchor Scheduling

Supported

Advanced Scheduling

Supported

Table-level reset

Unsupported

Configurable Replication Methods

Unsupported

DATA SELECTION
Table selection

Supported

Column selection

Supported

Select all

Supported

TRANSPARENCY
Extraction Logs

Supported

Loading Reports

Supported

Connecting Lever

Lever setup requirements

To set up Lever in Stitch, you need:

  • Super Admin privileges. Your role in Lever must be Super Admin in order to obtain an API Key.


Step 1: Obtain your API token

  1. Login to your Lever account.
  2. Hover over your account icon in the upper right corner of the page and click Settings.
  3. On the settings page, click API Credentials.
  4. On the API Credentials page, locate the Generate New Key link in the Lever API credentials section.
  5. If you would like your key to access confidential information, click on the Allow access to confidential data toggle. If not, skip to the next step.
  6. Click Done.

Keep your API key readily available for the next step.

Step 2: Add Lever as a Stitch data source

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Lever icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Lever” would create a schema called stitch_lever in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the Token field, paste the API Key you obtained in Step 1.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Lever integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Lever’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Lever integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Lever integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Lever, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.


Lever table reference

archive_reasons

The archive_reasons table contains info about the reasons candidates have exited your active hiring pipeline. Refer to Lever’s documentation for more info.

Replication Method

Full Table

Primary Key

id

Useful links

Lever documentation

archive_reasons schema on GitHub

Lever API method

Join archive_reasons with on
candidate_applications
archive_reasons.id = candidate_applications.archived.reason
candidates
archive_reasons.id = candidates.archived.reason
opportunity_applications
archive_reasons.id = opportunity_applications.archived.reason
opportunities
archive_reasons.id = opportunities.archived.reason

id

STRING

text

STRING

candidate_applications

The candidate_applications table contains info about candidate applications in your Lever account.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

candidate_applications schema on GitHub

Lever API method

Join candidate_applications with on
archive_reasons
candidate_applications.archived.reason = archive_reasons.id
candidates
candidate_applications.archived.reason = candidates.archived.reason
candidate_applications.id = candidates.applications
candidate_applications.candidateId = candidates.id
candidate_applications.postingHiringManager = candidates.followers
candidate_applications.postingOwner = candidates.followers
candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.followers
candidate_applications.user = candidates.followers
candidate_applications.postingHiringManager = candidates.owner
candidate_applications.postingOwner = candidates.owner
candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.owner
candidate_applications.user = candidates.owner
candidate_applications.postingHiringManager = candidates.stageChanges.userId
candidate_applications.postingOwner = candidates.stageChanges.userId
candidate_applications.requisitionForHire.hiringManagerOnHire = candidates.stageChanges.userId
candidate_applications.user = candidates.stageChanges.userId
opportunity_applications
candidate_applications.archived.reason = opportunity_applications.archived.reason
candidate_applications.id = opportunity_applications.id
candidate_applications.candidateId = opportunity_applications.candidateId
candidate_applications.posting = opportunity_applications.posting
candidate_applications.requisitionForHire.id = opportunity_applications.requisitionForHire.id
candidate_applications.postingHiringManager = opportunity_applications.postingHiringManager
candidate_applications.postingOwner = opportunity_applications.postingHiringManager
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.postingHiringManager
candidate_applications.user = opportunity_applications.postingHiringManager
candidate_applications.postingHiringManager = opportunity_applications.postingOwner
candidate_applications.postingOwner = opportunity_applications.postingOwner
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.postingOwner
candidate_applications.user = opportunity_applications.postingOwner
candidate_applications.postingHiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_applications.postingOwner = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_applications.user = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_applications.postingHiringManager = opportunity_applications.user
candidate_applications.postingOwner = opportunity_applications.user
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_applications.user
candidate_applications.user = opportunity_applications.user
opportunities
candidate_applications.archived.reason = opportunities.archived.reason
candidate_applications.id = opportunities.applications
candidate_applications.candidateId = opportunities.id
candidate_applications.postingHiringManager = opportunities.followers
candidate_applications.postingOwner = opportunities.followers
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.followers
candidate_applications.user = opportunities.followers
candidate_applications.postingHiringManager = opportunities.owner
candidate_applications.postingOwner = opportunities.owner
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.owner
candidate_applications.user = opportunities.owner
candidate_applications.postingHiringManager = opportunities.stageChanges.userId
candidate_applications.postingOwner = opportunities.stageChanges.userId
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunities.stageChanges.userId
candidate_applications.user = opportunities.stageChanges.userId
opportunity_offers
candidate_applications.candidateId = opportunity_offers.opportunityId
candidate_applications.posting = opportunity_offers.posting
candidate_applications.postingHiringManager = opportunity_offers.creator
candidate_applications.postingOwner = opportunity_offers.creator
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_offers.creator
candidate_applications.user = opportunity_offers.creator
postings
candidate_applications.posting = postings.id
candidate_applications.postingHiringManager = postings.followers
candidate_applications.postingOwner = postings.followers
candidate_applications.requisitionForHire.hiringManagerOnHire = postings.followers
candidate_applications.user = postings.followers
candidate_applications.postingHiringManager = postings.hiringManager
candidate_applications.postingOwner = postings.hiringManager
candidate_applications.requisitionForHire.hiringManagerOnHire = postings.hiringManager
candidate_applications.user = postings.hiringManager
candidate_applications.postingHiringManager = postings.owner
candidate_applications.postingOwner = postings.owner
candidate_applications.requisitionForHire.hiringManagerOnHire = postings.owner
candidate_applications.user = postings.owner
candidate_applications.postingHiringManager = postings.user
candidate_applications.postingOwner = postings.user
candidate_applications.requisitionForHire.hiringManagerOnHire = postings.user
candidate_applications.user = postings.user
requisitions
candidate_applications.posting = requisitions.postings
candidate_applications.requisitionForHire.id = requisitions.id
candidate_applications.postingHiringManager = requisitions.creator
candidate_applications.postingOwner = requisitions.creator
candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.creator
candidate_applications.user = requisitions.creator
candidate_applications.postingHiringManager = requisitions.hiringManager
candidate_applications.postingOwner = requisitions.hiringManager
candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.hiringManager
candidate_applications.user = requisitions.hiringManager
candidate_applications.postingHiringManager = requisitions.owner
candidate_applications.postingOwner = requisitions.owner
candidate_applications.requisitionForHire.hiringManagerOnHire = requisitions.owner
candidate_applications.user = requisitions.owner
candidate_offers
candidate_applications.postingHiringManager = candidate_offers.creator
candidate_applications.postingOwner = candidate_offers.creator
candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_offers.creator
candidate_applications.user = candidate_offers.creator
candidate_referrals
candidate_applications.postingHiringManager = candidate_referrals.referrer
candidate_applications.postingOwner = candidate_referrals.referrer
candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.referrer
candidate_applications.user = candidate_referrals.referrer
candidate_applications.postingHiringManager = candidate_referrals.user
candidate_applications.postingOwner = candidate_referrals.user
candidate_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.user
candidate_applications.user = candidate_referrals.user
opportunity_referrals
candidate_applications.postingHiringManager = opportunity_referrals.referrer
candidate_applications.postingOwner = opportunity_referrals.referrer
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.referrer
candidate_applications.user = opportunity_referrals.referrer
candidate_applications.postingHiringManager = opportunity_referrals.user
candidate_applications.postingOwner = opportunity_referrals.user
candidate_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.user
candidate_applications.user = opportunity_referrals.user

candidateId

STRING

createdAt

NUMBER

email

STRING

id

STRING

name

STRING

posting

STRING

type

STRING

user

STRING

candidate_offers

The candidate_offers table contains data sent to candidates about opportunities via Lever’s Offers feature.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

candidate_offers schema on GitHub

Lever API method

Join candidate_offers with on
opportunity_offers
candidate_offers.id = opportunity_offers.id
candidate_offers.creator = opportunity_offers.creator
requisitions
candidate_offers.id = requisitions.offerIds
candidate_offers.creator = requisitions.creator
candidate_offers.creator = requisitions.hiringManager
candidate_offers.creator = requisitions.owner
candidate_applications
candidate_offers.creator = candidate_applications.postingHiringManager
candidate_offers.creator = candidate_applications.postingOwner
candidate_offers.creator = candidate_applications.requisitionForHire.hiringManagerOnHire
candidate_offers.creator = candidate_applications.user
candidate_referrals
candidate_offers.creator = candidate_referrals.referrer
candidate_offers.creator = candidate_referrals.user
candidates
candidate_offers.creator = candidates.followers
candidate_offers.creator = candidates.owner
candidate_offers.creator = candidates.stageChanges.userId
opportunities
candidate_offers.creator = opportunities.followers
candidate_offers.creator = opportunities.owner
candidate_offers.creator = opportunities.stageChanges.userId
opportunity_applications
candidate_offers.creator = opportunity_applications.postingHiringManager
candidate_offers.creator = opportunity_applications.postingOwner
candidate_offers.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_offers.creator = opportunity_applications.user
opportunity_referrals
candidate_offers.creator = opportunity_referrals.referrer
candidate_offers.creator = opportunity_referrals.user
postings
candidate_offers.creator = postings.followers
candidate_offers.creator = postings.hiringManager
candidate_offers.creator = postings.owner
candidate_offers.creator = postings.user

approvedAt

DATE-TIME

createdAt

DATE-TIME

creator

STRING

fields

ARRAY

identifier

STRING

text

STRING

value

STRING

id

STRING

sentAt

DATE-TIME

signatures

OBJECT

email

STRING

firstOpenedAt

DATE-TIME

lastOpenedAt

DATE-TIME

name

STRING

role

STRING

signed

BOOLEAN

signedAt

DATE-TIME

status

STRING

candidate_referrals

The candidate_referrals table contains info about the referrals in your Lever account.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

candidate_referrals schema on GitHub

Lever API method

Join candidate_referrals with on
opportunity_referrals
candidate_referrals.id = opportunity_referrals.id
candidate_referrals.referrer = opportunity_referrals.referrer
candidate_referrals.user = opportunity_referrals.referrer
candidate_referrals.referrer = opportunity_referrals.user
candidate_referrals.user = opportunity_referrals.user
candidate_applications
candidate_referrals.referrer = candidate_applications.postingHiringManager
candidate_referrals.user = candidate_applications.postingHiringManager
candidate_referrals.referrer = candidate_applications.postingOwner
candidate_referrals.user = candidate_applications.postingOwner
candidate_referrals.referrer = candidate_applications.requisitionForHire.hiringManagerOnHire
candidate_referrals.user = candidate_applications.requisitionForHire.hiringManagerOnHire
candidate_referrals.referrer = candidate_applications.user
candidate_referrals.user = candidate_applications.user
candidate_offers
candidate_referrals.referrer = candidate_offers.creator
candidate_referrals.user = candidate_offers.creator
candidates
candidate_referrals.referrer = candidates.followers
candidate_referrals.user = candidates.followers
candidate_referrals.referrer = candidates.owner
candidate_referrals.user = candidates.owner
candidate_referrals.referrer = candidates.stageChanges.userId
candidate_referrals.user = candidates.stageChanges.userId
opportunities
candidate_referrals.referrer = opportunities.followers
candidate_referrals.user = opportunities.followers
candidate_referrals.referrer = opportunities.owner
candidate_referrals.user = opportunities.owner
candidate_referrals.referrer = opportunities.stageChanges.userId
candidate_referrals.user = opportunities.stageChanges.userId
opportunity_applications
candidate_referrals.referrer = opportunity_applications.postingHiringManager
candidate_referrals.user = opportunity_applications.postingHiringManager
candidate_referrals.referrer = opportunity_applications.postingOwner
candidate_referrals.user = opportunity_applications.postingOwner
candidate_referrals.referrer = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_referrals.user = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidate_referrals.referrer = opportunity_applications.user
candidate_referrals.user = opportunity_applications.user
opportunity_offers
candidate_referrals.referrer = opportunity_offers.creator
candidate_referrals.user = opportunity_offers.creator
postings
candidate_referrals.referrer = postings.followers
candidate_referrals.user = postings.followers
candidate_referrals.referrer = postings.hiringManager
candidate_referrals.user = postings.hiringManager
candidate_referrals.referrer = postings.owner
candidate_referrals.user = postings.owner
candidate_referrals.referrer = postings.user
candidate_referrals.user = postings.user
requisitions
candidate_referrals.referrer = requisitions.creator
candidate_referrals.user = requisitions.creator
candidate_referrals.referrer = requisitions.hiringManager
candidate_referrals.user = requisitions.hiringManager
candidate_referrals.referrer = requisitions.owner
candidate_referrals.user = requisitions.owner

baseTemplateId

STRING

completedAt

DATE-TIME

createdAt

DATE-TIME

fields

ARRAY

description

STRING

options

ARRAY

prompt

STRING

required

BOOLEAN

text

STRING

type

STRING

value

STRING

id

STRING

instructions

STRING

referrer

STRING

stage

STRING

text

STRING

type

STRING

user

STRING

candidate_resumes

The candidate_resumes table contains info about candidate resumes.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

candidate_resumes schema on GitHub

Lever API method

Join candidate_resumes with on
opportunity_resumes
candidate_resumes.id = opportunity_resumes.id

createdAt

DATE-TIME

file

OBJECT

id

STRING

parsedData

OBJECT

candidates

The candidates table contains info about candidates, or individuals who’ve been added to your Lever account as potential fits for job opportunities.

Note: This table must be set to replicate in order to replicate the candidate_applications, candidate_offers, candidate_referrals, and candidate_resumes tables.

During Extraction, this table will be replicated before any other selected candidate_* tables. Then, for every candidate, Stitch will query for every candidate’s applications, offers, referrals, and resumes.

For example: During Extraction, Stitch replicates a candidate with id: 12345 from Lever’s /candidates endpoint.

Using id: 12345, Stitch will then query for the rest of the candidate’s data:

  • /candidates/12345/applications
  • /candidates/12345/offers
  • /candidates/12345/referrals
  • /candidates/12345/resumes

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

candidates schema on GitHub

Lever API method

Join candidates with on
archive_reasons
candidates.archived.reason = archive_reasons.id
candidate_applications
candidates.archived.reason = candidate_applications.archived.reason
candidates.applications = candidate_applications.id
candidates.id = candidate_applications.candidateId
candidates.followers = candidate_applications.postingHiringManager
candidates.owner = candidate_applications.postingHiringManager
candidates.stageChanges.userId = candidate_applications.postingHiringManager
candidates.followers = candidate_applications.postingOwner
candidates.owner = candidate_applications.postingOwner
candidates.stageChanges.userId = candidate_applications.postingOwner
candidates.followers = candidate_applications.requisitionForHire.hiringManagerOnHire
candidates.owner = candidate_applications.requisitionForHire.hiringManagerOnHire
candidates.stageChanges.userId = candidate_applications.requisitionForHire.hiringManagerOnHire
candidates.followers = candidate_applications.user
candidates.owner = candidate_applications.user
candidates.stageChanges.userId = candidate_applications.user
opportunity_applications
candidates.archived.reason = opportunity_applications.archived.reason
candidates.applications = opportunity_applications.id
candidates.id = opportunity_applications.candidateId
candidates.followers = opportunity_applications.postingHiringManager
candidates.owner = opportunity_applications.postingHiringManager
candidates.stageChanges.userId = opportunity_applications.postingHiringManager
candidates.followers = opportunity_applications.postingOwner
candidates.owner = opportunity_applications.postingOwner
candidates.stageChanges.userId = opportunity_applications.postingOwner
candidates.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidates.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidates.stageChanges.userId = opportunity_applications.requisitionForHire.hiringManagerOnHire
candidates.followers = opportunity_applications.user
candidates.owner = opportunity_applications.user
candidates.stageChanges.userId = opportunity_applications.user
opportunities
candidates.archived.reason = opportunities.archived.reason
candidates.applications = opportunities.applications
candidates.contact = opportunities.contact
candidates.id = opportunities.id
candidates.stage = opportunities.stage
candidates.stageChanges.toStageId = opportunities.stage
candidates.stage = opportunities.stageChanges.toStageId
candidates.stageChanges.toStageId = opportunities.stageChanges.toStageId
candidates.followers = opportunities.followers
candidates.owner = opportunities.followers
candidates.stageChanges.userId = opportunities.followers
candidates.followers = opportunities.owner
candidates.owner = opportunities.owner
candidates.stageChanges.userId = opportunities.owner
candidates.followers = opportunities.stageChanges.userId
candidates.owner = opportunities.stageChanges.userId
candidates.stageChanges.userId = opportunities.stageChanges.userId
opportunity_offers
candidates.id = opportunity_offers.opportunityId
candidates.followers = opportunity_offers.creator
candidates.owner = opportunity_offers.creator
candidates.stageChanges.userId = opportunity_offers.creator
stages
candidates.stage = stages.id
candidates.stageChanges.toStageId = stages.id
candidate_offers
candidates.followers = candidate_offers.creator
candidates.owner = candidate_offers.creator
candidates.stageChanges.userId = candidate_offers.creator
candidate_referrals
candidates.followers = candidate_referrals.referrer
candidates.owner = candidate_referrals.referrer
candidates.stageChanges.userId = candidate_referrals.referrer
candidates.followers = candidate_referrals.user
candidates.owner = candidate_referrals.user
candidates.stageChanges.userId = candidate_referrals.user
opportunity_referrals
candidates.followers = opportunity_referrals.referrer
candidates.owner = opportunity_referrals.referrer
candidates.stageChanges.userId = opportunity_referrals.referrer
candidates.followers = opportunity_referrals.user
candidates.owner = opportunity_referrals.user
candidates.stageChanges.userId = opportunity_referrals.user
postings
candidates.followers = postings.followers
candidates.owner = postings.followers
candidates.stageChanges.userId = postings.followers
candidates.followers = postings.hiringManager
candidates.owner = postings.hiringManager
candidates.stageChanges.userId = postings.hiringManager
candidates.followers = postings.owner
candidates.owner = postings.owner
candidates.stageChanges.userId = postings.owner
candidates.followers = postings.user
candidates.owner = postings.user
candidates.stageChanges.userId = postings.user
requisitions
candidates.followers = requisitions.creator
candidates.owner = requisitions.creator
candidates.stageChanges.userId = requisitions.creator
candidates.followers = requisitions.hiringManager
candidates.owner = requisitions.hiringManager
candidates.stageChanges.userId = requisitions.hiringManager
candidates.followers = requisitions.owner
candidates.owner = requisitions.owner
candidates.stageChanges.userId = requisitions.owner

applications

ARRAY

archived

OBJECT

archivedAt

DATE-TIME

reason

STRING

contact

STRING

createdAt

DATE-TIME

dataProtection

OBJECT

emails

ARRAY

followers

ARRAY

headline

STRING

id

STRING

isAnonymized

BOOLEAN

lastAdvancedAt

DATE-TIME

lastInteractionAt

DATE-TIME

links

ARRAY

location

STRING

name

STRING

origin

STRING

owner

STRING

phones

ARRAY

type

STRING

value

STRING

resume

OBJECT

snoozedUntil

DATE-TIME

sources

ARRAY

stage

STRING

stageChanges

ARRAY

tags

ARRAY

urls

OBJECT

opportunities

The opportunities table contains info about opportunities. In Lever, an opportunity represents each of an individual candidate’s unique candidacies or journeys through your hiring pipeline for a position. A candidate can be associated with multiple opportunities.

Note: This table must be set to replicate in order to replicate the opportunity_applications, opportunity_offers, opportunity_referrals, and opportunity_resumes tables.

During Extraction, this table will be replicated before any other selected opportunity_* tables. Then, for every opportunity, Stitch will query for every opportunity’s applications, offers, referrals, and resumes.

For example: During Extraction, Stitch replicates an opportunity with id: 12345 from Lever’s /opportunities endpoint.

Using id: 12345, Stitch will then query for the rest of the opportunity’s data:

  • /opportunities/12345/applications
  • /opportunities/12345/offers
  • /opportunities/12345/referrals
  • /opportunities/12345/resumes

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

opportunities schema on GitHub

Lever API method

Join opportunities with on
archive_reasons
opportunities.archived.reason = archive_reasons.id
candidate_applications
opportunities.archived.reason = candidate_applications.archived.reason
opportunities.applications = candidate_applications.id
opportunities.id = candidate_applications.candidateId
opportunities.followers = candidate_applications.postingHiringManager
opportunities.owner = candidate_applications.postingHiringManager
opportunities.stageChanges.userId = candidate_applications.postingHiringManager
opportunities.followers = candidate_applications.postingOwner
opportunities.owner = candidate_applications.postingOwner
opportunities.stageChanges.userId = candidate_applications.postingOwner
opportunities.followers = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunities.owner = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunities.stageChanges.userId = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunities.followers = candidate_applications.user
opportunities.owner = candidate_applications.user
opportunities.stageChanges.userId = candidate_applications.user
candidates
opportunities.archived.reason = candidates.archived.reason
opportunities.applications = candidates.applications
opportunities.contact = candidates.contact
opportunities.id = candidates.id
opportunities.stage = candidates.stage
opportunities.stageChanges.toStageId = candidates.stage
opportunities.stage = candidates.stageChanges.toStageId
opportunities.stageChanges.toStageId = candidates.stageChanges.toStageId
opportunities.followers = candidates.followers
opportunities.owner = candidates.followers
opportunities.stageChanges.userId = candidates.followers
opportunities.followers = candidates.owner
opportunities.owner = candidates.owner
opportunities.stageChanges.userId = candidates.owner
opportunities.followers = candidates.stageChanges.userId
opportunities.owner = candidates.stageChanges.userId
opportunities.stageChanges.userId = candidates.stageChanges.userId
opportunity_applications
opportunities.archived.reason = opportunity_applications.archived.reason
opportunities.applications = opportunity_applications.id
opportunities.id = opportunity_applications.candidateId
opportunities.followers = opportunity_applications.postingHiringManager
opportunities.owner = opportunity_applications.postingHiringManager
opportunities.stageChanges.userId = opportunity_applications.postingHiringManager
opportunities.followers = opportunity_applications.postingOwner
opportunities.owner = opportunity_applications.postingOwner
opportunities.stageChanges.userId = opportunity_applications.postingOwner
opportunities.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire
opportunities.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire
opportunities.stageChanges.userId = opportunity_applications.requisitionForHire.hiringManagerOnHire
opportunities.followers = opportunity_applications.user
opportunities.owner = opportunity_applications.user
opportunities.stageChanges.userId = opportunity_applications.user
opportunity_offers
opportunities.id = opportunity_offers.opportunityId
opportunities.followers = opportunity_offers.creator
opportunities.owner = opportunity_offers.creator
opportunities.stageChanges.userId = opportunity_offers.creator
stages
opportunities.stage = stages.id
opportunities.stageChanges.toStageId = stages.id
candidate_offers
opportunities.followers = candidate_offers.creator
opportunities.owner = candidate_offers.creator
opportunities.stageChanges.userId = candidate_offers.creator
candidate_referrals
opportunities.followers = candidate_referrals.referrer
opportunities.owner = candidate_referrals.referrer
opportunities.stageChanges.userId = candidate_referrals.referrer
opportunities.followers = candidate_referrals.user
opportunities.owner = candidate_referrals.user
opportunities.stageChanges.userId = candidate_referrals.user
opportunity_referrals
opportunities.followers = opportunity_referrals.referrer
opportunities.owner = opportunity_referrals.referrer
opportunities.stageChanges.userId = opportunity_referrals.referrer
opportunities.followers = opportunity_referrals.user
opportunities.owner = opportunity_referrals.user
opportunities.stageChanges.userId = opportunity_referrals.user
postings
opportunities.followers = postings.followers
opportunities.owner = postings.followers
opportunities.stageChanges.userId = postings.followers
opportunities.followers = postings.hiringManager
opportunities.owner = postings.hiringManager
opportunities.stageChanges.userId = postings.hiringManager
opportunities.followers = postings.owner
opportunities.owner = postings.owner
opportunities.stageChanges.userId = postings.owner
opportunities.followers = postings.user
opportunities.owner = postings.user
opportunities.stageChanges.userId = postings.user
requisitions
opportunities.followers = requisitions.creator
opportunities.owner = requisitions.creator
opportunities.stageChanges.userId = requisitions.creator
opportunities.followers = requisitions.hiringManager
opportunities.owner = requisitions.hiringManager
opportunities.stageChanges.userId = requisitions.hiringManager
opportunities.followers = requisitions.owner
opportunities.owner = requisitions.owner
opportunities.stageChanges.userId = requisitions.owner

applications

ARRAY

archived

OBJECT

archivedAt

DATE-TIME

reason

STRING

contact

STRING

createdAt

DATE-TIME

dataProtection

OBJECT

emails

ARRAY

followers

ARRAY

headline

STRING

id

STRING

isAnonymized

BOOLEAN

lastAdvancedAt

DATE-TIME

lastInteractionAt

DATE-TIME

links

ARRAY

location

STRING

name

STRING

origin

STRING

owner

STRING

phones

ARRAY

type

STRING

value

STRING

snoozedUntil

DATE-TIME

sources

ARRAY

stage

STRING

stageChanges

ARRAY

tags

ARRAY

urls

OBJECT

opportunity_applications

The opportunity_applications table contains info about candidate applications in your Lever account.

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

opportunity_applications schema on GitHub

Lever API method

Join opportunity_applications with on
archive_reasons
opportunity_applications.archived.reason = archive_reasons.id
candidate_applications
opportunity_applications.archived.reason = candidate_applications.archived.reason
opportunity_applications.id = candidate_applications.id
opportunity_applications.candidateId = candidate_applications.candidateId
opportunity_applications.posting = candidate_applications.posting
opportunity_applications.requisitionForHire.id = candidate_applications.requisitionForHire.id
opportunity_applications.postingHiringManager = candidate_applications.postingHiringManager
opportunity_applications.postingOwner = candidate_applications.postingHiringManager
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.postingHiringManager
opportunity_applications.user = candidate_applications.postingHiringManager
opportunity_applications.postingHiringManager = candidate_applications.postingOwner
opportunity_applications.postingOwner = candidate_applications.postingOwner
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.postingOwner
opportunity_applications.user = candidate_applications.postingOwner
opportunity_applications.postingHiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_applications.postingOwner = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_applications.user = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_applications.postingHiringManager = candidate_applications.user
opportunity_applications.postingOwner = candidate_applications.user
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_applications.user
opportunity_applications.user = candidate_applications.user
candidates
opportunity_applications.archived.reason = candidates.archived.reason
opportunity_applications.id = candidates.applications
opportunity_applications.candidateId = candidates.id
opportunity_applications.postingHiringManager = candidates.followers
opportunity_applications.postingOwner = candidates.followers
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.followers
opportunity_applications.user = candidates.followers
opportunity_applications.postingHiringManager = candidates.owner
opportunity_applications.postingOwner = candidates.owner
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.owner
opportunity_applications.user = candidates.owner
opportunity_applications.postingHiringManager = candidates.stageChanges.userId
opportunity_applications.postingOwner = candidates.stageChanges.userId
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidates.stageChanges.userId
opportunity_applications.user = candidates.stageChanges.userId
opportunities
opportunity_applications.archived.reason = opportunities.archived.reason
opportunity_applications.id = opportunities.applications
opportunity_applications.candidateId = opportunities.id
opportunity_applications.postingHiringManager = opportunities.followers
opportunity_applications.postingOwner = opportunities.followers
opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.followers
opportunity_applications.user = opportunities.followers
opportunity_applications.postingHiringManager = opportunities.owner
opportunity_applications.postingOwner = opportunities.owner
opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.owner
opportunity_applications.user = opportunities.owner
opportunity_applications.postingHiringManager = opportunities.stageChanges.userId
opportunity_applications.postingOwner = opportunities.stageChanges.userId
opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunities.stageChanges.userId
opportunity_applications.user = opportunities.stageChanges.userId
opportunity_offers
opportunity_applications.candidateId = opportunity_offers.opportunityId
opportunity_applications.posting = opportunity_offers.posting
opportunity_applications.postingHiringManager = opportunity_offers.creator
opportunity_applications.postingOwner = opportunity_offers.creator
opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_offers.creator
opportunity_applications.user = opportunity_offers.creator
postings
opportunity_applications.posting = postings.id
opportunity_applications.postingHiringManager = postings.followers
opportunity_applications.postingOwner = postings.followers
opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.followers
opportunity_applications.user = postings.followers
opportunity_applications.postingHiringManager = postings.hiringManager
opportunity_applications.postingOwner = postings.hiringManager
opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.hiringManager
opportunity_applications.user = postings.hiringManager
opportunity_applications.postingHiringManager = postings.owner
opportunity_applications.postingOwner = postings.owner
opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.owner
opportunity_applications.user = postings.owner
opportunity_applications.postingHiringManager = postings.user
opportunity_applications.postingOwner = postings.user
opportunity_applications.requisitionForHire.hiringManagerOnHire = postings.user
opportunity_applications.user = postings.user
requisitions
opportunity_applications.posting = requisitions.postings
opportunity_applications.requisitionForHire.id = requisitions.id
opportunity_applications.postingHiringManager = requisitions.creator
opportunity_applications.postingOwner = requisitions.creator
opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.creator
opportunity_applications.user = requisitions.creator
opportunity_applications.postingHiringManager = requisitions.hiringManager
opportunity_applications.postingOwner = requisitions.hiringManager
opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.hiringManager
opportunity_applications.user = requisitions.hiringManager
opportunity_applications.postingHiringManager = requisitions.owner
opportunity_applications.postingOwner = requisitions.owner
opportunity_applications.requisitionForHire.hiringManagerOnHire = requisitions.owner
opportunity_applications.user = requisitions.owner
candidate_offers
opportunity_applications.postingHiringManager = candidate_offers.creator
opportunity_applications.postingOwner = candidate_offers.creator
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_offers.creator
opportunity_applications.user = candidate_offers.creator
candidate_referrals
opportunity_applications.postingHiringManager = candidate_referrals.referrer
opportunity_applications.postingOwner = candidate_referrals.referrer
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.referrer
opportunity_applications.user = candidate_referrals.referrer
opportunity_applications.postingHiringManager = candidate_referrals.user
opportunity_applications.postingOwner = candidate_referrals.user
opportunity_applications.requisitionForHire.hiringManagerOnHire = candidate_referrals.user
opportunity_applications.user = candidate_referrals.user
opportunity_referrals
opportunity_applications.postingHiringManager = opportunity_referrals.referrer
opportunity_applications.postingOwner = opportunity_referrals.referrer
opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.referrer
opportunity_applications.user = opportunity_referrals.referrer
opportunity_applications.postingHiringManager = opportunity_referrals.user
opportunity_applications.postingOwner = opportunity_referrals.user
opportunity_applications.requisitionForHire.hiringManagerOnHire = opportunity_referrals.user
opportunity_applications.user = opportunity_referrals.user

candidateId

STRING

createdAt

NUMBER

email

STRING

id

STRING

name

STRING

posting

STRING

type

STRING

user

STRING

opportunity_offers

The opportunity_offers table contains info about

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Useful links

Lever documentation

opportunity_offers schema on GitHub

Lever API method

Join opportunity_offers with on
candidate_offers
opportunity_offers.id = candidate_offers.id
opportunity_offers.creator = candidate_offers.creator
requisitions
opportunity_offers.id = requisitions.offerIds
opportunity_offers.posting = requisitions.postings
opportunity_offers.creator = requisitions.creator
opportunity_offers.creator = requisitions.hiringManager
opportunity_offers.creator = requisitions.owner
candidate_applications
opportunity_offers.opportunityId = candidate_applications.candidateId
opportunity_offers.posting = candidate_applications.posting
opportunity_offers.creator = candidate_applications.postingHiringManager
opportunity_offers.creator = candidate_applications.postingOwner
opportunity_offers.creator = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_offers.creator = candidate_applications.user
candidates
opportunity_offers.opportunityId = candidates.id
opportunity_offers.creator = candidates.followers
opportunity_offers.creator = candidates.owner
opportunity_offers.creator = candidates.stageChanges.userId
opportunity_applications
opportunity_offers.opportunityId = opportunity_applications.candidateId
opportunity_offers.posting = opportunity_applications.posting
opportunity_offers.creator = opportunity_applications.postingHiringManager
opportunity_offers.creator = opportunity_applications.postingOwner
opportunity_offers.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire
opportunity_offers.creator = opportunity_applications.user
opportunities
opportunity_offers.opportunityId = opportunities.id
opportunity_offers.creator = opportunities.followers
opportunity_offers.creator = opportunities.owner
opportunity_offers.creator = opportunities.stageChanges.userId
postings
opportunity_offers.posting = postings.id
opportunity_offers.creator = postings.followers
opportunity_offers.creator = postings.hiringManager
opportunity_offers.creator = postings.owner
opportunity_offers.creator = postings.user
candidate_referrals
opportunity_offers.creator = candidate_referrals.referrer
opportunity_offers.creator = candidate_referrals.user
opportunity_referrals
opportunity_offers.creator = opportunity_referrals.referrer
opportunity_offers.creator = opportunity_referrals.user

approved

BOOLEAN

approvedAt

DATE-TIME

createdAt

DATE-TIME

creator

STRING

fields

ARRAY

identifier

STRING

text

STRING

value

STRING

id

STRING

opportunityId

STRING

posting

STRING

sentAt

DATE-TIME

sentDocument

OBJECT

downloadUrl

STRING

fileName

STRING

uploadedAt

DATE-TIME

signatures

OBJECT

candidate

OBJECT

email

STRING

firstOpenedAt

DATE-TIME

lastOpenedAt

DATE-TIME

name

STRING

role

STRING

signed

BOOLEAN

signedAt

DATE-TIME

email

STRING

firstOpenedAt

DATE-TIME

lastOpenedAt

DATE-TIME

name

STRING

role

STRING

signed

BOOLEAN

signedAt

DATE-TIME

signedDocument

OBJECT

downloadUrl

STRING

fileName

STRING

uploadedAt

DATE-TIME

status

STRING

opportunity_referrals

The opportunity_referrals table contains info about the referrals in your Lever account.

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

opportunity_referrals schema on GitHub

Lever API method

Join opportunity_referrals with on
candidate_referrals
opportunity_referrals.id = candidate_referrals.id
opportunity_referrals.referrer = candidate_referrals.referrer
opportunity_referrals.user = candidate_referrals.referrer
opportunity_referrals.referrer = candidate_referrals.user
opportunity_referrals.user = candidate_referrals.user
candidate_applications
opportunity_referrals.referrer = candidate_applications.postingHiringManager
opportunity_referrals.user = candidate_applications.postingHiringManager
opportunity_referrals.referrer = candidate_applications.postingOwner
opportunity_referrals.user = candidate_applications.postingOwner
opportunity_referrals.referrer = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_referrals.user = candidate_applications.requisitionForHire.hiringManagerOnHire
opportunity_referrals.referrer = candidate_applications.user
opportunity_referrals.user = candidate_applications.user
candidate_offers
opportunity_referrals.referrer = candidate_offers.creator
opportunity_referrals.user = candidate_offers.creator
candidates
opportunity_referrals.referrer = candidates.followers
opportunity_referrals.user = candidates.followers
opportunity_referrals.referrer = candidates.owner
opportunity_referrals.user = candidates.owner
opportunity_referrals.referrer = candidates.stageChanges.userId
opportunity_referrals.user = candidates.stageChanges.userId
opportunities
opportunity_referrals.referrer = opportunities.followers
opportunity_referrals.user = opportunities.followers
opportunity_referrals.referrer = opportunities.owner
opportunity_referrals.user = opportunities.owner
opportunity_referrals.referrer = opportunities.stageChanges.userId
opportunity_referrals.user = opportunities.stageChanges.userId
opportunity_applications
opportunity_referrals.referrer = opportunity_applications.postingHiringManager
opportunity_referrals.user = opportunity_applications.postingHiringManager
opportunity_referrals.referrer = opportunity_applications.postingOwner
opportunity_referrals.user = opportunity_applications.postingOwner
opportunity_referrals.referrer = opportunity_applications.requisitionForHire.hiringManagerOnHire
opportunity_referrals.user = opportunity_applications.requisitionForHire.hiringManagerOnHire
opportunity_referrals.referrer = opportunity_applications.user
opportunity_referrals.user = opportunity_applications.user
opportunity_offers
opportunity_referrals.referrer = opportunity_offers.creator
opportunity_referrals.user = opportunity_offers.creator
postings
opportunity_referrals.referrer = postings.followers
opportunity_referrals.user = postings.followers
opportunity_referrals.referrer = postings.hiringManager
opportunity_referrals.user = postings.hiringManager
opportunity_referrals.referrer = postings.owner
opportunity_referrals.user = postings.owner
opportunity_referrals.referrer = postings.user
opportunity_referrals.user = postings.user
requisitions
opportunity_referrals.referrer = requisitions.creator
opportunity_referrals.user = requisitions.creator
opportunity_referrals.referrer = requisitions.hiringManager
opportunity_referrals.user = requisitions.hiringManager
opportunity_referrals.referrer = requisitions.owner
opportunity_referrals.user = requisitions.owner

baseTemplateId

STRING

completedAt

DATE-TIME

createdAt

DATE-TIME

fields

ARRAY

description

STRING

options

ARRAY

prompt

STRING

required

BOOLEAN

text

STRING

type

STRING

value

STRING

id

STRING

instructions

STRING

referrer

STRING

stage

STRING

text

STRING

type

STRING

user

STRING

opportunity_resumes

The opportunity_resumes table contains info about candidate resumes.

Note: To replicate this table, the opportunities table must be set to replicate.

Replication Method

Key-based Incremental

Primary Key

id

Useful links

Lever documentation

opportunity_resumes schema on GitHub

Lever API method

Join opportunity_resumes with on
candidate_resumes
opportunity_resumes.id = candidate_resumes.id

createdAt

DATE-TIME

file

OBJECT

id

STRING

parsedData

OBJECT

postings

The postings table contains info about job postings in your Lever account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

updatedAt

Useful links

Lever documentation

postings schema on GitHub

Lever API method

Join postings with on
candidate_applications
postings.id = candidate_applications.posting
postings.followers = candidate_applications.postingHiringManager
postings.hiringManager = candidate_applications.postingHiringManager
postings.owner = candidate_applications.postingHiringManager
postings.user = candidate_applications.postingHiringManager
postings.followers = candidate_applications.postingOwner
postings.hiringManager = candidate_applications.postingOwner
postings.owner = candidate_applications.postingOwner
postings.user = candidate_applications.postingOwner
postings.followers = candidate_applications.requisitionForHire.hiringManagerOnHire
postings.hiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire
postings.owner = candidate_applications.requisitionForHire.hiringManagerOnHire
postings.user = candidate_applications.requisitionForHire.hiringManagerOnHire
postings.followers = candidate_applications.user
postings.hiringManager = candidate_applications.user
postings.owner = candidate_applications.user
postings.user = candidate_applications.user
opportunity_applications
postings.id = opportunity_applications.posting
postings.followers = opportunity_applications.postingHiringManager
postings.hiringManager = opportunity_applications.postingHiringManager
postings.owner = opportunity_applications.postingHiringManager
postings.user = opportunity_applications.postingHiringManager
postings.followers = opportunity_applications.postingOwner
postings.hiringManager = opportunity_applications.postingOwner
postings.owner = opportunity_applications.postingOwner
postings.user = opportunity_applications.postingOwner
postings.followers = opportunity_applications.requisitionForHire.hiringManagerOnHire
postings.hiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire
postings.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire
postings.user = opportunity_applications.requisitionForHire.hiringManagerOnHire
postings.followers = opportunity_applications.user
postings.hiringManager = opportunity_applications.user
postings.owner = opportunity_applications.user
postings.user = opportunity_applications.user
opportunity_offers
postings.id = opportunity_offers.posting
postings.followers = opportunity_offers.creator
postings.hiringManager = opportunity_offers.creator
postings.owner = opportunity_offers.creator
postings.user = opportunity_offers.creator
requisitions
postings.id = requisitions.postings
postings.followers = requisitions.creator
postings.hiringManager = requisitions.creator
postings.owner = requisitions.creator
postings.user = requisitions.creator
postings.followers = requisitions.hiringManager
postings.hiringManager = requisitions.hiringManager
postings.owner = requisitions.hiringManager
postings.user = requisitions.hiringManager
postings.followers = requisitions.owner
postings.hiringManager = requisitions.owner
postings.owner = requisitions.owner
postings.user = requisitions.owner
candidate_offers
postings.followers = candidate_offers.creator
postings.hiringManager = candidate_offers.creator
postings.owner = candidate_offers.creator
postings.user = candidate_offers.creator
candidate_referrals
postings.followers = candidate_referrals.referrer
postings.hiringManager = candidate_referrals.referrer
postings.owner = candidate_referrals.referrer
postings.user = candidate_referrals.referrer
postings.followers = candidate_referrals.user
postings.hiringManager = candidate_referrals.user
postings.owner = candidate_referrals.user
postings.user = candidate_referrals.user
candidates
postings.followers = candidates.followers
postings.hiringManager = candidates.followers
postings.owner = candidates.followers
postings.user = candidates.followers
postings.followers = candidates.owner
postings.hiringManager = candidates.owner
postings.owner = candidates.owner
postings.user = candidates.owner
postings.followers = candidates.stageChanges.userId
postings.hiringManager = candidates.stageChanges.userId
postings.owner = candidates.stageChanges.userId
postings.user = candidates.stageChanges.userId
opportunities
postings.followers = opportunities.followers
postings.hiringManager = opportunities.followers
postings.owner = opportunities.followers
postings.user = opportunities.followers
postings.followers = opportunities.owner
postings.hiringManager = opportunities.owner
postings.owner = opportunities.owner
postings.user = opportunities.owner
postings.followers = opportunities.stageChanges.userId
postings.hiringManager = opportunities.stageChanges.userId
postings.owner = opportunities.stageChanges.userId
postings.user = opportunities.stageChanges.userId
opportunity_referrals
postings.followers = opportunity_referrals.referrer
postings.hiringManager = opportunity_referrals.referrer
postings.owner = opportunity_referrals.referrer
postings.user = opportunity_referrals.referrer
postings.followers = opportunity_referrals.user
postings.hiringManager = opportunity_referrals.user
postings.owner = opportunity_referrals.user
postings.user = opportunity_referrals.user

categories

OBJECT

commitment

STRING

department

STRING

level

STRING

location

STRING

team

STRING

content

OBJECT

closing

STRING

customQuestions

ARRAY

description

STRING

lists

ARRAY

content

STRING

text

STRING

createdAt

DATE-TIME

distributionChannels

ARRAY

followers

STRING

hiringManager

STRING

id

STRING

owner

STRING

reqCode

STRING

state

STRING

tags

ARRAY

text

STRING

updatedAt

DATE-TIME

urls

OBJECT

apply

STRING

list

STRING

show

STRING

user

STRING

requisitions

The requisitions table contains info about requisitions in your Lever account.

Replication Method

Key-based Incremental

Primary Key

id

Replication Key

createdAt

Useful links

Lever documentation

requisitions schema on GitHub

Lever API method

Join requisitions with on
candidate_offers
requisitions.offerIds = candidate_offers.id
requisitions.creator = candidate_offers.creator
requisitions.hiringManager = candidate_offers.creator
requisitions.owner = candidate_offers.creator
opportunity_offers
requisitions.offerIds = opportunity_offers.id
requisitions.postings = opportunity_offers.posting
requisitions.creator = opportunity_offers.creator
requisitions.hiringManager = opportunity_offers.creator
requisitions.owner = opportunity_offers.creator
candidate_applications
requisitions.postings = candidate_applications.posting
requisitions.id = candidate_applications.requisitionForHire.id
requisitions.creator = candidate_applications.postingHiringManager
requisitions.hiringManager = candidate_applications.postingHiringManager
requisitions.owner = candidate_applications.postingHiringManager
requisitions.creator = candidate_applications.postingOwner
requisitions.hiringManager = candidate_applications.postingOwner
requisitions.owner = candidate_applications.postingOwner
requisitions.creator = candidate_applications.requisitionForHire.hiringManagerOnHire
requisitions.hiringManager = candidate_applications.requisitionForHire.hiringManagerOnHire
requisitions.owner = candidate_applications.requisitionForHire.hiringManagerOnHire
requisitions.creator = candidate_applications.user
requisitions.hiringManager = candidate_applications.user
requisitions.owner = candidate_applications.user
opportunity_applications
requisitions.postings = opportunity_applications.posting
requisitions.id = opportunity_applications.requisitionForHire.id
requisitions.creator = opportunity_applications.postingHiringManager
requisitions.hiringManager = opportunity_applications.postingHiringManager
requisitions.owner = opportunity_applications.postingHiringManager
requisitions.creator = opportunity_applications.postingOwner
requisitions.hiringManager = opportunity_applications.postingOwner
requisitions.owner = opportunity_applications.postingOwner
requisitions.creator = opportunity_applications.requisitionForHire.hiringManagerOnHire
requisitions.hiringManager = opportunity_applications.requisitionForHire.hiringManagerOnHire
requisitions.owner = opportunity_applications.requisitionForHire.hiringManagerOnHire
requisitions.creator = opportunity_applications.user
requisitions.hiringManager = opportunity_applications.user
requisitions.owner = opportunity_applications.user
postings
requisitions.postings = postings.id
requisitions.creator = postings.followers
requisitions.hiringManager = postings.followers
requisitions.owner = postings.followers
requisitions.creator = postings.hiringManager
requisitions.hiringManager = postings.hiringManager
requisitions.owner = postings.hiringManager
requisitions.creator = postings.owner
requisitions.hiringManager = postings.owner
requisitions.owner = postings.owner
requisitions.creator = postings.user
requisitions.hiringManager = postings.user
requisitions.owner = postings.user
candidate_referrals
requisitions.creator = candidate_referrals.referrer
requisitions.hiringManager = candidate_referrals.referrer
requisitions.owner = candidate_referrals.referrer
requisitions.creator = candidate_referrals.user
requisitions.hiringManager = candidate_referrals.user
requisitions.owner = candidate_referrals.user
candidates
requisitions.creator = candidates.followers
requisitions.hiringManager = candidates.followers
requisitions.owner = candidates.followers
requisitions.creator = candidates.owner
requisitions.hiringManager = candidates.owner
requisitions.owner = candidates.owner
requisitions.creator = candidates.stageChanges.userId
requisitions.hiringManager = candidates.stageChanges.userId
requisitions.owner = candidates.stageChanges.userId
opportunities
requisitions.creator = opportunities.followers
requisitions.hiringManager = opportunities.followers
requisitions.owner = opportunities.followers
requisitions.creator = opportunities.owner
requisitions.hiringManager = opportunities.owner
requisitions.owner = opportunities.owner
requisitions.creator = opportunities.stageChanges.userId
requisitions.hiringManager = opportunities.stageChanges.userId
requisitions.owner = opportunities.stageChanges.userId
opportunity_referrals
requisitions.creator = opportunity_referrals.referrer
requisitions.hiringManager = opportunity_referrals.referrer
requisitions.owner = opportunity_referrals.referrer
requisitions.creator = opportunity_referrals.user
requisitions.hiringManager = opportunity_referrals.user
requisitions.owner = opportunity_referrals.user

backfill

BOOLEAN

createdAt

DATE-TIME

creator

STRING

department

STRING

employmentStatus

STRING

headcountHired

INTEGER

headcountTotal

STRING

hiringManager

STRING

id

STRING

internalNotes

STRING

location

STRING

name

STRING

offerIds

ARRAY

owner

STRING

postings

ARRAY

requisitionCode

STRING

status

STRING

team

STRING

sources

The sources table contains info about sources, or the ways that candidates enter into your Lever account.

Replication Method

Full Table

Primary Key

text

Useful links

Lever documentation

sources schema on GitHub

Lever API method

count

INTEGER

text

STRING

stages

The stages table contains info about stages, or the steps in the recruiting workflow in your hiring pipeline.

Replication Method

Full Table

Primary Key

id

Useful links

Lever documentation

stages schema on GitHub

Lever API method

Join stages with on
candidates
stages.id = candidates.stage
stages.id = candidates.stageChanges.toStageId
opportunities
stages.id = opportunities.stage
stages.id = opportunities.stageChanges.toStageId

id

STRING

text

STRING

users

The users table contains info about the users in your Lever account. A user includes anyone who has been invited to Lever to collaborate on recruiting efforts.

Replication Method

Full Table

Primary Key

id

Useful links

Lever documentation

users schema on GitHub

Lever API method

accessRole

STRING

createdAt

DATE-TIME

deactivatedAt

DATE-TIME

email

STRING

externalDirectoryId

STRING

id

STRING

name

STRING

photo

STRING

username

STRING


Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.