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:

  • For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
  • For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.

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

View table schema on GitHub
Replication Method :

Full Table

 Primary Key :

id
API endpoint :

List all 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.

candidates

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at

Primary Key :

id

 API endpoint :

List all 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

candidates table schema

id
STRING

The candidate ID.

applications
ARRAY

The ID of the candidate’s application.

archived
OBJECT

Details about the candidate’s archived status.

Click to expand archived

archivedAt
DATE-TIME

The datetime when the candidate was archived.

reason
STRING

The ID of the archive reason applied to the candidate.

Reference:

candidates (table), archived (attribute)

contact
STRING

The candidate’s contact ID.

Reference:

createdAt
DATE-TIME

The datetime when the candidate was created in Lever.

dataProtection
OBJECT

Details about the candidate’s data protection status, based on candidate-provided consent and applicable data policy regulations. If there isn’t a policy in place or if no policies are applicable to the candidate, the values of these fields may be null.

Click to expand dataProtection

contact
OBJECT

Details about the consent status for a specified processing activity.

Click to expand contact

allowed
BOOLEAN

If true, the applicable data policy regulation allows for storage of this record.

expiresAt
DATE-TIME

The timestamp when this permission expires.
candidates (table), contact (attribute)

store
OBJECT

Details about the consent status for a specified processing activity.

Click to expand store

allowed
BOOLEAN

If true, the applicable data policy regulation allows for storage of this record.

expiresAt
DATE-TIME

The timestamp when this permission expires.
candidates (table), store (attribute)
candidates (table), dataProtection (attribute)

emails
ARRAY

A list of emails for the candidate.

Click to expand emails

value
STRING

The email address.
candidates (table), emails (attribute)

followers
ARRAY

A list of IDs of the users following the candidate.

headline
STRING

The candidate’s headline. This is typically a list of previous companies where the candidate has worked or schools the candidate has attended.

isAnonymized
BOOLEAN

If true, the candidate has been anonymized.

lastAdvancedAt
DATE-TIME

The datetime when the candidate advanced to the current stage.

lastInteractionAt
DATE-TIME

The datetime when the last interaction with candidate occurred.

links
ARRAY

A list of links for the candidate.

location
STRING

The candidate’s current location.

name
STRING

The candidate’s full name.

origin
STRING

The way the candidate was added to Lever. Possible values are:

  • agency
  • applied
  • internal
  • referred
  • sourced
  • university

owner
STRING

The ID of the owner of the candidate.

Reference:

phones
ARRAY

A list of phone numbers for the candidate.

Click to expand phones

type
STRING

The type of phone number.

value
STRING

The phone number.
candidates (table), phones (attribute)

resume
OBJECT

Details about the candidate’s resume.

snoozedUntil
DATE-TIME

If the candidate is snoozed, this field will reflect the datetime when the snooze period ends.

sources
ARRAY

A list of sources associated with the candidate.

Click to expand sources

value
STRING

The source.
candidates (table), sources (attribute)

stage
STRING

The ID of the candidate’s current stage.

Reference:

stageChanges
ARRAY

Historical details of the candidate’s stage changes.

tags
ARRAY

A list of tags applied to the candidate.

Click to expand tags

value
STRING

The tag.
candidates (table), tags (attribute)

urls
OBJECT

A list of list and show URLs for the candidate.

Click to expand urls

list
STRING

The URL that points to the account’s list of candidates.

show
STRING

The URL that points to the candidate’s profile page for this opportunity.
candidates (table), urls (attribute)

candidate_applications

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

candidates.updated_at

Primary Key :

id

 API endpoint :

List all applications for a candidate

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

candidate_applications table schema

id
STRING

The candidate application ID.

Reference:

archived
OBJECT

The application’s archived status.

Click to expand archived

archivedAt
NUMBER

The datetime when the application was last archived.

reason
STRING

The reason why the application was archived.

Reference:

candidate_applications (table), archived (attribute)

candidateId
STRING

The ID of the candidate associated with the application.

Reference:

comments
STRING

Any additional comments from the candidate included in the application.

company
STRING

The candidate’s current company or organization.

createdAt
NUMBER

Datetime the application was created in Lever.

customQuestions
ARRAY

If application is type: referral, this data will include a referral form. If application is type:posting, this data will include customized posting forms.

email
STRING

The email address of the candidate who applied.

links
ARRAY

A list of links associated with the candidate.

name
STRING

The name of the candidate who applied.

phone
OBJECT

The phone numbers for the candidate.

Click to expand phone

type
STRING

The type of phone number.

value
STRING

The phone number.
candidate_applications (table), phone (attribute)

posting
STRING

The ID of the job posting associated with the application.

Reference:

postingHiringManager
STRING

The hiring manager of the job posting at the time when the candidate applies to that job.

Reference:

postingOwner
STRING

The ID of the user who owned the job posting when the candidate applied to the job.

Reference:

requisitionForHire
OBJECT

If the application was archived as hired against a requisition, this is the data related to the requisition.

resume
OBJECT

Details about the candidate’s resume. This field has been deprecated by Lever.

type
STRING

The type of application. Possible values are:

  • referral
  • user
  • posting

user
STRING

If the application is a referral, this is the user who made the referral.

Reference:

candidate_offers

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

candidates.updated_at

Primary Key :

id

 API endpoint :

List all offers for a candidate

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

candidate_offers table schema

id
STRING

The offer ID.

Reference:

approvedAt
DATE-TIME

The datetime when the offer was approved.

createdAt
DATE-TIME

The datetime when the offer was created.

creator
STRING

The ID of the offer creator.

Reference:

fields
ARRAY

Details about the fields on the offer. This includes standard fields and all custom fields.

Click to expand fields

identifier
STRING

The underscored, machine-readable name identifier of the field.

text
STRING

The plain text name of the field.

value
STRING

The value of the field.
candidate_offers (table), fields (attribute)

sentAt
DATE-TIME

The datetime when the offer was sent.

signatures
OBJECT

Details about the signature(s) associated with the offer.

Click to expand signatures

email
STRING

The email of the signee.

firstOpenedAt
DATE-TIME

The time when the signee first opened the offer.

lastOpenedAt
DATE-TIME

The time when the signee last opened the offer.

name
STRING

The name of the signee.

role
STRING

The role of the signee.

signed
BOOLEAN

If true, the signee signed the offer.

signedAt
DATE-TIME

The time when the signee signed the offer.
candidate_offers (table), signatures (attribute)

status
STRING

The status of the offer. Possible values are:

  • draft - The offer is still under construction
  • approval-sent - The offer needs approval
  • approved - The offer has been approved
  • sent - The offer has been sent through Lever
  • sent-manually - The offer has been sent to the candidate outside of Lever
  • opened - The candidate has opened the offer
  • denied - The candidate denied the offer
  • signed - The candidate signed the offer

candidate_referrals

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

candidates.updated_at

Primary Key :

id

 API endpoint :

List all referrals for a candidate

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

candidate_referrals table schema

id
STRING

The referral ID.

Reference:

baseTemplateId
STRING

The form template ID associated with the referral.

completedAt
DATE-TIME

The datetime the referral was completed.

createdAt
DATE-TIME

The datetime the referral was created.

fields
ARRAY

Details about the fields on the referral form.

Click to expand fields

description
STRING

A description of the field.

options
ARRAY

The valid values for the field. Note: This isn’t applicable to all field types.

Click to expand options

text
STRING

The valid value for the field.
candidate_referrals (table), options (attribute)

prompt
STRING

If an option for the field isn’t selected, this prompt will be displayed. Note: This isn’t applicable to all field types.

required
BOOLEAN

If true, the field is required.

text
STRING

The field’s label text.

type
STRING

The field type. Possible values are:

  • currency
  • date
  • dropdown
  • multiple-choice
  • multiple-select
  • score
  • scorecard
  • text
  • textarea
  • yes-no

value
STRING

The value of the field.
candidate_referrals (table), fields (attribute)

instructions
STRING

The instructions on the referral form.

referrer
STRING

The ID of the referrer.

Reference:

stage
STRING

The stage of the candidate at the time the form was completed.

text
STRING

The title of the referral form.

type
STRING

The form type.

user
STRING

The ID of the referral creator.

Reference:

candidate_resumes

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

candidates.updated_at

Primary Key :

id

 API endpoint :

List all resumes for a candidate

The candidate_resumes table contains info about candidate resumes.

candidate_resumes table schema

id
STRING

The resume ID.

Reference:

createdAt
DATE-TIME

The datetime when the resume was created in Lever.

file
OBJECT

Metadata about the resume file.

Click to expand file

downloadUrl
STRING

The resume file download URL.

ext
STRING

The resume file extension.

name
STRING

The resume file name.

uploadedAt
NUMBER

The datetime when the file was uploaded in Lever.
candidate_resumes (table), file (attribute)

parsedData
OBJECT

The candidate’s parsed resume, usually extracted from an attached PDF/Word document or online profile.

Click to expand parsedData

positions
ARRAY

A list of positions held by the candidate.

Click to expand positions

org
STRING

The organization.

title
STRING

The title of the position.

summary
STRING

The summary of the position.

location
STRING

The location of the position.

start
OBJECT

The start date of the position.

Click to expand start

month
INTEGER

The month.

year
INTEGER

The year.
candidate_resumes (table), start (attribute)

end
OBJECT

The end date of the position.

Click to expand end

month
INTEGER

The month.

year
INTEGER

The year.
candidate_resumes (table), end (attribute)
candidate_resumes (table), positions (attribute)

school
ARRAY

A list of schools the candidate attended.

Click to expand school

org
STRING

The name of the school.

degree
STRING

The name of the degree the candidate pursued.

summary
STRING

The summary of the candidate’s studies.

field
STRING

The candidate’s field of study.

start
OBJECT

The date the candidate started studying at the school.

Click to expand start

month
INTEGER

The month.

year
INTEGER

The year.
candidate_resumes (table), start (attribute)

end
OBJECT

The date the candidate left the school.

Click to expand end

month
INTEGER

The month.

year
INTEGER

The year.
candidate_resumes (table), end (attribute)
candidate_resumes (table), school (attribute)
candidate_resumes (table), parsedData (attribute)

opportunities

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at

Primary Key :

id

 API endpoint :

List all 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

opportunities table schema

id
STRING

The opportunity ID.

Reference:

applications
ARRAY

The ID of the candidate’s application.

archived
OBJECT

Details about the opportunity’s archived status.

Click to expand archived

archivedAt
DATE-TIME

The datetime when the opportunity was archived.

reason
STRING

The ID of the archive reason applied to the opportunity.

Reference:

opportunities (table), archived (attribute)

contact
STRING

The opportunity’s contact ID.

Reference:

createdAt
DATE-TIME

The datetime when the opportunity was created in Lever.

dataProtection
OBJECT

Details about the opportunity’s data protection status, based on opportunity-provided consent and applicable data policy regulations. If there isn’t a policy in place or if no policies are applicable to the opportunity, the values of these fields may be null.

Click to expand dataProtection

contact
OBJECT

Details about the consent status for a specified processing activity.

Click to expand contact

allowed
BOOLEAN

If true, the applicable data policy regulation allows for storage of this record.

expiresAt
DATE-TIME

The timestamp when this permission expires.
opportunities (table), contact (attribute)

store
OBJECT

Details about the consent status for a specified processing activity.

Click to expand store

allowed
BOOLEAN

If true, the applicable data policy regulation allows for storage of this record.

expiresAt
DATE-TIME

The timestamp when this permission expires.
opportunities (table), store (attribute)
opportunities (table), dataProtection (attribute)

emails
ARRAY

A list of emails for the opportunity.

Click to expand emails

value
STRING

The email address.
opportunities (table), emails (attribute)

followers
ARRAY

A list of IDs of the users following the opportunity.

headline
STRING

The contact’s headline. This is typically a list of previous companies where the contact has worked or schools the contact has attended.

isAnonymized
BOOLEAN

If true, the opportunity has been anonymized.

lastAdvancedAt
DATE-TIME

The datetime when the candidate advanced to the current stage for this opportunity.

lastInteractionAt
DATE-TIME

The datetime when the last interaction with opportunity occurred.

links
ARRAY

A list of links for the opportunity.

location
STRING

The opportunity’s current location.

name
STRING

The opportunity’s full name.

origin
STRING

The way the opportunity was added to Lever. Possible values are:

  • agency
  • applied
  • internal
  • referred
  • sourced
  • university

owner
STRING

The ID of the owner of the opportunity.

Reference:

phones
ARRAY

A list of phone numbers for the opportunity.

Click to expand phones

type
STRING

The type of phone number.

value
STRING

The phone number.
opportunities (table), phones (attribute)

resume
OBJECT

Details about the opportunity’s resume. This field has been deprecated by Lever.

snoozedUntil
DATE-TIME

If the opportunity is snoozed, this field will reflect the datetime when the snooze period ends.

sources
ARRAY

A list of sources associated with the opportunity.

Click to expand sources

value
STRING

The source.
opportunities (table), sources (attribute)

stage
STRING

The ID of the opportunity’s current stage.

Reference:

stageChanges
ARRAY

Historical details of the opportunity’s stage changes.

tags
ARRAY

A list of tags applied to the opportunity.

Click to expand tags

value
STRING

The tag.
opportunities (table), tags (attribute)

urls
OBJECT

A list of list and show URLs for the opportunity.

Click to expand urls

list
STRING

The URL that points to the account’s list of opportunitys.

show
STRING

The URL that points to the opportunity’s profile page for this opportunity.
opportunities (table), urls (attribute)

opportunity_applications

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

opportunities.updated_at

Primary Key :

id

 API endpoint :

List all opportunities

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.

opportunity_applications table schema

id
STRING

The opportunity application ID.

Reference:

archived
OBJECT

The application’s archived status.

Click to expand archived

archivedAt
NUMBER

The datetime when the application was last archived.

reason
STRING

The reason why the application was archived.

Reference:

opportunity_applications (table), archived (attribute)

candidateId
STRING

The ID of the candidate associated with the application.

Reference:

comments
STRING

Any additional comments from the candidate included in the application.

company
STRING

The candidate’s current company or organization.

createdAt
NUMBER

Datetime the application was created in Lever.

customQuestions
ARRAY

If application is type: referral, this data will include a referral form. If application is type:posting, this data will include customized posting forms.

email
STRING

The email address of the candidate who applied.

links
ARRAY

A list of links associated with the candidate.

name
STRING

The name of the candidate who applied.

phone
OBJECT

The phone numbers for the candidate.

Click to expand phone

type
STRING

The type of phone number.

value
STRING

The phone number.
opportunity_applications (table), phone (attribute)

posting
STRING

The ID of the job posting associated with the application.

Reference:

postingHiringManager
STRING

The hiring manager of the job posting at the time when the candidate applies to that job.

Reference:

postingOwner
STRING

The ID of the user who owned the job posting when the candidate applied to the job.

Reference:

requisitionForHire
OBJECT

If the application was archived as hired against a requisition, this is the data related to the requisition.

resume
OBJECT

Details about the candidate’s resume. This field has been deprecated by Lever.

type
STRING

The type of application. Possible values are:

  • referral
  • user
  • posting

user
STRING

If the application is a referral, this is the user who made the referral.

Reference:

opportunity_offers

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

opportunities.updated_at

Primary Key :

None

 API endpoint :

List all opportunities

The opportunity_offers table contains info about

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

opportunity_offers table schema

id
STRING

The offer ID.

Reference:

approved
BOOLEAN

approvedAt
DATE-TIME

The datetime when the offer was approved.

createdAt
DATE-TIME

The datetime when the offer was created.

creator
STRING

The ID of the offer creator.

Reference:

fields
ARRAY

Details about the fields on the offer. This includes standard fields and all custom fields.

Click to expand fields

identifier
STRING

The underscored, machine-readable name identifier of the field.

text
STRING

The plain text name of the field.

value
STRING

The value of the field.
opportunity_offers (table), fields (attribute)

opportunityId
STRING

The ID of the opportunity associated with the offer.

Reference:

posting
STRING

The ID of the posting associated with the offer.

Reference:

sentAt
DATE-TIME

The datetime when the offer was sent.

sentDocument
OBJECT

Details about the document sent to the candidate.

Click to expand sentDocument

downloadUrl
STRING

The URL to access the file.

fileName
STRING

The name of the file.

uploadedAt
DATE-TIME

The timestamp when the file was uploaded.
opportunity_offers (table), sentDocument (attribute)

signatures
OBJECT

Details about the signature(s) associated with the offer.

Click to expand signatures

candidate
OBJECT

Details about the candidate’s signature.

Click to expand candidate

email
STRING

The email of the candidate.

firstOpenedAt
DATE-TIME

The time when the candidate first opened the offer.

lastOpenedAt
DATE-TIME

The time when the candidate last opened the offer.

name
STRING

The name of the candidate.

role
STRING

The role of the candidate.

signed
BOOLEAN

If true, the candidate signed the offer.

signedAt
DATE-TIME

The time when the candidate signed the offer.
opportunity_offers (table), candidate (attribute)

email
STRING

The email of the signee.

firstOpenedAt
DATE-TIME

The time when the signee first opened the offer.

lastOpenedAt
DATE-TIME

The time when the signee last opened the offer.

name
STRING

The name of the signee.

role
STRING

The role of the signee.

signed
BOOLEAN

If true, the signee signed the offer.

signedAt
DATE-TIME

The time when the signee signed the offer.
opportunity_offers (table), signatures (attribute)

signedDocument
OBJECT

Details about the signed offer file.

Click to expand signedDocument

downloadUrl
STRING

The URL to access the file.

fileName
STRING

The name of the file.

uploadedAt
DATE-TIME

The timestamp when the file was uploaded.
opportunity_offers (table), signedDocument (attribute)

status
STRING

The status of the offer. Possible values are:

  • draft - The offer is still under construction
  • approval-sent - The offer needs approval
  • approved - The offer has been approved
  • sent - The offer has been sent through Lever
  • sent-manually - The offer has been sent to the candidate outside of Lever
  • opened - The candidate has opened the offer
  • denied - The candidate denied the offer
  • signed - The candidate signed the offer

opportunity_referrals

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

opportunities.updated_at

Primary Key :

id

 API endpoint :

List all opportunities

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.

opportunity_referrals table schema

id
STRING

The referral ID.

Reference:

baseTemplateId
STRING

The form template ID associated with the referral.

completedAt
DATE-TIME

The datetime the referral was completed.

createdAt
DATE-TIME

The datetime the referral was created.

fields
ARRAY

Details about the fields on the referral form.

Click to expand fields

description
STRING

A description of the field.

options
ARRAY

The valid values for the field. Note: This isn’t applicable to all field types.

Click to expand options

text
STRING

The valid value for the field.
opportunity_referrals (table), options (attribute)

prompt
STRING

If an option for the field isn’t selected, this prompt will be displayed. Note: This isn’t applicable to all field types.

required
BOOLEAN

If true, the field is required.

text
STRING

The field’s label text.

type
STRING

The field type. Possible values are:

  • currency
  • date
  • dropdown
  • multiple-choice
  • multiple-select
  • score
  • scorecard
  • text
  • textarea
  • yes-no

value
STRING

The value of the field.
opportunity_referrals (table), fields (attribute)

instructions
STRING

The instructions on the referral form.

referrer
STRING

The ID of the referrer.

Reference:

stage
STRING

The stage of the candidate at the time the form was completed.

text
STRING

The title of the referral form.

type
STRING

The form type.

user
STRING

The ID of the referral creator.

Reference:

opportunity_resumes

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

opportunities.updated_at

Primary Key :

id

 API endpoint :

List all opportunities

The opportunity_resumes table contains info about candidate resumes.

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

opportunity_resumes table schema

id
STRING

The resume ID.

Reference:

createdAt
DATE-TIME

The datetime when the resume was created in Lever.

file
OBJECT

Metadata about the resume file.

Click to expand file

downloadUrl
STRING

The resume file download URL.

ext
STRING

The resume file extension.

name
STRING

The resume file name.

uploadedAt
NUMBER

The datetime when the file was uploaded in Lever.
opportunity_resumes (table), file (attribute)

parsedData
OBJECT

The candidate’s parsed resume, usually extracted from an attached PDF/Word document or online profile.

Click to expand parsedData

positions
ARRAY

A list of positions held by the candidate.

Click to expand positions

org
STRING

The organization.

title
STRING

The title of the position.

summary
STRING

The summary of the position.

location
STRING

The location of the position.

start
OBJECT

The start date of the position.

Click to expand start

month
INTEGER

The month.

year
INTEGER

The year.
opportunity_resumes (table), start (attribute)

end
OBJECT

The end date of the position.

Click to expand end

month
INTEGER

The month.

year
INTEGER

The year.
opportunity_resumes (table), end (attribute)
opportunity_resumes (table), positions (attribute)

school
ARRAY

A list of schools the candidate attended.

Click to expand school

org
STRING

The name of the school.

degree
STRING

The name of the degree the candidate pursued.

summary
STRING

The summary of the candidate’s studies.

field
STRING

The candidate’s field of study.

start
OBJECT

The date the candidate started studying at the school.

Click to expand start

month
INTEGER

The month.

year
INTEGER

The year.
opportunity_resumes (table), start (attribute)

end
OBJECT

The date the candidate left the school.

Click to expand end

month
INTEGER

The month.

year
INTEGER

The year.
opportunity_resumes (table), end (attribute)
opportunity_resumes (table), school (attribute)
opportunity_resumes (table), parsedData (attribute)

postings

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updatedAt
Primary Key :

id

 API endpoint :

List all postings

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

postings table schema

id
STRING

The job posting ID.

Reference:

updatedAt
DATE-TIME

The datetime when the posting was last updated.

categories
OBJECT

Click to expand categories

commitment
STRING

The tag for the position’s work type. For example: Full-time, Part-time, etc.

department
STRING

The tag for the department to which the posting’s team belongs.

level
STRING

This field has been deprecated by Lever. The tag for the posting’s level. For example: Senior

location
STRING

The tag for the posting’s position location.

team
STRING

The tag for the team to which the posting belongs. For example: Engineering, Documentation
postings (table), categories (attribute)

content
OBJECT

The content of the posting, including any custom questions.

Click to expand content

closing
STRING

The plaintext closing statement on the posting.

customQuestions
ARRAY

Click to expand customQuestions

value
STRING

postings (table), customQuestions (attribute)

description
STRING

The plaintext posting description shown at the top of the jobs page.

lists
ARRAY

A list of requirements, responsibilities, etc. added to the posting.

Click to expand lists

content
STRING

The HTML content of the list.

text
STRING

The title of the list.
postings (table), lists (attribute)
postings (table), content (attribute)

createdAt
DATE-TIME

The datetime when the posting was created.

distributionChannels
ARRAY

A list of job sites that a published posting appears on.

Click to expand distributionChannels

value
STRING

The job site.
postings (table), distributionChannels (attribute)

followers
STRING

A list of IDs of users following the posting.

hiringManager
STRING

The user ID of the hiring manager for the job posting.

Reference:

owner
STRING

The ID of the posting owner. The posting owner is the user who is responsible for managing all candidates who applied to the position.

Reference:

reqCode
STRING

The requisition code associated with the posting. This field has been deprecated by Lever.

state
STRING

The posting’s current status. Refer to Lever’s documentation for a list of possible values.

tags
ARRAY

A list of additional posting tags.

Click to expand tags

value
STRING

The posting tag.
postings (table), tags (attribute)

text
STRING

The title of the job posting.

urls
OBJECT

A list of the list, show, and apply URLs for the posting.

Click to expand urls

apply
STRING

The URL for the posting’s apply page.

list
STRING

The URL for the account’s list of postings.

show
STRING

The URL for the posting’s information page.
postings (table), urls (attribute)

user
STRING

The ID of the user who created the posting.

Reference:

requisitions

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

createdAt
Primary Key :

id

 API endpoint :

List all requisitions

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

requisitions table schema

id
STRING

The requisition ID.

Reference:

createdAt
DATE-TIME

The datetime when the requisition was created.

backfill
BOOLEAN

If true, the requisition represents a backfill. If false, the requisition hasn’t been specified or represents a new headcount.

compensationBand
OBJECT

Details about the compensation band associated with the requisition band.

Click to expand compensationBand

currency
STRING

The ISO currency code associated with the requisition’s compensation band.

interval
STRING

The interval of payment for the compensation band.

min
INTEGER

The low-bound number for the compensation band.

max
INTEGER

The high-bound number for the compensation band.
requisitions (table), compensationBand (attribute)

creator
STRING

The user ID of the requisition’s creator.

Reference:

customFields
OBJECT

The custom fields associated with the requisition.

department
STRING

employmentStatus
STRING

The work type of the requisition. Possible values are:

  • full-time
  • part-time
  • intern
  • contractor
  • temp-worker

headcountHired
INTEGER

The number of filled seats or openings on the requisition.

headcountTotal
STRING

The total headcount alloted for this requisition.

hiringManager
STRING

The user ID of the hiring manager for this requisition.

Reference:

internalNotes
STRING

Details about the requisition.

location
STRING

The location associated with the requisition.

name
STRING

The name of the requisition.

offerIds