---
title: "Get a DM Object"
method: POST
path: "/datamart.fetch/{objectId}"
tags: ["Data Manager"]
---

# Get a DM Object

`POST /datamart.fetch/{objectId}`

Retrieves the object's (Data Feed, Data Source, Datamart) row level data. A filter can be applied.<p>
If you want to achieve better performance when fetching large data sets and if you do not need the total number of items in the table – use the **/datamart.fetchnocount/{typedId}** endpoint instead.<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 [List Product](https://api.pricefx.com/openapi/reference/pricefx/operation/post-productmanager.fetchformulafilteredproducts/)'s **listProductsResponseExample_resultFields** response example.<p>
**valueFields**: returns just an array of values. Use this option if a better performance is required. See the [List Product](https://api.pricefx.com/openapi/reference/pricefx/operation/post-productmanager.fetchformulafilteredproducts/)'s **listProductsResponseExample_valueFields** response example.<p>
>When `distinctResults` is set to true, it applies only to the first column specified in the `valueFields` array. For example, if `"valueFields": ["ConditionType", "TableNumber"]` is used, only distinct values for `ConditionType` are returned.

<p>

>**Please note**:
>When paging is applied, use a deterministic sort (for example, `"sortBy":["InvoiceLineID"]`). If no sorting is defined when paging, you may get duplicates in the response.

## Query parameters

- `timeout` string

## Request body

- object
  - `endRow` number
  - `oldValues` unknown
  - `operationType` string
  - `startRow` number
  - `textMatchStyle` string
  - `data` object
    - `_constructor` string
    - `operator` string
    - `criteria` object[]
      - `fieldName` string
      - `operator` string
      - `value` string
  - `sortBy` string[]
  - `resultFields` string[] — The list of fields you want to return.
  - `valueFields` unknown[]
    - unknown
  - `distinctResults` boolean — set to `true` to return only unique values.

## Response `200`

OK

- object
  - `response` object
    - `node` string
    - `startRow` number
    - `data` object[]
    - `endRow` number
    - `totalRows` number
    - `status` number

---

[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)