invantive documentation
Invantive Support ForumsLog In / Sign Up

Customers: Fortnox Customers

insert update delete REST

  • Catalog: Fortnox
  • Schema: Customers
  • Primary Keys: CustomerNumber
  • Label: Customers

Retrieve a list of customers The customers are returned sorted by customer number with the lowest number appearing first.

Can retrieve data and change data using insert, update and delete.

Summary

The customers are returned sorted by customer number with the lowest number appearing first.

API Source

  • Endpoint: /3/customers
  • Operation: get /3/customers

Performance Characteristics

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

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
city `` filter by city
customernumber `` filter by customer number
email `` filter by email
filter `` possibility to filter customers (Values: active, inactive)
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).
gln `` filter by gln
glndelivery `` filter by gln delivery
lastmodified `` filter by last modified
name `` filter by name
organisationnumber `` filter by organisation number
phone `` filter by phone
todate `` Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
zipcode `` filter by zip code

Table Columns

The columns of the table Customers 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
Address1 varchar2(1024) Address Line 1 filters on the platform, writable, Address1
Address2 varchar2(1024) Address Line 2 filters on the platform, writable, Address2
City varchar2(1024) City filters on the platform, writable, City
CustomerNumber varchar2(1024) Customer Number filters on the platform, writable, CustomerNumber
Email varchar2(1024) Email filters on the platform, writable, Email
Name varchar2(1024) Name filters on the platform, writable, Name
OrganisationNumber varchar2(30) Organisation Number filters on the platform, writable, OrganisationNumber
Phone varchar2(1024) Phone filters on the platform, writable, Phone
ZipCode varchar2(10) ZIP Code filters on the platform, writable, ZipCode
c_url varchar2 Call URL filters on the platform, writable, @url

Release Notes

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