---
title: "Import candidates from a tracker's CSV"
method: POST
path: "/openings/{opening_id}/applications/import"
tags: ["application"]
---

# Import candidates from a tracker's CSV

`POST /openings/{opening_id}/applications/import`

## Request

- Base URL: `https://localhost:4410/api/v1`
- URL: `https://localhost:4410/api/v1/openings/{opening_id}/applications/import`
- Auth: HTTP bearer

Reads a CSV or XLSX export from Notion, Airtable or a spreadsheet into one job: each row with an email becomes an application with the source "Imported from {file}". A dry run shows each row as it will land. A row without an email, or with one already on the job, is listed and left out. No email goes to anyone.

## Path parameters

- `opening_id` string, required

## Request body

- object
  - `file_name` string, required
  - `content_base64` string, base64, required
  - `mapping` object
    - `name` integer, nullable, required
    - `email` integer, required
    - `stage` integer, nullable, required
    - `links` integer, nullable, required
    - `note` integer, nullable, required
  - `dry_run` boolean

## Response `200`

The result.

- object
  - `columns` string[], required
  - `mapping` object, required
    - `name` integer, nullable, required
    - `email` integer, required
    - `stage` integer, nullable, required
    - `links` integer, nullable, required
    - `note` integer, nullable, required
  - `rows` object[], required
    - `row` integer, required
    - `name` string, required
    - `email` string, required
    - `stage` 'applied' | 'screen' | 'interview' | 'offer' | 'hired' | 'rejected', required
    - `links` string[], required
    - `note` string, nullable, required
    - `problem` string, nullable, required
  - `imported` integer, required

## Other responses

- `default`: An RFC 9457 problem.

---

[API](https://skmtc.dev/binderwork/apis/binderwork-api.md) · [All operations](https://skmtc.dev/binderwork/apis/binderwork-api/llms.txt) · [OpenAPI document](https://skmtc.dev/binderwork/apis/binderwork-api/revisions/f8fab0ebee53?raw)