---
title: "List all history queries"
method: GET
path: "/api/history"
tags: ["History Queries"]
---

# List all history queries

`GET /api/history`

Retrieves a list of all configured history queries

## Response `200`

Array of history query objects

- HistoryQueryLightDTO[]
  - `id` string, required — The unique identifier of the entity.
  - `createdBy` UserInfo, required — Represents the user who performed an action, with a computed display name.
    - `id` string, required — The unique identifier of the user.
    - `friendlyName` string, required — A human-readable display name for the user. "OIAnalytics" for the oianalytics system user, "Admin" for the admin login, or "Firstname Lastname (login)" for regular users.
  - `updatedBy` UserInfo, required — Represents the user who performed an action, with a computed display name.
    - `id` string, required — The unique identifier of the user.
    - `friendlyName` string, required — A human-readable display name for the user. "OIAnalytics" for the oianalytics system user, "Admin" for the admin login, or "Firstname Lastname (login)" for regular users.
  - `createdAt` string, required — Represents an instant in time as an ISO 8601 string.
  - `updatedAt` string, required — Represents an instant in time as an ISO 8601 string.
  - `name` string, required — The name of the history query.
  - `description` string, required — Description of the history query's purpose.
  - `status` 'PENDING' | 'RUNNING' | 'ERRORED' | 'PAUSED' | 'FINISHED', required — Type representing the possible statuses for a history query.
  - `startTime` string, required — Start time for the data to be queried (ISO 8601 format).
  - `endTime` string, required — End time for the data to be queried (ISO 8601 format).
  - `southType` 'opcua' | 'mqtt' | 'modbus' | 'oianalytics' | 'ads' | 'folder-scanner' | 'ftp' | 'influxdb' | 'mongodb' | 'mssql' | 'mysql' | 'odbc' | 'oledb' | 'opc' | 'oracle' | 'osisoft-pi' | 'postgresql' | 'rest' | 's7' | 'sftp' | 'sqlite', required — Type representing the possible types for a South connector.
  - `northType` 'opcua' | 'mqtt' | 'modbus' | 'oianalytics' | 'rest' | 'sftp' | 'aws-s3' | 'azure-blob' | 'azure-data-explorer' | 'console' | 'file-writer', required — Type representing the possible types for a North connector.
  - `currentItemNumber` number, double — The 1-based index of the item currently being queried, among the run's enabled items. Only set while the history query is actively running on a connector that queries items one at a time (SOUTH_SINGLE_ITEMS).
  - `numberOfItems` number, double — The total number of enabled items in the run. Only set while the history query is actively running on a connector that queries items one at a time (SOUTH_SINGLE_ITEMS).

## Changes

- **2026-08-25** `80cc291574b0` — 1 warning
  - added the new `mongodb` enum value to the `items/southType` response property for the response status `200`
- **2026-08-24** `c7fdedb4e501` — 2 warning, 2 info
  - added the new `azure-data-explorer` enum value to the `items/northType` response property for the response status `200`
  - added the new `s7` enum value to the `items/southType` response property for the response status `200`
  - added the optional property `items/currentItemNumber` to the response with the `200` status
  - added the optional property `items/numberOfItems` to the response with the `200` status
- **2026-08-18** `87fa588c6b1b` — 2 warning, 2 info
  - removed the optional property `items/currentItemNumber` from the response with the `200` status
  - removed the optional property `items/numberOfItems` from the response with the `200` status
  - removed the `azure-data-explorer` enum value from the `items/northType` response property for the response status `200`
  - removed the `s7` enum value from the `items/southType` response property for the response status `200`
- **2026-08-10** `a5458a493e76` — 2 info
  - added the optional property `items/currentItemNumber` to the response with the `200` status
  - added the optional property `items/numberOfItems` to the response with the `200` status
- …earlier changes not shown

[Full history](https://skmtc.dev/optimistiksas/apis/oibus-api/changes/api/history/get.md)

---

[API](https://skmtc.dev/optimistiksas/apis/oibus-api.md) · [All operations](https://skmtc.dev/optimistiksas/apis/oibus-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/optimistiksas/oibus-api/revisions/08f74b792a13/schema)