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

Upload data source file

Request Information

URI Parameters

Name	Description	Type	Additional information
DataSourceId	Data source Id	universally unique identifier	Required

Body Parameters

request

UploadDataSourceV1Request

Name	Description	Type	Additional 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).

Name

Description

Type

Additional 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:

--cfbb9964-0d95-4b0f-8c3e-b0699a39fe09
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
--cfbb9964-0d95-4b0f-8c3e-b0699a39fe09--

Response Information

Resource Description

Upload data source file

UploadDataSourceV1Response

Name	Description	Type	Additional 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

Name

Description

Type

Additional information

Algorithm

FileV1HashAlgorithm

Example value: SHA512

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

integer (64 bits)

Required

Example value: 7

Response Formats

application/json

Sample:

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