invantive documentation
Invantive Support ForumsLog In / Sign Up

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
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy 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
modelId int64 Model ID filters on the platform, writable, modelId The ID of the associated type.
modelType varchar2 Model Type filters on the platform, writable, modelType The category of the file.
name varchar2 Name filters on the platform, writable, name The public name of the file.
secureHash varchar2 itgen_bouw7_securehash filters on the platform, writable, secureHash 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.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy 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: