invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectByProjectNumber: Fortnox Project by Number

read only REST

  • Catalog: Fortnox
  • Schema: Projects
  • Label: Project by Number

Retrieve a single project

Can only retrieve data.

API Source

  • Endpoint: /3/projects/{ProjectNumber}
  • Operation: get /3/projects/{ProjectNumber}

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
ProjectNumber `` identifies the project
todate `` Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Table Columns

The columns of the table ProjectByProjectNumber 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
Project_Comments varchar2(512) Project Comments filters on the platform, writable, Project.Comments
Project_ContactPerson varchar2(50) Project Contact Person filters on the platform, writable, Project.ContactPerson
Project_Description varchar2(50) Project Description filters on the platform, writable, Project.Description
Project_EndDate datetime Project End Date filters on the platform, writable, Project.EndDate
Project_ProjectLeader varchar2(50) Project Leader filters on the platform, writable, Project.ProjectLeader
Project_ProjectNumber varchar2(20) Project Project Number filters on the platform, writable, Project.ProjectNumber
Project_StartDate datetime Project Start Date filters on the platform, writable, Project.StartDate
Project_Status varchar2 Project Status filters on the platform, writable, Project.Status
Project__url varchar2 Project URL filters on the platform, writable, Project.@url

Release Notes

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