---
title: "Customers (Fortnox)"
description: "Customers"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/fortnox/Fortnox.Customers.Customers
original: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.Customers.Customers
updated: 2026-11-17T18:23:03Z
license: https://documentation.invantive.eu/es/
---

# Customers: Fortnox Customers

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

- Catálogo: `Fortnox`
- Esquema: `Customers`
- Llaves Primarias: `CustomerNumber`
- Label: Customers

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

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

## Resumen

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

## Fuente de la API

- Punto final: `/3/customers`
- Operación: `get /3/customers`

## Características de rendimiento

| Characteristic | Value |
|---|---:|
| Latencia media de acceso (ms) | 416 |
| Número de filas escaneadas por minuto | 113,000 |
| Número de filas de queries puntuales por minuto | 168 |

El resultado se puede almacenar en la Caché del cliente.

## Parámetros

| Name | Tipo de Datos | 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 |

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `Customers`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `Address1` | `varchar2(1024)` | Línea de la Dirección 1 | [ ] | filtros en la plataforma, modificables, `Address1` |  |
| `Address2` | `varchar2(1024)` | Línea de la Dirección 2 | [ ] | filtros en la plataforma, modificables, `Address2` |  |
| `City` | `varchar2(1024)` | City | [ ] | filtros en la plataforma, modificables, `City` |  |
| `CustomerNumber` | `varchar2(1024)` | Numero de cliente | [ ] | filtros en la plataforma, modificables, `CustomerNumber` |  |
| `Email` | `varchar2(1024)` | Email | [ ] | filtros en la plataforma, modificables, `Email` |  |
| `Name` | `varchar2(1024)` | Name | [ ] | filtros en la plataforma, modificables, `Name` |  |
| `OrganisationNumber` | `varchar2(30)` | Número de organización | [ ] | filtros en la plataforma, modificables, `OrganisationNumber` |  |
| `Phone` | `varchar2(1024)` | Phone | [ ] | filtros en la plataforma, modificables, `Phone` |  |
| `ZipCode` | `varchar2(10)` | Código Postal | [ ] | filtros en la plataforma, modificables, `ZipCode` |  |
| `c_url` | `varchar2` | URL de llamada | [ ] | filtros en la plataforma, modificables, `@url` |  |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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