invantive documentation
Invantive Support ForumsLog In / Sign Up

ContactHourLogs: Bouw7 Contact Hour Logs

read only REST

  • Catalog: Bouw7
  • Schema: HourLog
  • Label: Contact Hour Logs

Returns a list of contact hour logs associated with your organization. Returns a list of contact hour logs associated with your organization.

Can only retrieve data.

Summary

Returns a list of contact hour logs associated with your organization.

API Source

  • Endpoint: /list/hour-logs/contact
  • Operation: get /list/hour-logs/contact

Performance Characteristics

Characteristic Value
Average access latency (ms) 391
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 ContactHourLogs 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
approvedAt datetime Approved at filters on the platform, writable, approvedAt The time this hour log entry was approved at.
approvedBy_id int64 Approved by ID filters on the platform, writable, approvedBy.id The ID of the user.
approvedBy_username varchar2 Approved by User Name filters on the platform, writable, approvedBy.username The username. The e-mail address the user uses to sign in.
bookingStatus int64 Booking Status filters on the platform, writable, bookingStatus The booking status of this entry. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited.
comment varchar2 Comment filters on the platform, writable, comment The remark added to this entry.
contact_emailAddress varchar2 Contact Email Address filters on the platform, writable, contact.emailAddress The email address of the contact.
contact_id int64 Contact ID filters on the platform, writable, contact.id The ID of the contact.
contact_name varchar2 Contact Name filters on the platform, writable, contact.name The name of this contact.
contact_type varchar2 Contact Type filters on the platform, writable, contact.type The type of this contact.
contact_typeId int64 Contact Type ID filters on the platform, writable, contact.typeId The type ID of this contact.
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.
hourlyRate varchar2 Hourly Rate filters on the platform, writable, hourlyRate The hourly rate.
hours varchar2 Hours filters on the platform, writable, hours The amount of hours logged to this entry.
id int64 ID filters on the platform, writable, id The ID of the hour log.
invoiceLine_id int64 Invoice Line ID filters on the platform, writable, invoiceLine.id The ID of the invoice line.
invoiceLine_invoiceId int64 Invoice Line Invoice ID filters on the platform, writable, invoiceLine.invoiceId The ID of the invoice this invoice line belongs to.
invoiceLine_invoiceStatusId int64 Invoice Line Invoice Status ID filters on the platform, writable, invoiceLine.invoiceStatusId The ID of the status of the invoice this line belongs to.
invoicedAmount varchar2 Invoiced Amount filters on the platform, writable, invoicedAmount The amount to invoice for this hour log entry.
isApproved char Is Approved filters on the platform, writable, isApproved Whether this hour log entry has been approved for processing.
logDate datetime Log Date filters on the platform, writable, logDate The log date of this entry. ATOM format.
projectSecurityLink_code varchar2 Project Security Link Code filters on the platform, writable, projectSecurityLink.code The security code.
projectSecurityLink_costType int64 itgen_bouw7_projectsecuritylink_costtype filters on the platform, writable, projectSecurityLink.costType The name of the cost type.
projectSecurityLink_id int64 Project Security Link ID filters on the platform, writable, projectSecurityLink.id The ID of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name filters on the platform, writable, projectSecurityLink.name The name of the project security link.
projectSecurityLink_parentName varchar2 itgen_bouw7_projectsecuritylink_parentname filters on the platform, writable, projectSecurityLink.parentName The name of the security code.
projectSecurityLink_projectId int64 Project Security Link Project ID filters on the platform, writable, projectSecurityLink.projectId The ID of the project associated with this security code.
projectSecurityLink_status int64 Project Security Link Status filters on the platform, writable, projectSecurityLink.status The status of the project security link.
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_contactName varchar2 Project Contact Name filters on the platform, writable, project.contactName The name of the contact associated with this project.
project_executorName varchar2 Project Executor Name filters on the platform, writable, project.executorName The full name of the executor associated with 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_projectLeaderName varchar2 Project Project Leader Name filters on the platform, writable, project.projectLeaderName The full name of the project leader associated with this 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.
project_workPlannerName varchar2 Project Work Planner Name filters on the platform, writable, project.workPlannerName The full name of the work planner associated with this project.
type_id int64 Type ID filters on the platform, writable, type.id The ID of the hour type.
type_name varchar2 Type Name filters on the platform, writable, type.name The name of the hour type.
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: