topic Re: Using Sense API to get notification when scheduled task fails in App Development

Using Sense API to get notification when scheduled task fails

mountaindude — Wed, 09 Sep 2015 06:00:00 GMT

I am looking for a way to hook into the Sense backend and attach a callback/event trigger, so I can get notified when for example certain reload tasks fail.

Looking at the API, there are a set of "Notification" endpoints, for example "Notification: Add change subscription".

Sounds very promising, but the docs are somewhat vague wrt what will trigger a notification. From what I understand, this API will trigger when conditions (add/update/delete) are met for certain properties of an entity (or several entities).

Or should I set the reload task as the entity, then subscribe to a changed event for that entity, and finally look at what the change consists of?

I think some trial and error is needed here, unless some API wiz can provide guidance...?

Thx

Göran

Re: Using Sense API to get notification when scheduled task fails

Anonymous — Fri, 11 Sep 2015 14:58:30 GMT

One way would be to subscribe to updates to ExecutionResult objects filtering on property status being FinishedFail, as below:

POST /qrs/notification?name=ExecutionResult&filter=status%20eq%20FinishedFail&changetype=Update

Note that the body in the request above should be a double quoted URL, e.g. "http://localhost:9876/notifyme". The API documentation incorrectly states that you will get a GUID back. Instead, you will get a change info object back looking something like this:

[{"id":"00000000-0000-0000-0000-000000000000","createdDate":"1753-01-01T00:00:00.000Z","modifiedDate":"1753-01-01T00:00:00.000Z","modifiedByUserName":"","changeType":2,"objectType":"ExecutionResult","objectID":"87c4d045-7841-4b55-8734-defd9a3f55f8","engineID":"","engineType":"","privileges":null,"schemaPath":"ExternalChangeInfo"}]

ObjectID refers to the ID of the ExecutionResult object. To find out more about the task execution and which task that failed, you will need to query the API for the ExecutionResult object. Then, use the ExecutionResult object's property taskID to fetch the task.

GET /qrs/executionresult/87c4d045-7841-4b55-8734-defd9a3f55f8

GET /qrs/reloadtask/65e4a7af-c5fe-49c9-a79e-b5959f2af36b

/Mattias

Re: Using Sense API to get notification when scheduled task fails

pragya10 — Mon, 11 Feb 2019 07:58:18 GMT

Hi,

Did you test this on Postman ?

Re: Using Sense API to get notification when scheduled task fails

soporte_derevo — Fri, 18 Nov 2022 21:48:20 GMT

can this use info for QlikView?