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": "prat8897@gmail.com",
      "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.

ValueName
0Drivers
1DriverInfo
2TestConnection
3GetOAuthAuthorizationUrl
4GetOAuthAccessToken
5CustomReportInfo
6GenerateCustomReport
7GetAPIRootPaths
8GetAPIColumns
9GetAPIRows
10GetTimeCheckColumns
11GetDynamicPropValues
20DisconnectOAuthAccessToken
100Catalogs
101Schemas
102Tables
103Columns
104PrimaryKeys
105ImportedKeys
106ExportedKeys
107Procedures
108ProcedureParameters
109Indexes
200Query
201QuerySchemaOnly
202Batch
203Exec
204Caching
205ScheduledQuery
210ODataServiceDocument
211ODataMetadata
212ODataQuery
220OpenAPIDocument
230CreateDerivedView
231AlterDerivedView
232DropDerivedView
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