invantive documentation
Invantive Support ForumsLog In / Sign Up

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
bookNumber varchar2 Book Number filters on the platform, writable, bookNumber The booking number of the purchase invoice.
comments varchar2 Comments filters on the platform, writable, comments The comment of the purchase invoice.
contactName varchar2 Contact Name filters on the platform, writable, contactName Contact name of the contact or purchase.
costExcludingVat int64 Cost excluding VAT filters on the platform, writable, costExcludingVat The cost excluding vat of the contract or purchase invoice.
costIncludingVat int64 Cost including VAT filters on the platform, writable, costIncludingVat The cost including vat of the contract or purchase invoice.
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.
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.
projectName varchar2 Project Name filters on the platform, writable, projectName Project name of the contact or purchase.
purchaseInvoiceId int64 Purchase Invoice ID filters on the platform, writable, purchaseInvoiceId Purchase invoice ID, can be null depends on the given type.
purchaseOrderContractId int64 Purchase Order Contract ID filters on the platform, writable, purchaseOrderContractId Purchase order contract ID, can be null depends on the given type.
statusId int64 Status ID filters on the platform, writable, statusId Status id of the contract or purchase invoice.
subcontractorContractId int64 Subcontractor Contract ID filters on the platform, writable, subcontractorContractId 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.
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.

Release Notes

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