Task Status

Anonymous — Thu, 10 May 2018 08:38:29 GMT

we would like to monitor the Qliksense Task Status from Third party tool. Kindly let us know how to check the Task Status.

1. PostgresQL Query

2. API

Regards

Arul

Re: Task Status

Levi_Turner — Mon, 14 May 2018 14:11:11 GMT

GET /qrs/reloadtask/{TASK_ID}

Example response:

{

"id": "f1915a03-936f-41dd-8e85-24cb447fec00",

"createdDate": "2017-10-17T15:36:03.014Z",

"modifiedDate": "2017-10-30T11:33:47.402Z",

"modifiedByUserName": "DOMAIN\\USERID",

"customProperties": [],

"app": {

"id": "12f964b0-fc25-4de6-9803-30749b21d192",

"name": "APPNAME",

"appId": "",

"publishTime": "2018-04-20T22:22:39.021Z",

"published": true,

"stream": {

"id": "aaec8d41-5201-43ab-809f-3063750dfafd",

"name": "STREAMNAME",

"privileges": null

"savedInProductVersion": "12.108.6",

"migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221",

"availabilityStatus": 0,

"privileges": null

"isManuallyTriggered": false,

"operational": {

"id": "e0a3a7e9-623b-4c45-9339-d68e02147b54",

"lastExecutionResult": {

"id": "53cf668e-6ea3-43cb-8199-e3aae1b80612",

"executingNodeName": "SERVERNAME.COMANY.COM",

"status": 2,

"startTime": "2018-05-14T14:05:29.136Z",

"stopTime": "1753-01-01T00:00:00Z",

"duration": 0,

"fileReferenceID": "00000000-0000-0000-0000-000000000000",

"scriptLogAvailable": false,

"details": [

{

"id": "585ec833-6be4-4c02-b6dc-5dd9926fd613",

"detailsType": 2,

"message": "Trying to start task. Sending task to slave scheduler SERVERNAME.COMPANY.COM",

"detailCreatedDate": "2018-05-14T14:05:29.351Z",

"privileges": null

{

"id": "ccac7ea5-3842-439e-ba0f-05c8f1fbc7e7",

"detailsType": 2,

"message": "Changing task state to Triggered",

"detailCreatedDate": "2018-05-14T14:05:29.137Z",

"privileges": null

{

"id": "f58eb4a0-cd1f-40e9-b823-93f787c333e3",

"detailsType": 2,

"message": "Changing task state from Triggered to Started",

"detailCreatedDate": "2018-05-14T14:05:29.49Z",

"privileges": null

}

"privileges": null

"nextExecution": "2018-05-14T14:20:59Z",

"privileges": null

"name": "TASKNAME",

"taskType": 0,

"enabled": true,

"taskSessionTimeout": 1440,

"maxRetries": 0,

"tags": [],

"privileges": null,

"schemaPath": "ReloadTask"

}

From GET /qrs/about/api/enums we can see the translation of the detailsType to a semantic status:

"StatusEnum": {

"values": [

"0: NeverStarted",

"1: Triggered",

"2: Started",

"3: Queued",

"4: AbortInitiated",

"5: Aborting",

"6: Aborted",

"7: FinishedSuccess",

"8: FinishedFail",

"9: Skipped",

"10: Retry",

"11: Error",

"12: Reset"

"usages": [

"ExecutionResult.Status"

]

Hope that helps.

Re: Task Status

Anonymous — Fri, 18 May 2018 02:24:46 GMT

Hi Turner,

Thanks for your reply. Also i got the result from my postgresql.

Select * from public."ExecutionResults"

where "ExecutionResults"."TaskID"='32781ecd-824f-4fe8-b4f2-f2c3ff18dce9'

order by "ExecutionResults"."StopTime" desc

limit 1

topic Task Status in Integration, Extension & APIs

Task Status

Re: Task Status

Re: Task Status