Uploads a file to the Data Manager (specified by typeId
in the path parameter).
Follow these steps to upload a file:
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.
OK