invantive documentation
Invantive Support ForumsLog In / Sign Up

PropertyAssets: Bouw7 Property Assets

read only REST

  • Catalog: Bouw7
  • Schema: PropertyAsset
  • Label: Property Assets

Returns a list of property assets associated with the organization. Returns a list of property assets associated with the organization.

Can only retrieve data.

Summary

Returns a list of property assets associated with the organization.

API Source

  • Endpoint: /list/property-assets
  • Operation: get /list/property-assets

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 102,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
q `` A Heimdall Query Language string

Table Columns

The columns of the table PropertyAssets 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
caCaObjectMedewerker varchar2 CA Object Medewerker filters on the platform, writable, caCaObjectMedewerker
city varchar2 City filters on the platform, writable, city The city of this property asset.
country varchar2 Country filters on the platform, writable, country The country code of this property asset.
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username The username of the user.
description varchar2 Description filters on the platform, writable, description The description of this property asset.
firstDeliveryDate datetime First Delivery Date filters on the platform, writable, firstDeliveryDate The initial delivery date of this property asset, in ATOM/ISO-8601 format.
houseNumber varchar2 House Number filters on the platform, writable, houseNumber The house/building number of the address of this property asset.
id int64 ID filters on the platform, writable, id The ID of this property asset.
invoiceRecipient_emailAddress varchar2 Invoice Recipient Email Address filters on the platform, writable, invoiceRecipient.emailAddress The email address of the contact.
invoiceRecipient_id int64 Invoice Recipient ID filters on the platform, writable, invoiceRecipient.id The ID of the contact.
invoiceRecipient_name varchar2 Invoice Recipient Name filters on the platform, writable, invoiceRecipient.name The name of this contact.
invoiceRecipient_type varchar2 Invoice Recipient Type filters on the platform, writable, invoiceRecipient.type The type of this contact.
invoiceRecipient_typeId int64 Invoice Recipient Type ID filters on the platform, writable, invoiceRecipient.typeId The type ID of this contact.
name varchar2 Name filters on the platform, writable, name Name of this property asset.
number varchar2 Number filters on the platform, writable, number The identification number of this property asset.
project_branchId int64 Project Branch ID filters on the platform, writable, project.branchId The ID of the branch of this project.
project_categoryId int64 Project Category ID filters on the platform, writable, project.categoryId The ID of the category of this project.
project_divisionId int64 Project Division ID filters on the platform, writable, project.divisionId The ID of the division of this project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_name varchar2 Project Name filters on the platform, writable, project.name The name of the project.
project_number varchar2 Project Number filters on the platform, writable, project.number The number of the project.
project_status varchar2 Project Status filters on the platform, writable, project.status The name of the current status of this project.
project_statusId int64 Project Status ID filters on the platform, writable, project.statusId The ID of the status of this project.
resident_emailAddress varchar2 Resident Email Address filters on the platform, writable, resident.emailAddress The email address of the contact.
resident_id int64 Resident ID filters on the platform, writable, resident.id The ID of the contact.
resident_name varchar2 Resident Name filters on the platform, writable, resident.name The name of this contact.
resident_type varchar2 Resident Type filters on the platform, writable, resident.type The type of this contact.
resident_typeId int64 Resident Type ID filters on the platform, writable, resident.typeId The type ID of this contact.
secondDeliveryDate datetime Second Delivery Date filters on the platform, writable, secondDeliveryDate The second delivery date of this property asset, in ATOM/ISO-8601 format.
streetName varchar2 Street Name filters on the platform, writable, streetName The street name of the address of this property asset.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.
zipCode varchar2 ZIP Code filters on the platform, writable, zipCode The postal/zip cide of the address of this property asset.

Release Notes

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