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

KeyDatatypeRequiredDescription
Content-Typestring
Acceptstring

RESPONSES

status: OK

{&quot;duplicateRows&quot;:&quot;\u003cinteger\u003e&quot;,&quot;errors&quot;:[{&quot;category&quot;:&quot;\u003cstring\u003e&quot;,&quot;correlationId&quot;:&quot;\u003cuuid\u003e&quot;,&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;subCategory&quot;:&quot;\u003cstring\u003e&quot;,&quot;errors&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;in&quot;:&quot;\u003cstring\u003e&quot;,&quot;code&quot;:&quot;\u003cstring\u003e&quot;,&quot;subCategory&quot;:&quot;\u003cstring\u003e&quot;,&quot;context&quot;:{&quot;cupidatatc&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;in&quot;:&quot;\u003cstring\u003e&quot;,&quot;code&quot;:&quot;\u003cstring\u003e&quot;,&quot;subCategory&quot;:&quot;\u003cstring\u003e&quot;,&quot;context&quot;:{&quot;laborum_42&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;ullamco_478&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;aliqua__d&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;minimf&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}}],&quot;context&quot;:{&quot;in_736&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;adipisicingf5&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},&quot;links&quot;:{&quot;enim1f&quot;:&quot;\u003cstring\u003e&quot;,&quot;anim6d&quot;:&quot;\u003cstring\u003e&quot;}},{&quot;category&quot;:&quot;\u003cstring\u003e&quot;,&quot;correlationId&quot;:&quot;\u003cuuid\u003e&quot;,&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;subCategory&quot;:&quot;\u003cstring\u003e&quot;,&quot;errors&quot;:[{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;in&quot;:&quot;\u003cstring\u003e&quot;,&quot;code&quot;:&quot;\u003cstring\u003e&quot;,&quot;subCategory&quot;:&quot;\u003cstring\u003e&quot;,&quot;context&quot;:{&quot;Lorem_9&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}},{&quot;message&quot;:&quot;\u003cstring\u003e&quot;,&quot;in&quot;:&quot;\u003cstring\u003e&quot;,&quot;code&quot;:&quot;\u003cstring\u003e&quot;,&quot;subCategory&quot;:&quot;\u003cstring\u003e&quot;,&quot;context&quot;:{&quot;Duis94&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;magna_bc&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;labore08a&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]}}],&quot;context&quot;:{&quot;est4d4&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;ipsum_1&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;],&quot;cillume&quot;:[&quot;\u003cstring\u003e&quot;,&quot;\u003cstring\u003e&quot;]},&quot;links&quot;:{&quot;Excepteur_ff&quot;:&quot;\u003cstring\u003e&quot;}}],&quot;rowLimitExceeded&quot;:&quot;\u003cboolean\u003e&quot;,&quot;rowsImported&quot;:&quot;\u003cinteger\u003e&quot;}