DeletedProjects: Bouw7 Deleted Projects
read only REST
- Catalog:
Bouw7 - Schema:
Project - Label: Deleted Projects
Returns a list of deleted projects associated with the organization. Returns a list of deleted projects associated with the organization.
Can only retrieve data.
Summary
Returns a list of deleted projects associated with the organization.
API Source
- Endpoint:
/deleted-projects - Operation:
get /deleted-projects
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 20,800 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Table Columns
The columns of the table DeletedProjects 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 |
|---|---|---|---|---|---|
contact_ |
varchar2 |
Contact Email | filters on the platform, writable, contact. |
The email address. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, contact. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable, contact. |
The phone number of the contact. | |
deleted |
varchar2 |
Deleted at | filters on the platform, writable, deleted |
The date the project was deleted in ATOM format. | |
deleted |
int64 |
Deleted by ID | filters on the platform, writable, deleted |
ID of the user. | |
deleted |
varchar2 |
Deleted by User Name | filters on the platform, writable, deleted |
The username of the user. | |
full |
varchar2 |
Full Project Number | filters on the platform, writable, full |
The full project number including year. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the project. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The name of the project. | |
status_ |
char |
Status Closes Project | filters on the platform, writable, status. |
Whether or not this status closes a project. | |
status_ |
datetime |
Status Created at | filters on the platform, writable, status. |
The creation time of the entity. | |
status_ |
varchar2 |
Status Created by | filters on the platform, writable, status. |
The user that created the entity. | |
status_ |
int64 |
Status ID | filters on the platform, writable, status. |
The ID of the status. | |
status_ |
char |
Status Invoices Project | filters on the platform, writable, status. |
Whether or not this status invoices a project. | |
status_ |
varchar2 |
Status Name | filters on the platform, writable, status. |
The name of the status. | |
status_ |
char |
Status Plans Project | filters on the platform, writable, status. |
Whether or not this status plans a project. | |
status_ |
datetime |
Status Updated at | filters on the platform, writable, status. |
The last updated time of the entity. | |
status_ |
varchar2 |
Status Updated by | filters on the platform, writable, status. |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: