---
title: "List Customers"
method: POST
path: "/customermanager.fetchformulafilteredcustomers"
tags: ["Customers"]
---

# List Customers

`POST /customermanager.fetchformulafilteredcustomers`

Retrieves a list of Customers. A filter can be applied (see the request sample).<p>

You can choose fields to be returned in the response by employing the `resultFields` or `valueFields` filter:<br>
**resultFields**: returns key-value pairs as objects. This is the more friendly response compared to *valueFields* but the server fetches all fields from the database in the backend which might result in a slower performance. See the **listCustomersResponseExample_resultFields** response example.<p>
**valueFields**: returns just an array of values. Use this option if a better performance is required. See the **listCustomersResponseExample_valueFields** response example.

## Request body

- object
  - `endRow` number — The number of the end row that defines the end of the result set's returned objects. Use this parameter if you want to implement paging for results.
  - `oldValues` unknown
  - `operationType` string
  - `startRow` number — The number of the first row that defines the start of the result set's returned objects. Use this parameter if you want to implement paging for results.
  - `textMatchStyle` string
  - `data` object, nullable
    - `_constructor` string
    - `operator` string
    - `criteria` object[]
      - `fieldName` string
      - `operator` 'equals' | 'iEquals' | 'notEqual' | 'iNotEqual' | 'isNull' | 'notNull' | 'contains' | 'iContains' | 'containsPattern' | 'iContainsPattern' | 'notContains' | 'iNotContains' | 'startsWith' | 'iStartsWith' | 'notStartsWith' | 'iNotStartsWith' | 'endsWith' | 'iEndsWith' | 'notEndsWith' | 'iNotEndsWith' | 'iBetween' | 'iBetweenInclusive' | 'inSet' | 'notInSet' — Specify an operator of the filter criteria.
      - `value` string

## Response `200`

Returns customer record details.

- object
  - `response` union
    - object
      - `node` string
      - `data` Customer[] — The `Customer` object. The Type code is C.
        - `createDate` string, date-time
        - `createdBy` integer
        - `customerId` string
        - `isParent` boolean, nullable
        - `lastUpdateBy` integer
        - `lastUpdateDate` string, date-time
        - `name` string
        - `nodeId` integer
        - `parentId` integer
        - `typedId` string
        - `userGroupEdit` string
        - `userGroupViewDetails` string
        - `version` integer
        - `attribute1` string
        - `attribute2` string
        - `attribute3` string
        - `attribute4` string
        - `attribute5` string
        - `attribute6` string
        - `attribute7` string
        - `attribute8` string
        - `attribute9` string
        - `attribute10` string
        - `attribute11` string
        - `attribute12` string
        - `attribute13` string
        - `attribute14` string
        - `attribute15` string
        - `attribute16` string
        - `attribute17` string
        - `attribute18` string
        - `attribute19` string
        - `attribute20` string
        - `attribute21` string
        - `attribute22` string
        - `attribute23` string
        - `attribute24` string
        - `attribute25` string
        - `attribute26` string
        - `attribute27` string
        - `attribute28` string
        - `attribute29` string
        - `attribute30` string
      - `status` number
    - object — A nested array of values.
      - `data` unknown[]
        - unknown

---

[API](https://skmtc.net/pricefx/apis/the-pricefx-backend-api.md) · [All operations](https://skmtc.net/pricefx/apis/the-pricefx-backend-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/pricefx/the-pricefx-backend-api/versions/0850b5d6be73/schema)