FilesBySubcontractorContract: Bouw7 Files by Sub-contractor Contract
read only REST
- Catalog:
Bouw7 - Schema:
Contract - Label: Files by Sub-contractor Contract
Returns a collection of subcontractor contract files with the given ID. Returns a collection of subcontractor contract files.
Can only retrieve data.
Summary
Returns a collection of subcontractor contract files.
API Source
- Endpoint:
/contracts/subcontractor/files/{id} - Operation:
get /contracts/subcontractor/files/{id}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | Subcontractor contract ID |
Table Columns
The columns of the table FilesBySubcontractorContract are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
extension |
varchar2 |
Extension | filters on the platform, writable, extension |
The extension of the file. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this file | |
model |
int64 |
Model ID | filters on the platform, writable, model |
The ID of the associated type. | |
model |
varchar2 |
Model Type | filters on the platform, writable, model |
The category of the file. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The public name of the file. | |
secure |
varchar2 |
itgen_bouw7_securehash | filters on the platform, writable, secure |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
size |
int64 |
Size | filters on the platform, writable, size |
The size of the file in bytes. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. | |
uri |
varchar2 |
URI | filters on the platform, writable, uri |
The URI of the file, used to fetch the contents. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: