invantive documentation
Invantive Support ForumsLog In / Sign Up

ResourceUnitsById: Bouw7 Resource Units by ID

read only REST

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

Returns a resource associated with the given id. Returns a resource associated with the given id.

Can only retrieve data.

Summary

Returns a resource associated with the given id.

API Source

  • Endpoint: /resource/{type}/{id}
  • Operation: get /resource/{type}/{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 `` Resource ID
type `` The type of resource

Table Columns

The columns of the table ResourceUnitsById 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, ::ancestor.code The code of the resource.
description varchar2 Description filters on the platform, writable, ::ancestor.description The description of the resource.
group_createdAt datetime Group Created at filters on the platform, writable, ::ancestor.group.createdAt The creation time of the entity.
group_createdBy varchar2 Group Created by filters on the platform, writable, ::ancestor.group.createdBy The user that created the entity.
group_id int64 Group ID filters on the platform, writable, ::ancestor.group.id The unique identifier of the group.
group_name varchar2 Group Name filters on the platform, writable, ::ancestor.group.name The name of the group.
group_type varchar2 Group Type filters on the platform, writable, ::ancestor.group.type The resource type, possible values: equipment.
group_updatedAt datetime Group Updated at filters on the platform, writable, ::ancestor.group.updatedAt The last updated time of the entity.
group_updatedBy varchar2 Group Updated by filters on the platform, writable, ::ancestor.group.updatedBy The user that last updated the entity.
id int64 ID writable, id The unique identifier of the resource per unit.
id_2 int64 ID filters on the platform, writable, ::ancestor.id The unique identifier of the resource.
inspectionDate datetime Inspection Date filters on the platform, writable, ::ancestor.inspectionDate The inspection date of the resource.
isActive char Is Active writable, isActive The active state of the resource per unit.
isActive_2 char itgen_bouw7_isactive_2 filters on the platform, writable, ::ancestor.isActive The active state of the resource.
lastModified varchar2 Last Modified writable, lastModified The last updated time of the resource per unit.
lastModified_2 varchar2 itgen_bouw7_lastmodified_2 filters on the platform, writable, ::ancestor.lastModified The last update time of the resource.
name varchar2 Name filters on the platform, writable, ::ancestor.name The name of the resource.
price varchar2 Price writable, price The price of the resource per unit.
resourceName varchar2 Resource Name writable, resourceName The name of the resource.
resourceUnitId int64 Resource Unit ID writable, resourceUnitId The ID of the resource unit.
resourceUnitName varchar2 Resource Unit Name writable, resourceUnitName The name of the resource unit.
sellingPrice varchar2 Selling Price writable, sellingPrice The selling price of the resource per unit.
type varchar2 Type writable, type The resource type, possible values: equipment.
type_2 varchar2 itgen_bouw7_type_2 filters on the platform, writable, ::ancestor.type Resource type, possible values: equipment.

Release Notes

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