PUT api/v1/datasources/file/{DataSourceId}

Upload data source file

Request Information

URI Parameters

NameDescriptionTypeAdditional information
DataSourceId

Data source Id

universally unique identifier

Required

Body Parameters

request

UploadDataSourceV1Request
NameDescriptionTypeAdditional information
File

File to upload. The file must be an xslx file containing one work sheet. The first row must contain the names of the columns. The column named Id is optional, it will be added if not present, and must contain unique values. The names of columns may only contain: a-z, A-Z, and 0-9. The Id values may only contain: a-z, A-Z, 0-9, and the character '-'. The records in the datasource will be text sorted by Id value.

File

Allowed file types xlsx.

Maximum file name length 100 characters.

Maximum file size 50 MB (52,428,800 bytes).

Request Formats

multipart/form-data

Sample:
--42745bc1-04b2-4f59-9a55-25f0c3c00ad4
Content-Disposition: form-data; filename="projects.xlsx"; name="File"
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Id ProjectId CustomerId Name
1  38        8          Building 21
2  102       17         Channel Tunnel
3  57        42         Euro Gate
4  86        32         The New Holland Bridge
--42745bc1-04b2-4f59-9a55-25f0c3c00ad4--

Response Information

Resource Description

Upload data source file

UploadDataSourceV1Response
NameDescriptionTypeAdditional information
Algorithm

Algorithm

FileV1HashAlgorithm

Example value: SHA512

Hash

Hash

Collection of byte

Example value: 59, 177, 46, 218, 60, 41, 141, 181, 222, 37, 89, 127, 84, 217, 36, 242, 225, 126, 120, 162, 106, 216, 149, 62, 216, 33, 142, 230, 130, 240, 187, 190, 144, 33, 226, 243, 0, 157, 21, 44, 145, 27, 241, 242, 94, 198, 131, 169, 2, 113, 65, 102, 118, 122, 251, 216, 229, 189, 15, 176, 18, 78, 203, 138

Size

Size

integer (64 bits)

Required

Example value: 7

Response Formats

application/json

Sample:
{
  "Algorithm": "SHA512",
  "Hash": "O7Eu2jwpjbXeJVl/VNkk8uF+eKJq2JU+2CGO5oLwu76QIeLzAJ0VLJEb8fJexoOpAnFBZnZ6+9jlvQ+wEk7Lig==",
  "Size": 7
}