invantive documentation
Invantive Support ForumsLog In / Sign Up

ResourceBookingById: Bouw7 Resource Booking by ID

read only REST

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

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

Can only retrieve data.

Summary

Returns a resource booking associated with the given id.

API Source

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

Table Columns

The columns of the table ResourceBookingById 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
amount varchar2 Amount filters on the platform, writable, amount The amount of the resource booking.
comment varchar2 Comment filters on the platform, writable, comment The comment of this booking.
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.
group_id int64 Group ID filters on the platform, writable, group.id The unique identifier of the resource group.
group_name varchar2 Group Name filters on the platform, writable, group.name The name of the resource group.
id int64 ID filters on the platform, writable, id The unique identifier of the resource booking.
logDate datetime Log Date filters on the platform, writable, logDate The cost price of this booking.
price varchar2 Price filters on the platform, writable, price The price of this booking, if this is not provided, the price of the unit will be used for the booking.
priceTotal varchar2 Price Total filters on the platform, writable, priceTotal The total price of this booking.
projectSecurityLink_chapterName varchar2 Project Security Link Chapter Name filters on the platform, writable, projectSecurityLink.chapterName The name of the project security chapter.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, projectSecurityLink.id The unique identifier of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, projectSecurityLink.name The name of the project security link.
projectSecurityLink_status int64 Project Security Link Status filters on the platform, writable, projectSecurityLink.status The status of the project security link.
project_id int64 Project ID filters on the platform, writable, project.id The unique identifier of the project the resource belongs to.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project the resource belongs to.
resource_id int64 Resource ID filters on the platform, writable, resource.id The unique identifier of the resource.
resource_name varchar2 Resource Name filters on the platform, writable, resource.name The name of the resource.
sellingPrice varchar2 Selling Price filters on the platform, writable, sellingPrice The selling price of this booking.
sellingPriceTotal varchar2 Selling Price Total filters on the platform, writable, sellingPriceTotal The total selling price of this booking.
type varchar2 Type filters on the platform, writable, type Resource type, possible values: equipment.
unit_id int64 Unit ID filters on the platform, writable, unit.id The unique identifier of the resource unit.
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: