Sync interview feedback from Lever to a data warehouse

Verified steps

1. Authenticate against the Lever Data API using HTTP Basic Auth with your API key as the username and an empty password; base URL is https://api.lever.co/v1; for partner/multi-tenant apps use OAuth 2.0 Authorization Code flow with the audience parameter required in production
2. Retrieve all opportunities (candidates) by calling GET /v1/opportunities with pagination; use the limit (max 100 per page) and offset parameters, iterating until the hasNext field in the response is false
3. For each opportunity, retrieve associated feedback forms by calling GET /v1/opportunities/{opportunityId}/feedback; the response array contains form objects with fields (type, text, value), the completing user ID, the stage ID, and timestamps
4. Supplement feedback data with interviewer details by calling GET /v1/users/{userId} for each unique userId found in the feedback forms
5. Use Lever's Data Warehouse Sync (DWS) feature if you need a complete historical snapshot; DWS provides database credentials for direct access to a read replica of your Lever reporting data, updated once per day — suitable for bulk initial loads
6. For ongoing incremental sync, use the updated_at_start query parameter on /v1/opportunities to retrieve only records modified since your last sync timestamp; store the high-water mark after each successful run