Create a table from a CSV
POSThttps://platform.docana.com/api/v1/tables/import/
Create a table with managed record storage from a CSV and import every row in the same request. Call previewTableFromCsv first to see the proposed columns, types and key, then pass only what you want to change in columns (by the label from the preview: a new name, a type, or skip) and keyColumn when the proposed key is wrong or missing. Types are text unless every value is a number without a leading zero, a YYYY-MM-DD date or true/false, so codes like an NCM 01012100 keep their leading zero; the key column is text unless you change it. Each row’s externalKey is its key column value and must be unique in the file. Values follow the same rules as importTableRows, nothing is classified, and the import is upsert. If any write fails no table is created. Up to 20,000 rows and 8 MB of CSV. Omit applicationId for a personal table; an application table needs membership of the application, the same as createTable.
Request
Responses
- 201
- 400
- 401
- 403
- 413
- 500
The created table, its columns and the import counts
Unknown or repeated columns, no usable key, or keys repeated in the file
The API key or session is missing, expired, or malformed.
The caller is authenticated but not allowed to perform this operation.
More than 20,000 rows or 8 MB of CSV
Unexpected server error.