> For the complete documentation index, see [llms.txt](https://docs.joinflo.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.joinflo.com/flo-apis/user-api/members-csv-import.md).

# Members CSV Import

Reference for the file format accepted by the members CSV import endpoint. Use alongside the OpenAPI spec for full request/response schemas.

### Endpoints <a href="#endpoints" id="endpoints"></a>

| Method | Path                                                 | Purpose                                                                                                                                                                                |
| ------ | ---------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `POST` | `/members/import-csv?product={Product}`              | Creates new members and updates existing members from CSV input. Returns created and updated counts, or a detailed error response. Rejects all rows if any single row contains errors. |
| `GET`  | `/members/example-csv/{product}/{numRows}`           | Downloads a sample CSV pre-populated with example rows appropriate for your org's office locations, SSO configuration, etc. `numRows` is capped at 1000.                               |
| `GET`  | `/members/import-instructions.pdf?product={Product}` | Downloads a PDF reference guide for the import flow. Recruit/University variants omit the Performance-only columns.                                                                    |

Both write paths accept `multipart/form-data` with the CSV provided in the `file` part. The `product` query parameter is required on `import-csv` and is one of the values defined by the `Product` enum in the OpenAPI spec (e.g. `PERFORM`, `RECRUIT`).

#### Authorization <a href="#authorization" id="authorization"></a>

* Send your API key as `Authorization: Bearer <key>`, or an administrator session as the session cookie returned by the login endpoint. A session needs the **Perform Admin** role for `product=PERFORM`, and the **Admin** role for other products.
* With an API key, `product` must be `RECRUIT` or `PERFORM`. A key manages members but not administrators: a row that would grant or remove the admin role, or change an administrator's email, is rejected with the row error type `NOT_PERMITTED`.

### File-level requirements <a href="#file-level-requirements" id="file-level-requirements"></a>

| Requirement   | Value                                                                                           |
| ------------- | ----------------------------------------------------------------------------------------------- |
| Encoding      | UTF-8. An optional UTF-8 BOM is accepted and stripped.                                          |
| Max file size | 10 MB                                                                                           |
| Line endings  | LF or CRLF                                                                                      |
| Header row    | Required. Must include at least the three required columns (see [Header rules](#header-rules)). |

There is no enforced row-count cap, but very large files should respect the 10 MB size limit.

### Header rules <a href="#header-rules" id="header-rules"></a>

Column matching is **case-insensitive** and **order-independent**. Header rules are otherwise strict:

* **Required headers must be present.** `First Name`, `Last Name`, and `Email` must all appear in the header row. Missing any of them rejects the file with `MISSING_REQUIRED_COLUMNS`.
* **Unknown headers reject the file.** Any header not in the recognized column list below causes a `UNEXPECTED_COLUMNS` file error. There is no "ignore extras" behavior — clean up your column names before submitting.
* **Which columns you include matters for updates.** When updating an existing member, the *presence* of a column header (independent of whether its cells are blank) controls whether that field is preserved or cleared. See [Update semantics](#update-semantics) below.

#### Recognized headers (case-insensitive) <a href="#recognized-headers-case-insensitive" id="recognized-headers-case-insensitive"></a>

```
Employee ID, First Name, Last Name, Email, Job Title, Level,
Office City, Office State (US Only), Office Country (Non-US Only),
Department, Practice Area, Law School, Graduation Year,
Effective Class Year, Start Date, Role, SSO ID, Use MFA,
Bio Link, Work Arrangement,
New Email, FLSA Status, Manager Email, Mentor Emails
```

### Column reference <a href="#column-reference" id="column-reference"></a>

All required-ness, type, and constraint information below reflects the **actual validator behavior**. A few items here differ from the inline `description` text on the endpoint — when in doubt, this document is the source of truth.

| Column                           | Type           | Required | Constraints                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Example                       |
| -------------------------------- | -------------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------------------------- |
| **First Name**                   | string         | Yes      | Must not contain: backslash, carriage return, newline, less-than sign, greater-than sign, pipe, double quote, or backtick.                                                                                                                                                                                                                                                                                                                                                                             | `Jane`                        |
| **Last Name**                    | string         | Yes      | Same disallowed-character set as First Name.                                                                                                                                                                                                                                                                                                                                                                                                                                                           | `Smith`                       |
| **Email**                        | string         | Yes      | Must be a well-formed email address. Must be unique across rows in the file (case-insensitive).                                                                                                                                                                                                                                                                                                                                                                                                        | `jane.smith@firm.com`         |
| **Employee ID**                  | string         | No       | Treated as an opaque identifier. When provided, must be unique across rows in the file (case-insensitive). Not required to be numeric.                                                                                                                                                                                                                                                                                                                                                                 | `E-1042`                      |
| **Job Title**                    | string         | No       | None.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | `Senior Associate`            |
| **Level**                        | string         | No       | Must match one of the org's configured member levels (case-insensitive). **Only persisted when `product=PERFORM`** — silently ignored for other products.                                                                                                                                                                                                                                                                                                                                              | `Senior`                      |
| **Office City**                  | string         | No       | When provided, exactly one of Office State or Office Country must also be provided. See [Office location rules](#office-location-rules).                                                                                                                                                                                                                                                                                                                                                               | `New York`                    |
| **Office State (US Only)**       | string         | No       | Mutually exclusive with Office Country. Must accompany Office City when set.                                                                                                                                                                                                                                                                                                                                                                                                                           | `NY`                          |
| **Office Country (Non-US Only)** | string         | No       | Mutually exclusive with Office State. Must accompany Office City when set.                                                                                                                                                                                                                                                                                                                                                                                                                             | `United Kingdom`              |
| **Department**                   | string         | No       | When provided, must match one of the org's configured departments.                                                                                                                                                                                                                                                                                                                                                                                                                                     | `Litigation`                  |
| **Practice Area**                | string         | No       | When provided, must match one of the org's configured practice areas.                                                                                                                                                                                                                                                                                                                                                                                                                                  | `Corporate`                   |
| **Law School**                   | string         | No       | When provided, must match one of the configured law schools. See [Education writes](#education-writes-law-school-graduation-year) for upsert behavior.                                                                                                                                                                                                                                                                                                                                                 | `Columbia Law School`         |
| **Graduation Year**              | string         | No       | 4 digits, must be within 200 years of the current year. **Only persisted when `product=PERFORM`** — silently ignored for other products.                                                                                                                                                                                                                                                                                                                                                               | `2018`                        |
| **Effective Class Year**         | string         | No       | 4 digits, must be within 200 years of the current year. **Only persisted when `product=PERFORM`** — silently ignored for other products.                                                                                                                                                                                                                                                                                                                                                               | `2020`                        |
| **Start Date**                   | date           | No       | Format `yyyy-MM-dd`.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | `2025-06-03`                  |
| **Role**                         | enum           | No       | `ADMIN` or `MEMBER` (case-sensitive). If omitted or blank on a new member, defaults to `MEMBER`.                                                                                                                                                                                                                                                                                                                                                                                                       | `MEMBER`                      |
| **SSO ID**                       | string         | No       | Required only when your org uses SSO and is not configured to use email-as-SSO-ID. Otherwise ignored. Specific validation depends on your org's SSO configuration.                                                                                                                                                                                                                                                                                                                                     | `jsmith`                      |
| **Use MFA**                      | boolean string | No       | One of (case-insensitive): `true`, `t`, `1`, `yes`, `y`, `false`, `f`, `0`, `no`, `n`.                                                                                                                                                                                                                                                                                                                                                                                                                 | `true`                        |
| **Bio Link**                     | URL            | No       | Must be a syntactically valid URL.                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | `https://firm.com/bio/jsmith` |
| **Work Arrangement**             | enum           | No       | One of: `REMOTE`, `HYBRID`, `IN_PERSON` (case-sensitive).                                                                                                                                                                                                                                                                                                                                                                                                                                              | `HYBRID`                      |
| **Manager Email**                | string         | No       | Must be a well-formed email address matching a member already in your org or another row in the same file; matching is case-insensitive, so row order does not matter. A member cannot be their own manager. Single-valued. **Only persisted when `product=PERFORM`** — silently ignored for other products.                                                                                                                                                                                           | `alex.chen@firm.com`          |
| **Mentor Emails**                | string         | No       | One or more email addresses separated by semicolons (`;`), since a comma is the CSV delimiter itself. Each address must be well-formed and match a member already in your org or another row in the same file, on the same terms as Manager Email. A member cannot be their own mentor, and a repeated address counts once. At most 50 mentors per member. The value replaces the member's existing mentors outright. **Only persisted when `product=PERFORM`** — silently ignored for other products. | `kim@firm.com;raj@firm.com`   |
| **New Email**                    | string         | No       | Must be a well-formed email address. On a row whose Email matches an existing member, moves that member to this address; a blank or unchanged value is a no-op, and a row matching no existing member is rejected. No two rows may target the same address, and the address must not already belong to another user or employee in your org. **Only takes effect when the bulk email-update feature is enabled for your org** — contact your Flo representative to have it enabled.                    | `jane.s.smith@firm.com`       |
| **FLSA Status**                  | enum           | No       | One of `Exempt`, `Non-Exempt` or `Not Applicable`, or their upper-snake equivalents `EXEMPT`, `NON_EXEMPT` or `NOT_APPLICABLE`. **Only persisted when `product=PERFORM`** — silently ignored for other products.                                                                                                                                                                                                                                                                                       | `Exempt`                      |

#### Field handling rules that apply to every column <a href="#field-handling-rules-that-apply-to-every-column" id="field-handling-rules-that-apply-to-every-column"></a>

* **Leading and trailing whitespace is trimmed** from every value before validation.
* A field whose content is whitespace-only is treated as **missing** (`null`).
* Embedded commas, double quotes, and newlines in a value must be CSV-escaped per RFC 4180 (wrap the value in double quotes; double up internal `"`).

### Office location rules <a href="#office-location-rules" id="office-location-rules"></a>

The Office City / Office State / Office Country triad is validated as a unit. All four combinations below are valid:

<table><thead><tr><th>City</th><th width="187">State</th><th>Country</th><th>Valid?</th></tr></thead><tbody><tr><td>—</td><td>—</td><td>—</td><td>Yes (no office set)</td></tr><tr><td>set</td><td>set</td><td>—</td><td>Yes (US office)</td></tr><tr><td>set</td><td>—</td><td>set</td><td>Yes (non-US office)</td></tr><tr><td>—</td><td>—</td><td>—</td><td>Yes</td></tr></tbody></table>

Anything else produces a `ROW_VALUE_CONFLICT` or `EMPTY_REQUIRED_VALUE` row error:

* Office State or Office Country without Office City → conflict on the offending field.
* Office State **and** Office Country both set on the same row → conflict on both.
* Office City set with neither State nor Country → missing-required on both State and Country.

Beyond format-correctness, the resulting office location must match one of your org's configured offices (`INVALID_LIST_SELECTION` if it does not).

### Discovering valid list values <a href="#discovering-valid-list-values" id="discovering-valid-list-values"></a>

Five CSV columns require values that match lists set up in Flo or maintained by Flo. Use the endpoints below to retrieve the current set of valid values before building your CSV. They accept your API key or an administrator session; see [List Values](https://docs.joinflo.com/flo-apis/user-api/list-values.md) for paging, responses and errors.

| CSV column                        | Endpoint                    | Scope                                            | Returns                                                                                                                                                                                                                                                           |
| --------------------------------- | --------------------------- | ------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Law School**                    | `GET /law-schools`          | Global (the same for every Flo customer)         | Every recognized law school, with a stable `id` and its `name`. **A snapshot is also embedded below at** [**Law School values**](#law-school-values) **for convenience.**                                                                                         |
| **Practice Area**                 | `GET /users/practice-areas` | Flo's standard list + your custom list           | Every practice area that will pass validation.                                                                                                                                                                                                                    |
| **Department**                    | `GET /users/departments`    | Set up by your administrators                    | Your configured departments.                                                                                                                                                                                                                                      |
| **Office City / State / Country** | `GET /users/offices`        | Set up by your administrators                    | Your configured offices, each as one name such as `Dallas, Texas`: the city, then the state or country. Split each name at its first `,` to fill the three Office columns. See [Office location rules](#office-location-rules) for the format rules within a row. |
| **Level**                         | `GET /users/levels`         | Set up by your administrators (Performance only) | Your configured member levels. Non-Performance imports ignore the `Level` column regardless of the list.                                                                                                                                                          |

#### Law School values <a href="#law-school-values" id="law-school-values"></a>

<details>

<summary>Click to expand: full law school list (sorted case-insensitively)</summary>

```
Abertay University
Aberystwyth University
Al-Quds University - Faculty of Law
Albany Law School, Union University
American University Washington College of Law
Amsterdam Law School
Anglia Ruskin University
Antonin Scalia Law School - George Mason University
Appalachian School of Law
Arden University
Aston University
Athens University Law School
Atlanta's John Marshall Law School
Auckland Law School, the University of Auckland
Autonomous University of Madrid
Ave Maria School of Law
Bangor University
Bath Spa University
Baylor Law School
Beijing Foreign Studies University - School of Law
Belmont University College of Law
Benjamin N. Cardozo School of Law, Yeshiva University
Birkbeck, University of London
Birmingham City University
Birmingham Newman University
Bond University - Faculty of Law
Boston College Law School
Boston University School of Law
Bournemouth University
BPP University Law School
Brooklyn Law School
Brunel University London
Bucerius Law School
Buckingham Law School
Buckinghamshire New University
BYU J. Reuben Clark Law School
Cairo University - Faculty of Law
California Western School of Law
Campus Montesquieu - Université de Bordeaux
Canterbury Christ Church University
Capital University Law School
Cardiff Metropolitan University
Cardiff University School of Law and Politics
Case Western Reserve University School of Law
Cecil C. Humphreys School of Law, University of Memphis
Chapman University School of Law
Charles University Faculty of Law, Prague
Charleston School of Law
Charlotte School of Law
Chicago-Kent College of Law
China University of Political Science and Law
Chinese University of Hong Kong
City University of Hong Kong
Cleveland State University College of Law
College of Europe - Natolin
College of Law - Victoria
Columbia Law School
Cornell Law School
Coventry University
Creighton University School of Law
Cumberland School of Law
CUNY School of Law
CY Cergy Paris Université - Faculty of Law
Cyber University of Korea
Dalhousie University – Schulich School of Law
David A. Clarke School of Law, University of the District of Columbia
De Montfort University
Deakin Law School
DePaul University College of Law
Diamond Graduate Law School LLM Online Program
Drake University Law School
Drexel University Thomas R. Kline School of Law
Duke University School of Law
Duncan School of Law, Lincoln Memorial University
Durham University
Dwayne O. Andreas School of Law
Eberhard Karls University of Tübingen
EBS University of Business and Law
Edge Hill University
Edinburgh Law School
Edinburgh Napier University
Elon University School of Law
Emory University School of Law
Escuela Libre de Derecho
Facultad Libre de Derecho de Monterrey
Faculty of Law, University of Cologne
Ferrum College
Flagler College
Florida A&M University College of Law
Florida International University College of Law
Florida State University College of Law
Fordham University School of Law
Friedrich Schiller University (FSU) Jena - Faculty of Law
Fu Jen Catholic University, School of Law
Fundação Getulio Vargas
Georg August University of Göttingen -  Faculty of Law
George Mason University School of Law
George Washington University Law School
George Watson's College
Georgetown University Law Center
Georgia State University College of Law
Glasgow Caledonian University
Goethe University Frankfurt
Golden Gate University School of Law
Goldsmiths, University of London
Gonzaga University School of Law
Harvard Law School
Hasselt University - Faculty of Law
Hebrew University of Jerusalem - Faculty of Law
Heidelberg University
Heinrich Heine University Düsseldorf (HHU) - Faculty of Law
High Point University, Kenneth F. Kahn School of Law
Higher School of Economics - Faculty of Law
HKU-PKU
Howard University School of Law
Humboldt University of Berlin
Indiana University Maurer School of Law
Indiana University Robert H. McKinney School of Law
Instituto Tecnologico Autonomo De Mexico
Interamerican University of Puerto Rico School of Law
James E. Rogers College of Law, University of Arizona
JFK School of Law
Jindal Global Law School
Johannes Gutenberg-Universität Mainz
Justus Liebig University (JLU) Giessen - Faculty of Law
Keele University
Kent Law School
King's College London
Kingston University
Kobe University - Faculty of Law
KoGuan Law School, Shanghai Jiao Tong University
KU Leuven
Kyoto University - Faculty of Law
La Trobe Law School
Lakehead University – Faculty of Law
Lancaster University
Leeds Law School
Leeds Trinity University
Leibniz University Hannover (LUH) - Faculty of Law
Leipzig University
Lewis & Clark Law School
Liberty University School of Law
Lincoln Bishop University
Lincoln Law School, University of Lincoln
Liverpool Hope University
Liverpool John Moores University
Liverpool Law School
LMU Munich - Faculty of Law
Lomonosov Moscow State University - Faculty of Law
London Metropolitan University
London School of Economics and Political Science
London South Bank University
Loughborough University
Louis D. Brandeis School of Law, University of Louisville
Loyola Law School - Los Angeles
Loyola University Chicago School of Law
Loyola University New Orleans College of Law
LUISS Guido Carli University
Macquarie University Law School
Manchester Metropolitan University
Marquette University Law School
Maurice A. Deane School of Law, Hofstra University
McGeorge School of Law, University of the Pacific
McGill University Faculty of Law
Michael E. Moritz College of Law, Ohio State University
Michigan State University College of Law
Middlesex University
Mississippi College School of Law
Mitchell Hamline School of Law
Monash University
Moscow State Institute of International Relations
Nashville School of Law
National University of Singapore - Faculty of Law
New England Law
New York Law School
New York University School of Law
Newcastle Law School
Norman Adrian Wiggins School of Law, Campbell University
North Carolina Central University School of Law
Northeastern University School of Law
Northern Illinois University College of Law
Northumbria University
Northwestern Pritzker School of Law
Notre Dame Law School
Nottingham Law School
Ohio Northern University, Pettit College of Law
Oklahoma City University School of Law
Osgoode Hall Law School, York University
Other
Oxford Brookes University
Pace University School of Law
Panjab University - Faculty of Law
Paris Nanterre University
Paris-Saclay University (XI)
Paul M. Hebert Law Center, Louisiana State University
Peking University Law School
Penn State Dickinson School of Law
Penn State Law, Penn State University
Pepperdine Caruso School of Law
Pontifical Catholic University of Puerto Rico School of Law
Pontificia Universidad Católica Argentina
Pontificia Universidad Católica de Chile
Queen Mary University of London School of Law
Queen's University Belfast - School of Law
Queen’s University – Faculty of Law
Quinnipiac University School of Law
Regent University School of Law
Regent's University London
Rivers State University - Faculty of Law
Robert Gordon University
Robert Schuman University
Roger Williams University School of Law
Royal Holloway Law School
Russian School of Private Law
Russian State University of Justice
Rutgers Law School, Camden
Rutgers Law School, Newark
Ryerson University – Faculty of Law
S.J. Quinney College of Law, University of Utah
Saint Louis University School of Law
Salmon P. Chase College of Law, Northern Kentucky University
Sandra Day O'Connor College of Law, Arizona State University
Santa Clara University School of Law
Saratov State Academy of Law
Savannah Law School
School of Advanced Study, University of London
School of Law - Pontificia Universidad Javeriana
School of Law, Waseda University
Sciences Po
Sciences Po Strasbourg
Seattle University School of Law
Seoul National University Graduate School of International Studies
Seton Hall University School of Law
Shanghai University of Finance and Economics
Sheffield Hallam University
Shepard Broad Law Center, Nova Southeastern University
SMU Dedman School of Law
SOAS University of London
Sofia University St. Kilment Ohridski - Faculty of Law
Sophia University - Faculty of Law
South Texas College of Law Houston
Southampton Law School
Southampton Solent University
Southern Illinois University School of Law
Southern New Hampshire College
Southern University Law Center
Southwestern Law School
St Mary's University, Twickenham
St. John's University School of Law
St. Mary's University School of Law
St. Thomas University School of Law
Stanford Law School
Stetson University College of Law
Strathclyde Law School
Sturm College of Law, University of Denver
Suffolk University Law School
Swansea University
Symbiosis Law School
Syracuse University College of Law
Tbilisi State University - Faculty of Law
Teesside University
Tel Aviv University
Temple University James E. Beasley School of Law
Texas A&M University School of Law
Texas Tech University School of Law
The Australian National University
The Catholic University of America Columbus School of Law
The City Law School
The College of Law Moorgate, London
The College of Law, Australia
The College of Law, England & Wales
The College of Management School of Law
The Graduate Institute, Geneva (IHEID)
The Inns of Court School of Law
The Judge Advocate General's Legal Center and School
The Nigerian Law School
The Open University
The Universidad del Valle de México (UVM)
The University of Law
The University of Manchester
The University of Texas at Austin School of Law
The West Bengal National University of Juridical Sciences (NUJS)
Thomas Goode Jones School of Law, Faulkner University
Thomas Jefferson School of Law
Thomas R. Kline School of Law of Duquesne University
Thompson Rivers University – Faculty of Law
Thurgood Marshall School of Law, Texas Southern University
Touro College Jacob D. Fuchsberg Law Center
Trinity College Dublin - School of Law
Tsinghua University School of Law
Tulane University School of Law
UCD Sutherland School of Law
Ulster University
Universidad Católica Andrés Bello
Universidad de la República Faculty of Law
Universidad Iberoamericana School Of Law
Universidad Nacional Autonoma de Mexico
Universidad Panamericana
Universidad San Pablo CEU
Universidade Catolica De Sao Paulo
Universitat Pompeu Fabra (UPF)
University at Buffalo Law School, SUNY
University College London
University of Aberdeen
University of Akron School of Law
University of Alabama School of Law
University of Alberta – Faculty of Law
University of Arkansas School of Law
University of Baltimore School of Law
University of Bayreuth - Faculty of Law
University of Bedfordshire
University of Birmingham
University of Bonn - Law
University of Bradford
University of Brighton
University of Bristol
University of British Columbia – Faculty of Law
University of Buenos Aires School of Law
University of Calgary – Faculty of Law
University of California, Berkeley School of Law
University of California, Davis School of Law (King Hall)
University of California, Irvine School of Law
University of California, Los Angeles School of Law
University of California, San Francisco College of the Law
University of Cambridge
University of Catania – Faculty of Law
University of Chester
University of Chicago Law School
University of Chichester
University of Cincinnati College of Law
University of Colorado School of Law
University of Connecticut School of Law
University of Cumbria
University of Dayton School of Law
University of Delhi - Campus Law Centre
University of Derby
University of Detroit Mercy School of Law
University of Dundee
University of Durham
University of East Anglia
University of East London
University of Essex
University of Exeter Law School
University of Florida Levin College of Law
University of Freiburg
University of Georgia School of Law
University of Glasgow - School of Law
University of Gloucestershire
University of Greater Manchester
University of Greenwich
University of Hamburg
University of Helsinki - Faculty of Law
University of Hertfordshire
University of Hong Kong
University of Houston Law Center
University of Huddersfield
University of Hull
University of Idaho College of Law
University of Illinois Chicago School of Law
University of Illinois College of Law
University of Illinois Springfield
University of Iowa College of Law
University of Kansas School of Law
University of Kentucky College of Law
University of Konstanz
University of La Verne College of Law
University of Lagos - Faculty of Law
University of Lancashire
University of Leeds
University of Leicester
University of London - School of International Law
University of Maine School of Law
University of Malta - Faculty of Laws
University of Manitoba – Robson Hall Faculty of Law
University of Mannheim - Department of Law
University of Maryland Francis King Carey School of Law
University of Massachusetts School of Law
University of Melbourne
University of Miami School of Law
University of Michigan Law School
University of Minnesota Law School
University of Mississippi School of Law
University of Missouri School of Law
University of Missouri – Kansas City School of Law
University of Montana School of Law
University of Münster - Faculty of Law
University of Nebraska College of Law
University of New Brunswick – Faculty of Law
University of New Hampshire School of Law
University of New Mexico School of Law
University of New South Wales
University of North Carolina School of Law
University of North Dakota School of Law
University of North Texas Dallas College of Law
University of Northampton
University of Nottingham - School of Law
University of Oklahoma College of Law
University of Oregon School of Law
University of Otago - Faculty of Law
University of Ottawa – Common Law
University of Ottawa – Droit civil
University of Oxford
University of Passau School Of Law
University of Pavia
University of Pennsylvania Carey Law School
University of Pisa
University of Pittsburgh School of Law
University of Plymouth
University of Portsmouth
University of Puerto Rico School of Law
University of Queensland Law School
University of Reading School of Law
University of Regensburg - Faculty of Law
University of Richmond School of Law
University of Roehampton
University of Rome La Sapienza - Faculty of Law
University of Salford
University of San Diego School of Law
University of San Francisco School of Law
University of Sao Paulo Law School
University of Saskatchewan – College of Law
University of Sheffield
University of South Carolina School of Law
University of South Dakota School of Law
University of South Wales
University of St. Thomas School of Law
University of Staffordshire
University of Stirling
University of Suffolk
University of Sunderland
University of Surrey
University of Sussex
University of Sydney
University of Technology Sydney
University of Tennessee at Chattanooga
University of Tennessee College of Law
University of the Highlands and Islands
University of the West of England
University of the West of Scotland
University of the Witwatersrand School of Law
University of Toledo College of Law
University of Toronto Faculty of Law
University of Tours
University of Trier - Faculty of Law
University of Tulsa College of Law
University of Turin (UniTo) - Department of Law
University of Turku - Faculty of Law
University of Victoria – Faculty of Law
University of Virginia School of Law
University of Wales
University of Wales Trinity Saint David
University of Washington School of Law
University of West London
University of Western Australia
University of Western Ontario – Western Law
University of Westminster
University of Winchester
University of Windsor – Windsor Law
University of Wisconsin Law School
University of Wolverhampton
University of Worcester
University of Wyoming College of Law
University of Würzburg - Faculty of Law
Università Cattolica del Sacro Cuore (Catholic University of Milan) -  Faculty of Law
Université Catholique de Lille
Université de Bretagne Occidentale (UBO)
Université de Lorraine - Faculty of Law
Université de Moncton – Faculté de Droit
Université de Montréal – Faculté de Droit
Université de Paris Cité - Faculté de Droit
Université de Sherbrooke – Faculté de droit
Université du Québec – Faculté de Science Politique & Droit
Université Jean Moulin Lyon 3 - Faculty of Law
Université Laval – Baccalauréat en Droit
Université Libre de Bruxelles
Université Nantes
Université Paris 1 Panthéon-Sorbonne
Université Paris 5 René Descartes
Université Paris Dauphine - PSL
Université Paris-Est Créteil Val de Marne
Université Paris-Panthéon-Assas
USC Gould School of Law
Valparaiso University School of Law
Vanderbilt University Law School
Vermont Law and Graduate School
Vienna Law School
Villanova University Charles Widger School of Law
Wake Forest University School of Law
Walter F. George School of Law, Mercer University
Warwick Law School
Washburn University School of Law
Washington and Lee University School of Law
Washington University School of Law
Wayne State University Law School
West Virginia University College of Law
Western Michigan University Thomas M. Cooley Law School
Western New England University School of Law
Western State College of Law
Western Sydney University - School of Law
Widener Law Commonwealth
Widener University School of Law
Willamette University College of Law
William & Mary Law School
William H. Bowen School of Law, University of Arkansas at Little Rock
William S. Boyd School of Law, University of Nevada, Las Vegas
William S. Richardson School of Law, University of Hawaii
Wilmington University School of Law
Wrexham University
Yale Law School
Yonsei University Law School
York Law School
York St John University
```

</details>

#### Notes on using these endpoints <a href="#notes-on-using-these-endpoints" id="notes-on-using-these-endpoints"></a>

* **Lists can change between imports.** New law schools are added over time, and your administrators can add or edit departments, offices, practice areas and member levels. Re-fetch before each large import rather than caching long-term.
* **Comparison in member-import validation is exact, including case, except for Level, which ignores case.** Trailing whitespace in your CSV is trimmed before comparison; internal whitespace is not normalized — `"New York"` (two spaces) will not match `"New York"`.
* **Practice-area availability is feature-flag gated.** Your custom practice areas only count as valid values when the `custom-practice-areas` feature is enabled for you. `GET /users/practice-areas` returns the actual merged set that will pass validation.
* **`/officesStaticList` exists but is not the right list for imports.** It returns a global suggestion list used by the office-creation UI; member-import validation runs against your *configured* offices from `GET /users/offices`.
* **The older lookup endpoints still work with an administrator session.** `GET /lawSchoolsList.csv`, `/practiceAreas/current`, `/departments`, `/offices` and `/org-member-levels` do not accept an API key; use the endpoints above from an integration.

#### Fixed-enum columns (no endpoint needed) <a href="#fixed-enum-columns-no-endpoint-needed" id="fixed-enum-columns-no-endpoint-needed"></a>

The following columns accept a small fixed set of values that doesn't vary per org. The accepted values are listed directly in the [Column reference](#column-reference) and reproduced here for convenience:

| Column               | Accepted values                                                                                        |
| -------------------- | ------------------------------------------------------------------------------------------------------ |
| **Role**             | `ADMIN`, `MEMBER` (case-sensitive). Defaults to `MEMBER` on new rows when blank.                       |
| **Work Arrangement** | `REMOTE`, `HYBRID`, `IN_PERSON` (case-sensitive).                                                      |
| **Use MFA**          | `true`, `t`, `1`, `yes`, `y`, `false`, `f`, `0`, `no`, `n` (case-insensitive).                         |
| FLSA Status          | `Exempt`, `Non-Exempt`, `Not Applicable`, `EXEMPT`, `NON_EXEMPT`, `NOT_APPLICABLE` (Performance only). |

### Cross-row rules <a href="#cross-row-rules" id="cross-row-rules"></a>

* **Duplicate Email across rows** → `DUPLICATE_VALUE` on every involved row (case-insensitive comparison).
* **Duplicate Employee ID across rows** → `DUPLICATE_VALUE` on every involved row (case-insensitive comparison). Empty Employee IDs are not considered duplicates of each other.

### Recommended workflow <a href="#recommended-workflow" id="recommended-workflow"></a>

There is no separate "validate" endpoint — `/members/import-csv` performs validation and the write in a single transaction:

1. Build the CSV. To get a template tailored to your org (with valid office locations, SSO id format, etc.), `GET /members/example-csv/{product}/{numRows}`.
2. `POST /members/import-csv?product={Product}` with the file.
3. On `200 OK`, parse `createdCount` and `updatedCount` from the response body.
4. On `400 Bad Request`, parse the validation result body to determine whether the failure was file-level (`fileError`) or row-level (`rowColumnErrors`). Fix and retry; the call is rejected as a whole, so partial state is never written.

### Update semantics <a href="#update-semantics" id="update-semantics"></a>

Members are matched by **Email** (case-insensitive). A row with an Email that matches an existing member in your org becomes an **update**; otherwise it becomes a **create**.

#### Updates: present-column rule <a href="#updates-present-column-rule" id="updates-present-column-rule"></a>

For an existing member, the *presence of a column header* in your file controls whether that field gets touched:

| Situation                                     | Effect on the existing field                        |
| --------------------------------------------- | --------------------------------------------------- |
| Column header **absent** from the CSV         | Existing value is **preserved**.                    |
| Column header **present**, cell **non-blank** | Existing value is **replaced** with the cell value. |
| Column header **present**, cell **blank**     | Existing value is **cleared**.                      |

This lets you do precise partial updates: include only the columns you want to change.

**Exceptions and special cases:**

* **First Name, Last Name, Email** are always required regardless. Their headers must be present and their cells non-blank on every row.
* **Office City / Office State / Office Country** are treated as a single unit. If none of the three column headers are present, the existing office location is preserved. If any one of them is present, all three are taken from the CSV (with the usual triad rules).
* **Level, Graduation Year, Effective Class Year, FLSA Status, Manager Email, Mentor Emails** are removed from the present-columns set on non-Performance imports — even if you include those headers, the columns will be treated as absent for update purposes (preserved, not cleared).
* **SSO ID** and **Use MFA** are also context-merged before SSO/MFA validation runs — if only one of the two columns is present, the absent column's value is taken from the existing user record before validation, so you can update one without restating the other.

#### Education writes (Law School, Graduation Year) <a href="#education-writes-law-school-graduation-year" id="education-writes-law-school-graduation-year"></a>

Education-background writes on existing members are **create-only**: if the member already has any education record, additional ones are skipped. Use the dedicated profile-edit flows to modify or replace existing education records — the CSV will not overwrite them.

#### Creates <a href="#creates" id="creates"></a>

For new members, every required field on the row must pass validation. The default Role is `MEMBER` if Role is blank or absent. Welcome-email side effects fire per row.

### Updating a member after creation <a href="#updating-a-member-after-creation" id="updating-a-member-after-creation"></a>

There is no separate "update" endpoint for individual members on the REST API — updates are performed by submitting CSV rows whose **Email** matches an existing member. The same `POST /members/import-csv` endpoint handles both create and update; the [Update semantics](#update-semantics) section above describes the underlying rules. This section shows how to apply them in practice.

#### The general recipe <a href="#the-general-recipe" id="the-general-recipe"></a>

1. Build a CSV containing **only the columns whose values you want to change**, plus the three always-required columns (`First Name`, `Last Name`, `Email`).
2. Include one row per member to update. Match by **Email** (case-insensitive).
3. `POST /members/import-csv?product={Product}` with the file.
4. On `200 OK`, `updatedCount` reflects how many existing members were touched. Any row whose email did not match an existing member is created instead and counts toward `createdCount`.

Remember: a column **header** present with a **blank** cell is interpreted as "clear this field," while an absent header is "preserve this field." This is the single most common source of accidental data loss — be deliberate about which columns you include in your update file.

#### Recipe 1: change one or two fields, leave the rest untouched <a href="#recipe-1-change-one-or-two-fields-leave-the-rest-untouched" id="recipe-1-change-one-or-two-fields-leave-the-rest-untouched"></a>

To update only the job title and work arrangement for an existing member, include exactly those columns alongside the required identifiers:

```csv
First Name,Last Name,Email,Job Title,Work Arrangement
Jane,Smith,jane.smith@firm.com,Senior Associate,HYBRID
```

Everything else — office location, department, practice area, law school, employee ID, levels, dates, role, SSO settings — is preserved because those columns are absent from the file.

#### Recipe 2: clear a field <a href="#recipe-2-clear-a-field" id="recipe-2-clear-a-field"></a>

Include the column header but leave the cell empty. To remove a member's bio link:

```csv
First Name,Last Name,Email,Bio Link
Jane,Smith,jane.smith@firm.com,
```

The bio link is set to empty on the existing record. All other fields are preserved.

#### Recipe 3: move a member to a new office <a href="#recipe-3-move-a-member-to-a-new-office" id="recipe-3-move-a-member-to-a-new-office"></a>

The office triad (`Office City`, `Office State (US Only)`, `Office Country (Non-US Only)`) is treated as a unit. Include all three columns to be explicit about the new location:

```csv
First Name,Last Name,Email,Office City,Office State (US Only),Office Country (Non-US Only)
Jane,Smith,jane.smith@firm.com,London,,United Kingdom
```

Omit all three columns to preserve the existing office.

#### Recipe 4: promote a member to admin (or demote) <a href="#recipe-4-promote-a-member-to-admin-or-demote" id="recipe-4-promote-a-member-to-admin-or-demote"></a>

Include the `Role` column. The role applies to the product the upload is targeted at (`?product=…`).

```csv
First Name,Last Name,Email,Role
Jane,Smith,jane.smith@firm.com,ADMIN
```

#### Recipe 5: grant an existing member access to an additional product <a href="#recipe-5-grant-an-existing-member-access-to-an-additional-product" id="recipe-5-grant-an-existing-member-access-to-an-additional-product"></a>

Submit the CSV against the **new** product. The import treats a row whose email matches an existing member but who doesn't yet have the target product role as a "grant product access" operation. A welcome email is sent for the newly-granted product.

```bash
curl -X POST 'https://api.florecruit.com/v1/members/import-csv?product=PERFORM' \
  -H 'Authorization: Bearer <your API key>' \
  -F 'file=@grant-perform.csv'
```

```csv
First Name,Last Name,Email
Jane,Smith,jane.smith@firm.com
```

#### Things to be careful about <a href="#things-to-be-careful-about" id="things-to-be-careful-about"></a>

* Match is by the Email column. If your records use a member's old email and the email on file has changed, you'll create a new member instead of updating the old one. To change a member's email, add the New Email column: on a row whose Email matches an existing member, New Email moves that member to the new address. This column only takes effect when the bulk email-update feature is enabled for your org — contact your Flo representative to have it enabled. The editEmployerMemberInfo GraphQL path described below is the per-member alternative.
* **Education records are create-only.** Setting `Law School` and `Graduation Year` on a re-upload will not overwrite existing education records. To change a member's law school after creation, contact Flo support.
* **Performance-only columns are silently ignored on non-Performance uploads.** `Level`, `Graduation Year`, `Effective Class Year`, `FLSA Status`, `Manager Email`, and `Mentor Emails` are dropped at parse time when the request specifies a non-Performance product. To update those, target `product=PERFORM`.
* **Welcome emails fire when a member is granted a new product role.** If your re-upload is granting access to a previously-untouched product, expect notification side-effects (Recipe 5). If it's purely a field-update on a product the member already has, no email fires.
* **There is no separate dry-run mode.** Plan your column selection before submitting — the change is committed when the request succeeds. If your integration is risk-averse, send a single-row file first for a representative member, verify the result with a `memberById` query (GraphQL) or by visual inspection, then submit the rest in batch.

#### Alternative: GraphQL mutations for per-member updates <a href="#alternative-graphql-mutations-for-per-member-updates" id="alternative-graphql-mutations-for-per-member-updates"></a>

For integrations that need finer-grained control (single-member updates, partial updates without constructing a CSV, post-create email changes, deletions) the v2 GraphQL endpoint at `POST /graphql` exposes the following mutations:

| Mutation                           | What it does                                                                                                                                                                                      |
| ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `editEmployerMemberInfo`           | Update first/last name, employment (office, department, practice area, level, start date, effective class year), employee ID, bio link, law school, graduation year, work arrangement, job title. |
| `editEmployerMemberAuthInfo`       | Update product roles (ADMIN ↔ MEMBER), SSO/MFA settings.                                                                                                                                          |
| `editUniversityMemberInfo`         | University-side counterpart: update first/last name.                                                                                                                                              |
| `addEmployerMemberProductUserRole` | Grant an existing member access to an additional product (per-member equivalent of CSV Recipe 5).                                                                                                 |
| `revokeProductUserAccess`          | Remove a member's access to a product.                                                                                                                                                            |
| `deleteMember`                     | Delete a member entirely.                                                                                                                                                                         |

Each mutation takes a member `id` (the GraphQL `ID` returned at creation, or queryable via the `memberById` / `membersByProduct` queries). Authentication is the same as the CSV endpoint. Full request/response shapes are in the GraphQL schema at `member.schema.graphql`; the OpenAPI spec covers the REST surface area only. Reach out to your Flo contact if you need a GraphQL onboarding guide.

### Error response shape <a href="#error-response-shape" id="error-response-shape"></a>

`/members/import-csv` returns `400 Bad Request` with this JSON body on any validation failure:

```json
{
  "fileError": null,
  "rowColumnErrors": [
    {
      "rowNumber": 2,
      "columnName": "Email",
      "value": "jane@firm.com",
      "type": "DUPLICATE_VALUE",
      "message": "Duplicate value: jane@firm.com found in rows [2, 5]"
    }
  ]
}
```

Exactly one of `fileError` or `rowColumnErrors` is populated.

#### File-level errors (`fileError.type`) <a href="#file-level-errors-fileerrortype" id="file-level-errors-fileerrortype"></a>

| Type                       | Meaning                                                                       |
| -------------------------- | ----------------------------------------------------------------------------- |
| `EMPTY_FILE`               | The file is missing or empty.                                                 |
| `FILE_SIZE_EXCEEDED`       | The file is larger than 10 MB.                                                |
| `MISSING_REQUIRED_COLUMNS` | The header row is missing First Name, Last Name, or Email.                    |
| `UNEXPECTED_COLUMNS`       | The header row contains a column not in the recognized list.                  |
| `INVALID_FILE_FORMAT`      | Parse failure (malformed CSV, encoding issue, or an unexpected parser error). |

#### Row-level error types (`rowColumnErrors[].type`) <a href="#row-level-error-types-rowcolumnerrorstype" id="row-level-error-types-rowcolumnerrorstype"></a>

| Type                     | Triggers                                                                                                                                                                                                                        |
| ------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `EMPTY_REQUIRED_VALUE`   | A required field is missing, or an Office triad rule requires a value that wasn't provided.                                                                                                                                     |
| `INVALID_EMAIL`          | Email, Manager Email, or one of the addresses in Mentor Emails is not a well-formed address.                                                                                                                                    |
| `INVALID_FORMAT`         | First/Last Name contains a disallowed special character, **or** Use MFA isn't one of the accepted boolean strings, **or** Mentor Emails names more than 50 distinct addresses.                                                  |
| `INVALID_URL`            | Bio Link is not a syntactically valid URL.                                                                                                                                                                                      |
| `INVALID_YEAR`           | Graduation Year / Effective Class Year is not 4 digits or is more than 200 years from the current year.                                                                                                                         |
| `INVALID_DATE_FORMAT`    | Start Date isn't in `yyyy-MM-dd`.                                                                                                                                                                                               |
| `DUPLICATE_VALUE`        | Email or Employee ID appears on two or more rows, or two rows set the same New Email. The error message lists the colliding row numbers.                                                                                        |
| `INVALID_LIST_SELECTION` | A list field (Office Location, Practice Area, Law School, Department, FLSA Status, or Level) doesn't match a known value for your org, or a Manager Email / Mentor Emails address matches no member in your org or in the file. |
| `INVALID_SSO_ID`         | SSO ID failed your org's SSO validation rules.                                                                                                                                                                                  |
| `ROW_VALUE_CONFLICT`     | The Office triad on this row is internally inconsistent, the row names itself as its own manager or mentor, or New Email is set on a row matching no existing member or targets another row's Email.                            |
| `EXISTING_USER_CONFLICT` | A user conflict reported by the create path (e.g. an existing user in a different org), or a New Email address that already belongs to another user or employee in your org.                                                    |
| `NOT_PERMITTED`          | The request used an API key, and the row would grant or remove the admin role, or change an administrator's email.                                                                                                              |
| `UNKNOWN`                | An unmapped exception from the create/update path. Inspect the `message` field.                                                                                                                                                 |

### Success response <a href="#success-response" id="success-response"></a>

`200 OK` with:

```json
{ "createdCount": 5, "updatedCount": 3, "absentMembers": [ { "email": "sam.lee@firm.com", "firstName": "Sam", "lastName": "Lee" } ] }
```

createdCount is the number of new members created. updatedCount is the number of existing members updated. absentMembers lists every non-admin member who already has access to this product but did not appear in the uploaded CSV — an import never removes anyone, so use this list to decide who to pass to DELETE /members/bulk-remove if you want the upload to be authoritative. It is an empty array when the CSV covered everyone.

### Sample CSV <a href="#sample-csv" id="sample-csv"></a>

A minimal valid file using only the required columns:

```csv
First Name,Last Name,Email
Jane,Smith,jane.smith@firm.com
John,Doe,john.doe@firm.com
```

A fuller file targeting `product=PERFORM`:

```csv
Employee ID,First Name,Last Name,Email,Job Title,Level,Office City,Office State (US Only),Office Country (Non-US Only),Department,Practice Area,Law School,Graduation Year,Effective Class Year,Start Date,Role,SSO ID,Use MFA,Bio Link,Work Arrangement,Manager Email,Mentor Emails
E-1042,Jane,Smith,jane.smith@firm.com,Senior Associate,Senior,New York,NY,,Litigation,Corporate,Columbia Law School,2018,2020,2024-06-03,MEMBER,jsmith,true,https://firm.com/bio/jsmith,HYBRID,john.doe@firm.com,
E-1043,John,Doe,john.doe@firm.com,Partner,Partner,,,United Kingdom,Corporate,M&A,Yale Law School,2010,2012,2014-09-01,ADMIN,jdoe,true,,IN_PERSON,,jane.smith@firm.com
```

The second row demonstrates a non-US office (Office Country set, Office State empty) and an empty Bio Link. The reference columns show a manager and no mentors on the first row, and no manager and a single mentor on the second.

### Example: curl <a href="#example-curl" id="example-curl"></a>

Download a 5-row template for the Recruit product. The template download takes an administrator session, not an API key:

```bash
curl -X GET 'https://florecruit.com/api/v2/members/example-csv/RECRUIT/5' \
  -b 'FLOAUTH=<your session token>' \
  -o template.csv
```

Import with your API key. With an administrator session instead, replace the `Authorization` line with `-b 'FLOAUTH=<your session token>'`:

```bash
curl -X POST 'https://api.florecruit.com/v1/members/import-csv?product=PERFORM' \
  -H 'Authorization: Bearer <your API key>' \
  -F 'file=@members.csv'
```

### Common pitfalls <a href="#common-pitfalls" id="common-pitfalls"></a>

| Symptom                                                                             | Likely cause                                                                                                                                                                                                              |
| ----------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `UNEXPECTED_COLUMNS` rejection                                                      | A header was spelled differently, has a typo, or includes a column from a different system. The match is case-insensitive but otherwise exact — `Hire Date` will be rejected because `Start Date` is the recognized name. |
| `MISSING_REQUIRED_COLUMNS` rejection                                                | One of First Name / Last Name / Email is not in the header row.                                                                                                                                                           |
| Existing member's field unexpectedly **cleared** to blank                           | Your CSV included that column header with a blank cell. To preserve a field on an update, omit its column header from the file entirely.                                                                                  |
| Existing member's field unexpectedly **unchanged**                                  | The reverse: you set a non-blank value but the column header was missing from your file.                                                                                                                                  |
| All Office fields flagged                                                           | The Office triad rule was violated — see [Office location rules](#office-location-rules).                                                                                                                                 |
| Level / Graduation Year / FLSA Status / Manager Email / Mentor Emails not persisted | `product` was not `PERFORM`. These columns are silently ignored on non-Performance imports.                                                                                                                               |
| Law School / Graduation Year not applied to an existing member                      | Education writes are create-only — once a member has any education record, the CSV will not overwrite it.                                                                                                                 |
| `DUPLICATE_VALUE` on Employee ID across rows you thought were distinct              | Comparison is case-insensitive — `E-1042` and `e-1042` collide.                                                                                                                                                           |
| `INVALID_LIST_SELECTION` on a value that exists in your UI                          | The list match is case-insensitive but otherwise exact and trims surrounding whitespace. Embedded extra whitespace (`"New York"`) will not match `"New York"`.                                                            |
| `INVALID_FORMAT` on a Name field                                                    | First or Last Name contained one of the disallowed characters: `\`, `<`, `>`, \`                                                                                                                                          |
| Members in the file aren't reflected as updates                                     | Match is by Email (case-insensitive). If the CSV email differs from what's on file in any way other than case (extra dots, plus addressing, alias), the row becomes a create attempt, not an update.                      |

<br>
