invantive documentation
Invantive Support ForumsLog In / Sign Up

ResourceEmployeesById: Bouw7 Resource Employees by ID

read only REST

  • Catalog: Bouw7
  • Schema: Resource
  • Label: Resource Employees 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 ResourceEmployeesById 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 employee.
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 filters on the platform, writable, ::ancestor.isActive The active state of the resource.
lastModified varchar2 Last Modified filters on the platform, writable, ::ancestor.lastModified The last update time of the resource.
name varchar2 Name writable, name The name of the employee.
name_2 varchar2 itgen_bouw7_name_2 filters on the platform, writable, ::ancestor.name The name of the resource.
type varchar2 Type 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: