Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mountaindude
Contributor III

Howto: Posting to Slack from Qlik Sense load script

Being a heavy Slack user, I have for some time thought about the possibility to integrate Slack and Sense.

Turns out it isn't hard at all..

Oh, never heard of Slack? Check it out - it's a really good instant messaging/group communication tool.

Being able to post Slack messages from the Sense load script opens up all sorts of possibilities, for example

  • Have different reload tasks post to different Slack channels, depending on what the tasks do.
  • Post messages when a scheduled reload job starts and ends.
  • Post status messages for long running reload tasks. It is suddenly trivial to get an idea of how far along that 3 hour reload task has come.
  • Post information about failures during the reload. This is especially relevant if a reload task should continue even if some failure occurs – quite often you would still want to notify someone about the failure that did happen.
  • Notify end users and stakeholders that their Sense apps have been refreshed with new data.

Full writeup here.

Should be noted that the approach described in the post above may introduce security risks in a Sense server setting - so do read the Sense help pages for the "execute" command before deploying this in a production setting.

I'll post an alternative solution in the next few days too, where security can be kept on default (=higher) levels.

Which one should be used depends on your use case - if you are running Sense desktop you can probably use the approach described above. In a setup with sensitive data you might want to go with the proxy based setup described in the coming post (need a few days to wrap it up..).

3 Replies

Re: Howto: Posting to Slack from Qlik Sense load script

Interesting.

Thank you.

Feeling Qlikngry?

How To /Missing Manual(23 articles)

mountaindude
Contributor III

Re: Howto: Posting to Slack from Qlik Sense load script

Adding to the previous post, at the link below is a write-up on how to use Node.js to create a small proxy service, which via a REST API makes it possible to post Slack messages without lowering the security settings of Sense.

https://ptarmiganlabs.com/blog/2015/12/10/posting-slack-qlik-sense-load-scripts-web-service-style-pa...

Please feel free to extend the (very basic) Node proxy code - I am sure there are lots of good things that can be added there. Github pull requests always welcome!

/Göran

mountaindude
Contributor III

Re: Howto: Posting to Slack from Qlik Sense load script

Update:

Added another endpoint to the proxy, for creating directories on the server where the proxy app is running.

The rationale for this is that you probably don't want to lower Sense's security settings, but those settings prevent you from (among other things) creating directories on disk.

Another option is then to have a small proxy app do this for you..

The proxy app now has two endpoints:

/slack          for posting to Slack

/createDir   for creating directories on disk

It is pretty easy to add additional endpoints, if/when needed.

Everything available at the GitHub repository.