Loads the SQL of the request in the specified transaction.
Syntax: GET /api/Transaction/LoadRequestSql/{transactionId}
{transactionId} indicates the transaction ID.
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/Transaction/LoadRequestSql/3722165D-3C45-4F73-A4D9-E5C0597510F9-1")
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:
[
{
"sessionId": "string",
"modelName": "string",
"sqlStatement": "string",
"transactionId": "string",
"operationType": "string",
"startTime": "2022-02-21T02:58:34.515Z",
"duration": 0
}
]
