Skip to main content
POST
/
log
/
query
/
list
List Query Log
curl --request POST \
  --url https://cloud.cdata.com/api/log/query/list \
  --header 'Authorization: Basic <encoded-value>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "endTime": "2023-11-07T05:31:56Z",
  "queryType": 2,
  "startTime": "2023-11-07T05:31:56Z"
}
'
{
  "queries": [
    {
      "credential": "[email protected]",
      "duration": 308,
      "drivers": "PostgreSQL",
      "errorCode": "QUERY_FAILED",
      "errorMessage": "The stored procedure execution failed with the following error:\r\n[500] Could not execute the specified command: Unknown stored function/procedure transferdata\r\n<Query ID: e1af1260-4045-45e4-882b-96fe2575e37b>",
      "logFileKey": "x41GvdkvWlJsaEdQrzI2+t7M+TSbimW8iJIfQPv9mK1PqurO1/pzPW3D2ObewKfK6w51T7ui8yecrEYV3JpW9WmsAU+yVv4Vke1D2lB8EeKsv3ab6w2ZXrNZxPBAgaKAZLoRf8zbuHGWDGSQQ9gDJg==",
      "logVerbosity": 1,
      "query": "PostgreSQL1.public.transferdata",
      "queryId": "e1af1260-4045-45e4-882b-96fe2575e37b",
      "queryType": 203,
      "rowsAffected": -1,
      "rowsInput": 1,
      "rowsReturned": 0,
      "timestamp": "2024-03-19T18:55:34.837Z",
      "userAgent": "PostmanRuntime/7.37.0"
    }
  ]
}

Authorizations

​
Authorization
string
header
required

Basic Authentication with username and password. Use your PAT as the password. You can get your PAT from Connect AI by selecting Settings > Access Tokens.

Body

application/json
​
endTime
string<date-time> | null

The end time of the query.

​
queryType
enum<integer>[] | null

The type of query.

Available options:
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
​
startTime
string<date-time> | null

The start time of the query.

Response

200 - application/json

OK

​
queries
object[] | null