メインコンテンツへスキップ
POST
/
log
/
query
/
list
List Query Log
curl --request POST \
  --url https://cloud.cdata.com/api/log/query/list \
  --header 'Authorization: Bearer <token>' \
  --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"
    }
  ]
}

承認

Authorization
string
header
必須

JWT token authentication. Include the token in the Authorization header as Bearer {token}. See Authentication [blocked] for more information on creating a token.

ボディ

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
利用可能なオプション:
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.

レスポンス

200 - application/json

OK

queries
object[] | null