invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Projects: Fortnox Projects

insert update delete REST

  • Catálogo: Fortnox
  • Esquema: Projects
  • Llaves Primarias: ProjectNumber
  • Label: Projects

Retrieve a list of projects The project register can return a list of records or a single record. By specifying a ProjectNumber in the URL, a single record will be returned. If no ProjectNumber is provided, a list of records will be returned.

Permite recuperar y modificar datos utilizando insert, update y delete.

Resumen

The project register can return a list of records or a single record. By specifying a ProjectNumber in the URL, a single record will be returned. If no ProjectNumber is provided, a list of records will be returned.

Fuente de la API

  • Punto final: /3/projects
  • Operación: get /3/projects

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 356
Número de filas escaneadas por minuto 123,000
Número de filas de queries puntuales por minuto 168

El resultado se puede almacenar en la Caché del cliente.

Parámetros

Name Tipo de Datos 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).
todate `` Defines a selection based on an end date.Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Columnas de la Tabla

A continuación se muestran las columnas de la tabla Projects. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
Description varchar2(50) Description filters on the platform, writable, Description
EndDate datetime Fecha Final filters on the platform, writable, EndDate
ProjectLeader varchar2(50) Responsable del proyecto filters on the platform, writable, ProjectLeader
ProjectNumber varchar2(20) Número de proyecto filters on the platform, writable, ProjectNumber
StartDate datetime Fecha Inicial filters on the platform, writable, StartDate
Status varchar2 Status filters on the platform, writable, Status
c_url varchar2 URL de llamada filters on the platform, writable, @url

Ejemplos de queries

--
-- Fortnox Sample Query Accounts
--
-- Table documentation: https://documentation.invantive.eu/2017R2/fortnox-data-model/webhelp/index.html
--
select *
from   Fortnox.Projects.Projectspjt@fnx
limit  100

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: