---
title: "List Query Log"
method: POST
path: "/log/query/list"
tags: ["Log"]
---

# List Query Log

`POST /log/query/list`

Retrieves a list of query logs for an account.

## Request body

- QuerySearchCriteria
  - `endTime` string, date-time, nullable — The end time of the query.
  - `queryType` QueryType[], nullable — The type of query.
  - `startTime` string, date-time, nullable — The start time of the query.

## Response `200`

OK

- QuerySearchResult
  - `queries` QueryRecord[], nullable
    - `credential` string, nullable — The user's credential used to execute the query.
    - `duration` integer — The duration of the query in milliseconds.
    - `drivers` string, nullable — The driver used to execute the query.
    - `errorCode` string, nullable — In the case of an error, the error code.
    - `errorMessage` string, nullable — The error message of the query, if applicable.
    - `logVerbosity` integer, nullable — The verbosity level of the query log.
    - `query` string, nullable — The contents of the query.
    - `queryId` string, uuid — The unique Id of the query.
    - `queryType` 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 20 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 200 | 201 | 202 | 203 | 204 | 205 | 210 | 211 | 212 | 220 | 230 | 231 | 232 — | Value | Name | |-------|------| | 0 | Drivers | | 1 | DriverInfo | | 2 | TestConnection | | 3 | GetOAuthAuthorizationUrl | | 4 | GetOAuthAccessToken | | 5 | CustomReportInfo | | 6 | GenerateCustomReport | | 7 | GetAPIRootPaths | | 8 | GetAPIColumns | | 9 | GetAPIRows | | 10 | GetTimeCheckColumns | | 11 | GetDynamicPropValues | | 20 | DisconnectOAuthAccessToken | | 100 | Catalogs | | 101 | Schemas | | 102 | Tables | | 103 | Columns | | 104 | PrimaryKeys | | 105 | ImportedKeys | | 106 | ExportedKeys | | 107 | Procedures | | 108 | ProcedureParameters | | 109 | Indexes | | 200 | Query | | 201 | QuerySchemaOnly | | 202 | Batch | | 203 | Exec | | 204 | Caching | | 205 | ScheduledQuery | | 210 | ODataServiceDocument | | 211 | ODataMetadata | | 212 | ODataQuery | | 220 | OpenAPIDocument | | 230 | CreateDerivedView | | 231 | AlterDerivedView | | 232 | DropDerivedView |
    - `rowsAffected` integer — The number of rows affected by the query.
    - `rowsReturned` integer — The number of rows returned by the query as a result set.
    - `timestamp` string, date-time — The timestamp of the query.
    - `userAgent` string, nullable — The user agent used to execute the query.

---

[API](https://skmtc.dev/cdata/apis/cdata-connect-ai-rest-api-embedded.md) · [All operations](https://skmtc.dev/cdata/apis/cdata-connect-ai-rest-api-embedded/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/cdata/cdata-connect-ai-rest-api-embedded/revisions/c13133ad66c0/schema)