Customers: Fortnox Customers
insert update delete REST
- Catalogo:
Fortnox - Schema:
Customers - Chiavi primarie:
CustomerNumber - Label: Customers
Retrieve a list of customers The customers are returned sorted by customer number with the lowest number appearing first.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Riepilogo
The customers are returned sorted by customer number with the lowest number appearing first.
Codice sorgente dell'API
- Punto finale:
/3/customers - Operazione:
get /3/customers
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 416 |
| Righe di scansione completa al minuto | 113,000 |
| Numero di righe di Query al minuto | 168 |
Il risultato può essere memorizzato nella memoria cache sul client.
Parametri
| Name | Tipo di dati | 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 |
Colonne della tabella
Di seguito sono riportate le colonne della tabella Customers. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Address1 |
varchar2 |
Indirizzo 1 | filters on the platform, writable, Address1 |
||
Address2 |
varchar2 |
Indirizzo 2 | filters on the platform, writable, Address2 |
||
City |
varchar2 |
City | filters on the platform, writable, City |
||
Customer |
varchar2 |
Numero del cliente | 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 |
Numero di registrazione dell'organizzazione | filters on the platform, writable, Organisation |
||
Phone |
varchar2 |
Phone | filters on the platform, writable, Phone |
||
Zip |
varchar2 |
Codice postale | filters on the platform, writable, Zip |
||
c_url |
varchar2 |
URL di chiamata | filters on the platform, writable, @url |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: