invantive documentation
Invantive Support ForumsLog In / Sign Up

EquipmentById: Bouw7 Equipment by ID

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: Equipment by ID

Returns a single equipment item based on the given ID. Returns a single equipment item based on the given ID.

Can only retrieve data.

Summary

Returns a single equipment item based on the given ID.

API Source

  • Endpoint: /equipment/{equipment}
  • Operation: get /equipment/{equipment}

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
equipment ``

Table Columns

The columns of the table EquipmentById 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
code varchar2 Code filters on the platform, writable, code The code of the equipment.
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.
description varchar2 Description filters on the platform, writable, description Description of this equipment.
group_createdAt datetime Group Created at filters on the platform, writable, group.createdAt The creation time of the entity.
group_createdBy varchar2 Group Created by filters on the platform, writable, group.createdBy The user that created the entity.
group_id int64 Group ID filters on the platform, writable, group.id ID of the equipment group.
group_name varchar2 Group Name filters on the platform, writable, group.name The name of the equipment group.
group_updatedAt datetime Group Updated at filters on the platform, writable, group.updatedAt The last updated time of the entity.
group_updatedBy varchar2 Group Updated by filters on the platform, writable, group.updatedBy The user that last updated the entity.
id int64 ID filters on the platform, writable, id ID of the equipment.
inspectionDate datetime Inspection Date filters on the platform, writable, inspectionDate The inspection date of the equipment.
isActive char Is Active filters on the platform, writable, isActive The active state of the equipment.
name varchar2(255) Name filters on the platform, writable, name Name of the equipment.
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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: