---
title: "Customers (Fortnox)"
description: "Customers"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/fortnox/Fortnox.Customers.Customers
original: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.Customers.Customers
updated: 2026-11-17T19:24:14Z
license: https://documentation.invantive.eu/nl/
---

# Customers: Fortnox Customers

`insert` `update` `delete` `REST`

- Catalogus: `Fortnox`
- Schema: `Customers`
- Primaire sleutels: `CustomerNumber`
- Label: Customers

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

Je kunt gegevens ophalen en wijzigen met `insert`, `update` en `delete`.

## Samenvatting

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

## API-bron

- Eindpunt: `/3/customers`
- Operatie: `get /3/customers`

## Prestatiekenmerken

| Characteristic | Value |
|---|---:|
| Gemiddelde toegangsvertraging (ms) | 416 |
| Aantal rijen per minuut bij volledige scan | 113,000 |
| Aantal rijen per minuut in een Query | 168 |

Het resultaat kan op de client in de Cache worden opgeslagen.

## Parameters

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

## Tabelkolommen

De kolommen van de tabel `Customers` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `Address1` | `varchar2(1024)` | Adresregel 1 | [ ] | filters op het platform, beschrijfbaar, `Address1` |  |
| `Address2` | `varchar2(1024)` | Adresregel 2 | [ ] | filters op het platform, beschrijfbaar, `Address2` |  |
| `City` | `varchar2(1024)` | City | [ ] | filters op het platform, beschrijfbaar, `City` |  |
| `CustomerNumber` | `varchar2(1024)` | Klantnummer | [ ] | filters op het platform, beschrijfbaar, `CustomerNumber` |  |
| `Email` | `varchar2(1024)` | Email | [ ] | filters op het platform, beschrijfbaar, `Email` |  |
| `Name` | `varchar2(1024)` | Name | [ ] | filters op het platform, beschrijfbaar, `Name` |  |
| `OrganisationNumber` | `varchar2(30)` | Organisatienummer | [ ] | filters op het platform, beschrijfbaar, `OrganisationNumber` |  |
| `Phone` | `varchar2(1024)` | Phone | [ ] | filters op het platform, beschrijfbaar, `Phone` |  |
| `ZipCode` | `varchar2(10)` | Postcode | [ ] | filters op het platform, beschrijfbaar, `ZipCode` |  |
| `c_url` | `varchar2` | Aanroep-URL | [ ] | filters op het platform, beschrijfbaar, `@url` |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Fortnox](/nl/release-notes/drivers?driver=fortnox)
