Import a File

post/datamart.importfile/{slotId}/{typedId}

Uploads a file to the Data Manager (specified by typeId in the path parameter).

Follow these steps to upload a file:

  1. Create an upload slot and retrieve the slotId using the /uploadmanager.newuploadslot endpoint (see Product Image > 1. Create an Upload Slot).
  2. Upload the file using the /datamart.importfile/{slotId}/{typedId} endpoint.

When importing a CSV file, it is possible to include more information than just a column name.
Example:

columName1:NUMBER:KEY,columnName2:TEXT:DIM,columnName3:NUMBER
a,1,0.5
b,1,0.6
c,2,1.2
d,3,2.0

In the example above you can see that columnName1 column should be the NUMBER field type and also the key (KEY).
The columnName2 column should be the TEXT type and a dimension (DIM).
The columnName3 column should be a NUMBER.
Possible field types: BOOLEAN, CURRENCY, DATE, DATETIME, INTEGER, LOB, MONEY, NUMBER, QUANTITY, TEXT, UOM

Information: When using datamart.importfile to upload a file with huge numbers (20+ significant decimal digits) it is recommended to use the Avro format. In CSV and XLSX files, you can use numbers within the double type or long type ranges.

Securitybasic or X-PriceFx-jwt
Request
path Parameters
slotId
required
string

The id of the slot. Create the slot and retrieve the id using the /uploadmanager.newuploadslot endpoint.

typedId
required
string

The typedId of the Data Manager entity.

Example: 2147483847.DMDS
Responses
200

OK

Request samples