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 |
Adresszeile 1 | filters on the platform, writable, Address1 |
||
Address2 |
varchar2 |
Adresszeile 2 | filters on the platform, writable, Address2 |
||
City |
varchar2 |
City | filters on the platform, writable, City |
||
Customer |
varchar2 |
Kundennummer | filters on the platform, writable, Customer |
||
Email |
varchar2 |
filters on the platform, writable, Email |
|||
Name |
varchar2 |
Name | filters on the platform, writable, Name |
||
Organisation |
varchar2 |
Organisationsnummer | filters on the platform, writable, Organisation |
||
Phone |
varchar2 |
Phone | filters on the platform, writable, Phone |
||
Zip |
varchar2 |
Postleitzahl | filters on the platform, writable, Zip |
||
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: