PendingApprovalsAssignedToMe: Bouw7 Pending Approvals Assigned to Me
read only REST
- Catalog:
Bouw7 - Schema:
Approval - Label: Pending Approvals Assigned to Me
List all pending approvals for the current authenticated user. List all pending approvals for the current authenticated user.
Can only retrieve data.
Summary
List all pending approvals for the current authenticated user.
API Source
- Endpoint:
/list/approval/assigned-to-me - Operation:
get /list/approval/assigned-to-me
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 71 |
| 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 |
|---|---|---|---|---|
q |
`` | A Heimdall Query Language string |
Table Columns
The columns of the table PendingApprovalsAssignedToMe 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 |
|---|---|---|---|---|---|
book |
varchar2 |
Book Number | filters on the platform, writable, book |
The booking number of the purchase invoice. | |
comments |
varchar2 |
Comments | filters on the platform, writable, comments |
The comment of the purchase invoice. | |
contact |
varchar2 |
Contact Name | filters on the platform, writable, contact |
Contact name of the contact or purchase. | |
cost |
int64 |
Cost excluding VAT | filters on the platform, writable, cost |
The cost excluding vat of the contract or purchase invoice. | |
cost |
int64 |
Cost including VAT | filters on the platform, writable, cost |
The cost including vat of the contract or purchase invoice. | |
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. | |
date |
datetime |
Date | filters on the platform, writable, date |
The date contract or purchase invoice in ATOM format. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this pending approval. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
Name of the contract or purchase invoice. | |
number |
varchar2 |
Number | filters on the platform, writable, number |
Number of the contract or purchase invoice. | |
project |
varchar2 |
Project Name | filters on the platform, writable, project |
Project name of the contact or purchase. | |
purchase |
int64 |
Purchase Invoice ID | filters on the platform, writable, purchase |
Purchase invoice ID, can be null depends on the given type. | |
purchase |
int64 |
Purchase Order Contract ID | filters on the platform, writable, purchase |
Purchase order contract ID, can be null depends on the given type. | |
status |
int64 |
Status ID | filters on the platform, writable, status |
Status id of the contract or purchase invoice. | |
subcontractor |
int64 |
Subcontractor Contract ID | filters on the platform, writable, subcontractor |
Subcontractor contract ID, can be null depends on the given type. | |
type |
int64 |
Type | filters on the platform, writable, type |
0 = Purchase invoice, 1 = Purchase order, 2 = Contract subcontractor. | |
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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: