invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectTasksByInternalId: Visma.net Financials Project Tasks by Internal ID

read only REST

  • Catalog: VismaNet
  • Schema: ProjectTask
  • Label: Project Tasks by Internal ID

Get project task information by internal id. Data for a single project task. The response headers include an ETag after a successful GET operation.

Can only retrieve data.

Summary

Data for a single project task.

The response headers include an ETag after a successful GET operation.

API Source

  • Endpoint: /v1/projecttask/{internalId}
  • Operation: get /v1/projecttask/{internalId}

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
internalId `` The organisation code.

Table Columns

The columns of the table ProjectTasksByInternalId 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
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
branch_name varchar2 Branch Name filters on the platform, writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, branch.number Click the magnifier. > The identifier.
createdDateTime datetime Created filters on the platform, writable, createdDateTime Information collected from the system. Not visible on the screen.
defAccount_description varchar2 Default Account Description filters on the platform, writable, defAccount.description Name of item/description
defAccount_number varchar2 Default Account Number filters on the platform, writable, defAccount.number Number of item
defAccount_type varchar2 Default Account Type filters on the platform, writable, defAccount.type
defAccrualAccount_description varchar2 Default Accrual Account Description filters on the platform, writable, defAccrualAccount.description Name of item/description
defAccrualAccount_number varchar2 Default Accrual Account Number filters on the platform, writable, defAccrualAccount.number Number of item
defAccrualAccount_type varchar2 Default Accrual Account Type filters on the platform, writable, defAccrualAccount.type
defAccrualSub_active char Default Accrual Account Sub Active filters on the platform, writable, defAccrualSub.active
defAccrualSub_description varchar2 Default Accrual Account Sub Description filters on the platform, writable, defAccrualSub.description Click on the magnifier. > The description.
defAccrualSub_id varchar2 Default Accrual Account Sub ID filters on the platform, writable, defAccrualSub.id Click on the magnifier. > The identifier.
defSub_active char Default Sub Active filters on the platform, writable, defSub.active
defSub_description varchar2 Default Sub Description filters on the platform, writable, defSub.description Click on the magnifier. > The description.
defSub_id varchar2 Default Sub ID filters on the platform, writable, defSub.id Click on the magnifier. > The identifier.
description varchar2 Description filters on the platform, writable, description Mandatory field: Description > The description of the task.
endDate datetime End Date filters on the platform, writable, endDate End date > The date when the task was actually finished.
internalId int32 Internal ID filters on the platform, writable, internalId Internal ID* > The internal ID of the task.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime Information collected from system.
plannedEnd datetime itgen_vnet_plannedend filters on the platform, writable, plannedEnd
plannedStart datetime itgen_vnet_plannedstart filters on the platform, writable, plannedStart
projectInternalId int32 itgen_vnet_projectinternalid filters on the platform, writable, projectInternalId Project Internal ID* > The internal ID of the project.
rateTable_description varchar2 Rate Table Description filters on the platform, writable, rateTable.description Click on the magnifier. > The description.
rateTable_id varchar2 Rate Table ID filters on the platform, writable, rateTable.id Click on the magnifier. > The identifier.
restrictEmployees char Restrict Employees filters on the platform, writable, restrictEmployees Summary tab > Task properties section > Restrict employees > A check box that indicates (if selected) that only the employees listed on the Employees tab of this window can create activities and documents associated with the current task.
startDate datetime Start Date filters on the platform, writable, startDate Start date > The date when the task was actually started.
status varchar2 Status filters on the platform, writable, status Mandatory field: Status* > The status of the task, which can be one of the following: In planning, Active, Cancelled, Completed.
taskId varchar2 Task ID filters on the platform, writable, taskId Mandatory field: > Task ID* > The ID of the task.
taxCategory_description varchar2 itgen_vnet_taxcategory_description filters on the platform, writable, taxCategory.description Name of item/description
taxCategory_number varchar2 itgen_vnet_taxcategory_number filters on the platform, writable, taxCategory.number Number of item
timeStamp blob Timestamp filters on the platform, writable, timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
visibility_visibleInAp char itgen_vnet_visibility_visibleinap filters on the platform, writable, visibility.visibleInAp Supplier ledger
visibility_visibleInAr char itgen_vnet_visibility_visibleinar filters on the platform, writable, visibility.visibleInAr Customer ledger
visibility_visibleInCa char itgen_vnet_visibility_visibleinca filters on the platform, writable, visibility.visibleInCa Cash management
visibility_visibleInCr char itgen_vnet_visibility_visibleincr filters on the platform, writable, visibility.visibleInCr
visibility_visibleInEa char itgen_vnet_visibility_visibleinea filters on the platform, writable, visibility.visibleInEa Expenses
visibility_visibleInGl char itgen_vnet_visibility_visibleingl filters on the platform, writable, visibility.visibleInGl General ledger
visibility_visibleInIn char itgen_vnet_visibility_visibleinin filters on the platform, writable, visibility.visibleInIn Inventory
visibility_visibleInPo char itgen_vnet_visibility_visibleinpo filters on the platform, writable, visibility.visibleInPo Purchases
visibility_visibleInSo char itgen_vnet_visibility_visibleinso filters on the platform, writable, visibility.visibleInSo Sales
visibility_visibleInTa char itgen_vnet_visibility_visibleinta filters on the platform, writable, visibility.visibleInTa Time entries

Release Notes

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