Loads the detailed statistics of failed transactions.
Syntax: GET /api/Statistics/LoadFailedTransactionsStatistics
PowerScript code example:
Integer li_rc
String ls_body
httpclient lhc_client
lhc_client = create httpclient
lhc_client.setrequestheader("Content-Type", "application/json;charset=UTF-8",true)
li_rc = lhc_client.sendrequest( "Get", "http://172.25.100.32:5000/api/Statistics/LoadFailedTransactionsStatistics")
if li_rc = 1 and lhc_client.getresponsestatuscode( ) = 200 then
lhc_client.getrequestbody(ls_body)
end if
When successful, it returns the response status code 200 and the following response body:
When failed, it returns 400 (bad request), 401 (unauthorized), or 500 (server error).
[
{
"createdTime": "2022-02-21T02:35:59.790Z",
"startedTime": "2022-02-21T02:35:59.790Z",
"executionTime": {
"ticks": 0,
"days": 0,
"hours": 0,
"milliseconds": 0,
"minutes": 0,
"seconds": 0,
"totalDays": 0,
"totalHours": 0,
"totalMilliseconds": 0,
"totalMinutes": 0,
"totalSeconds": 0
},
"transactionId": "string",
"transactionStatus": 0,
"requestsStatistics": [
{
"executionStart": "2022-02-21T02:35:59.790Z",
"executionTime": {
"ticks": 0,
"days": 0,
"hours": 0,
"milliseconds": 0,
"minutes": 0,
"seconds": 0,
"totalDays": 0,
"totalHours": 0,
"totalMilliseconds": 0,
"totalMinutes": 0,
"totalSeconds": 0
},
"isSuccess": true,
"transactionId": {},
"dbRequestKind": 0,
"requestDataFormat": 0,
"moduleOrModelName": "string",
"sqlId": "string",
"sqlStatement": "string",
"sqlParameters": [
"string"
],
"columnCount": 0,
"rowCount": 0,
"hasResultSet": true,
"resultLength": 0,
"sqlDbCode": 0,
"errorMessage": "string"
}
]
}
]
