table-imports

Upload a CSV or Excel file and preview the table it would create

Upload a .csv or .xlsx file. The response carries one suggested column per field (a name taken from the header row and a type every sampled value fits) plus a few raw rows so the user can judge those guesses.

NOTHING is created here: no table, no columns, no rows. Review the mapping, edit it, and POST it to the commit endpoint to build the table.

The format is decided by the file's own first bytes, not by its name or its declared content type, both of which are client-supplied. A workbook is read one sheet at a time: sheet_names lists the rest and the sheet endpoint re-reads the same upload from another one.

Rejects a file that is too large or too wide, so an import that cannot succeed fails before it costs a table name. A file with more rows than the plan allows is NOT rejected: importable_row_count comes back below estimated_row_count and the import takes the file's first rows.

post/table-imports/preview/

Request

  • Base URL: https://api.getoneprofile.ai (the document declares no server; this is the origin it was published from)
  • URL: https://api.getoneprofile.ai/table-imports/preview/
  • Auth: one of:
    • API key in header X-API-Key
    • HTTP bearer

Response

Successful Response

estimated_row_countinteger required

Data rows in the file, excluding the header.

import_idstring uuid required

Identifies this upload through commit and polling.

importable_row_countinteger required

How many of those rows the import will write, once the cap is applied.

row_limitinteger required

Rows one table may hold on this organisation's plan.

selected_sheetstring nullable

Which sheet these columns were read from. Null for a CSV. POST it to the sheet endpoint to re-read the same upload from a different one.

sheet_namesstring[]

Every sheet the uploaded workbook offers, in tab order. Empty for a CSV, which has no sheets. That is what says not to offer a sheet picker.

warningsstring[] required

Non-fatal things the user should see.

Changes

No recorded changes to this operation across all 1 revision of this API.