Import data into draft table
POST {{baseUrl}}/cms/v3/hubdb/tables/:tableIdOrName/draft/import
Import the contents of a CSV file into an existing HubDB table. The data will always be imported into the draft
version of the table. Use /publish
endpoint to push these changes to published
version.
This endpoint takes a multi-part POST request. The first part will be a set of JSON-formatted options for the import and you can specify this with the name as config
. The second part will be the CSV file you want to import and you can specify this with the name as file
. Refer the overview section to check the details and format of the JSON-formatted options for the import.
Request Body
[{"name"=>"config", "value"=>"<string>", "datatype"=>"string"}, {"name"=>"file", "value"=>"<string>", "datatype"=>"string"}]
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
Content-Type | string | ||
Accept | string |
RESPONSES
status: OK
{"duplicateRows":"\u003cinteger\u003e","errors":[{"category":"\u003cstring\u003e","correlationId":"\u003cuuid\u003e","message":"\u003cstring\u003e","subCategory":"\u003cstring\u003e","errors":[{"message":"\u003cstring\u003e","in":"\u003cstring\u003e","code":"\u003cstring\u003e","subCategory":"\u003cstring\u003e","context":{"cupidatatc":["\u003cstring\u003e","\u003cstring\u003e"]}},{"message":"\u003cstring\u003e","in":"\u003cstring\u003e","code":"\u003cstring\u003e","subCategory":"\u003cstring\u003e","context":{"laborum_42":["\u003cstring\u003e","\u003cstring\u003e"],"ullamco_478":["\u003cstring\u003e","\u003cstring\u003e"],"aliqua__d":["\u003cstring\u003e","\u003cstring\u003e"],"minimf":["\u003cstring\u003e","\u003cstring\u003e"]}}],"context":{"in_736":["\u003cstring\u003e","\u003cstring\u003e"],"adipisicingf5":["\u003cstring\u003e","\u003cstring\u003e"]},"links":{"enim1f":"\u003cstring\u003e","anim6d":"\u003cstring\u003e"}},{"category":"\u003cstring\u003e","correlationId":"\u003cuuid\u003e","message":"\u003cstring\u003e","subCategory":"\u003cstring\u003e","errors":[{"message":"\u003cstring\u003e","in":"\u003cstring\u003e","code":"\u003cstring\u003e","subCategory":"\u003cstring\u003e","context":{"Lorem_9":["\u003cstring\u003e","\u003cstring\u003e"]}},{"message":"\u003cstring\u003e","in":"\u003cstring\u003e","code":"\u003cstring\u003e","subCategory":"\u003cstring\u003e","context":{"Duis94":["\u003cstring\u003e","\u003cstring\u003e"],"magna_bc":["\u003cstring\u003e","\u003cstring\u003e"],"labore08a":["\u003cstring\u003e","\u003cstring\u003e"]}}],"context":{"est4d4":["\u003cstring\u003e","\u003cstring\u003e"],"ipsum_1":["\u003cstring\u003e","\u003cstring\u003e"],"cillume":["\u003cstring\u003e","\u003cstring\u003e"]},"links":{"Excepteur_ff":"\u003cstring\u003e"}}],"rowLimitExceeded":"\u003cboolean\u003e","rowsImported":"\u003cinteger\u003e"}