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 |
|---|---|---|---|---|---|
ca |
varchar2 |
CA Object Medewerker | filters on the platform, writable, ca |
||
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. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
The username of the user. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The description of this property asset. | |
first |
datetime |
First Delivery Date | filters on the platform, writable, first |
The initial delivery date of this property asset, in ATOM/ISO-8601 format. | |
house |
varchar2 |
House Number | filters on the platform, writable, house |
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. | |
invoice |
varchar2 |
Invoice Recipient Email Address | filters on the platform, writable, invoice |
The email address of the contact. | |
invoice |
int64 |
Invoice Recipient ID | filters on the platform, writable, invoice |
The ID of the contact. | |
invoice |
varchar2 |
Invoice Recipient Name | filters on the platform, writable, invoice |
The name of this contact. | |
invoice |
varchar2 |
Invoice Recipient Type | filters on the platform, writable, invoice |
The type of this contact. | |
invoice |
int64 |
Invoice Recipient Type ID | filters on the platform, writable, invoice |
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_ |
int64 |
Project Branch ID | filters on the platform, writable, project. |
The ID of the branch of this project. | |
project_ |
int64 |
Project Category ID | filters on the platform, writable, project. |
The ID of the category of this project. | |
project_ |
int64 |
Project Division ID | filters on the platform, writable, project. |
The ID of the division of this project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Number | filters on the platform, writable, project. |
The number of the project. | |
project_ |
varchar2 |
Project Status | filters on the platform, writable, project. |
The name of the current status of this project. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status of this project. | |
resident_ |
varchar2 |
Resident Email Address | filters on the platform, writable, resident. |
The email address of the contact. | |
resident_ |
int64 |
Resident ID | filters on the platform, writable, resident. |
The ID of the contact. | |
resident_ |
varchar2 |
Resident Name | filters on the platform, writable, resident. |
The name of this contact. | |
resident_ |
varchar2 |
Resident Type | filters on the platform, writable, resident. |
The type of this contact. | |
resident_ |
int64 |
Resident Type ID | filters on the platform, writable, resident. |
The type ID of this contact. | |
second |
datetime |
Second Delivery Date | filters on the platform, writable, second |
The second delivery date of this property asset, in ATOM/ISO-8601 format. | |
street |
varchar2 |
Street Name | filters on the platform, writable, street |
The street name of the address of this property asset. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, zip |
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: