KEkeboola
Tables

Import data into a table (synchronous, deprecated)

Imports an uploaded CSV file into an existing table and waits for the import to finish. This endpoint is deprecated; use the asynchronous POST /v2/storage/tables/{id}/import-async endpoint instead.

The CSV file must have a header row with column names, unless withoutHeaders is used. Every column already present in the table must also be present in the CSV; any CSV column not yet on the table is created automatically. The file may be compressed - a .gz, .gzip or .zip extension makes it unpacked before the import.

post/v2/storage/tables/{tableId}/import

Request

Path parameters

tableIdstring required

Table string id (e.g. in.c-main.users).

Request body multipart/form-data

datastring binary

CSV file to import. Used when "dataString" is empty, unset, or "0".

dataStringstring

Inline CSV data. Takes precedence over "data" unless it is empty or "0".

incrementalboolean

When true, the data is appended to the table instead of replacing it.

delimiterstring

Field delimiter, default ",".

enclosurestring

Field enclosure, default '"'.

escapedBystring

Escape character, default none.

columnsstring

Comma separated list of column names, used when the file has no header.

withoutHeadersboolean

When true, the first row is treated as data and the table column order is used.

Response

The import result.

transaction'null' nullable required

Always null, kept for backward compatibility.

warningsstring[] required
importedColumnsstring[] required

Columns the data was imported into.

totalRowsCountinteger required
totalDataSizeBytesinteger required
importedRowsCountinteger required

For a full load this equals totalRowsCount; for an incremental load it is the number of imported rows.

Changes

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