Supported Fields for the Files Table
The following table provides the supported fields for the Files table:
Column Name | Column Type | Description | Example |
|---|---|---|---|
id | bigint | A server-generated ID for the object. | 454501654069443 |
externalId | varchar | The external ID provided by the client. Must be unique for the resource type. | extId |
name | varchar | Name of the file. | fileNameAbc |
directory | varchar | Directory containing the file. Must be an absolute, unix-style path. | /home/user/documents |
source | varchar | The source of the file. | FTDM |
mimetype | varchar | File type. For example: text/plain, application/pdf, and so on. | image/jpeg |
dataSetId | bigint | The dataset ID for the item. | 543000056769245 |
sourceCreatedTime | timestamp | The timestamp for when the file was originally created in the source system, specified in milliseconds since the epoch. | 2024-12-04 09:48:11.929 |
sourceModifiedTime | timestamp | The timestamp for when the file was last modified in the source system, specified in milliseconds since the epoch. | 2024-12-04 09:48:11.929 |
uploaded | bool | Whether the actual file is uploaded or not, this field is returned only by the API and has no effect in a post body. | true |
uploadedTime | timestamp | The number of milliseconds since 00:00:00 Thursday, 1 January 1970, Coordinated Universal Time (UTC), minus leap seconds. | 2024-12-04 09:48:11.929 |
createdTime | timestamp | The number of milliseconds since 00:00:00 Thursday, 1 January 1970, Coordinated Universal Time (UTC), minus leap seconds. | 2024-12-04 09:48:11.929 |
lastUpdatedTime | timestamp | The number of milliseconds since 00:00:00 Thursday, 1 January 1970, Coordinated Universal Time (UTC), minus leap seconds. | 2024-12-04 09:48:11.929 |
Provide Feedback