---
title: "SQL Query a Data Manager Object"
method: POST
path: "/datamart.sqlquery"
tags: ["Data Manager"]
---

# SQL Query a Data Manager Object

`POST /datamart.sqlquery`

Processes and queries data from Price Analyzer or Price Optimizer. The queries can be aggregated, do various computations including statistical projections. Supports filtering.

## Query parameters

- `timeout` string

## Request body

- object
  - `operationType` string
  - `startRow` integer
  - `endRow` integer
  - `data` object
    - `sources` object
      - `s0` object
        - `query` object
          - `source` string
          - `projections` object
            - `Month` object
              - …
            - `Quantity` object
              - …
          - `options` object
            - `currency` string
          - `filter` object
          - `aggregateFilter` unknown
          - `dimensionFilters` object[]
            - `Invoice_DateYear` string[]
          - `rollup` boolean
      - `s1` object
        - `query` object
          - `source` string
          - `projections` object
            - `Month` object
              - …
            - `Quantity` object
              - …
          - `options` object
            - `currency` string
          - `filter` object
          - `aggregateFilter` unknown
          - `dimensionFilters` object[]
            - `Invoice_DateYear` string[]
          - `rollup` boolean
    - `with` object
      - `w0` string
    - `sql` string

## Response `200`

OK

- object
  - `response` object
    - `node` string
    - `startRow` number
    - `data` object[]
      - `bandBy` string
      - `bubbleSize` number
      - `bubbleSize_n` number
      - `groupBy` string
      - `x` number
      - `y` number
      - `summary` string
    - `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)