invantive documentation
Invantive SupportforenAnmelden / Eintragen

Customers: Fortnox Customers

insert update delete REST

  • Katalog: Fortnox
  • Schema: Customers
  • Primärschlüssel: CustomerNumber
  • Label: Customers

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

Mit insert, update und delete können Daten abgerufen und geändert werden.

Zusammenfassung

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

API-Quelle

  • Endpunkt: /3/customers
  • Operation: get /3/customers

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 416
Anzahl der Vollscan-Zeilen pro Minute 113,000
Anzahl der Query-Zeilen pro Minute 168

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

Name Datentyp 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

Tabellenspalten

Die Spalten der Tabelle Customers sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
Address1 varchar2(1024) Adresszeile 1 filters on the platform, writable, Address1
Address2 varchar2(1024) Adresszeile 2 filters on the platform, writable, Address2
City varchar2(1024) City filters on the platform, writable, City
CustomerNumber varchar2(1024) Kundennummer 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) Organisationsnummer filters on the platform, writable, OrganisationNumber
Phone varchar2(1024) Phone filters on the platform, writable, Phone
ZipCode varchar2(10) Postleitzahl filters on the platform, writable, ZipCode
c_url varchar2 URL aufrufen filters on the platform, writable, @url

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: