---
title: "Query ad-hoc summary table"
method: POST
path: "/summary-table/ad-hoc"
tags: ["Summary Tables"]
---

# Query ad-hoc summary table

`POST /summary-table/ad-hoc`

Executes an ad-hoc DCI summary table query

## Request body

- object
  - `baseObject` union, required — Base object ID or name
    - integer
    - string
  - `columns` object[], required
    - `columnName` string — Display column name
    - `dciName` string — DCI name pattern
    - `isRegexp` boolean — Treat dciName as regex
    - `useRegexp` boolean — Alias for isRegexp
    - `matchByDescription` boolean — Match by description instead of name
  - `aggregationFunction` 'LAST' | 'MIN' | 'MAX' | 'AVG' | 'SUM' — Aggregation function
  - `startDate` integer — Start date (Unix epoch seconds)
  - `endDate` integer — End date (Unix epoch seconds)
  - `multiInstance` boolean

## Response `200`

Summary table results

- object
  - `table` object
    - `columns` string[]
    - `rows` array[]
      - string[]

## Other responses

- `400` — Invalid request
- `401` — Access denied

## Changes

- **2026-01-30** `32f48ec94aec` — 1 info
  - endpoint added
- **2023-02-23** `9c09a2aad349` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/netxms/apis/netxms-rest-api/changes/summary-table/ad-hoc/post.md)

---

[API](https://skmtc.dev/netxms/apis/netxms-rest-api.md) · [All operations](https://skmtc.dev/netxms/apis/netxms-rest-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/netxms/netxms-rest-api/revisions/04789afedcb3/schema)