List Queries
List Queries
Get a list of account logs for the child account.
Endpoint
POST /log/query/list
Request Header
Authorization: Bearer <jwt_token> |
The Powered by CData JWT which contains: |
| - Parent Account Id | |
| - Child Account Id |
Request Body
filter
| queryType | (optional) Query type |
| startTime | timestamp in UTC |
| endTime | timestamp in UTC |
Response
queries
| queryDateTime | The timestamp of the query |
| queryId | The query Id |
| query | the query |
| queryType | Query type |
| duration | |
| drivers | |
| errorCode | Such as “QUERY_FAILED” |
| errorMessage | Detailed message about the error |
| rowsReturned | |
| userAgent |
Response Example
"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"
},
]