Qlik Community

Ask a Question

Video Transcripts

This page houses video content and respective transcripts.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

Automate Workflows with Webhooks in Qlik Sense Enterprise SaaS

Melissa_Potvin
Community Manager
Community Manager

Automate Workflows with Webhooks in Qlik Sense Enterprise SaaS

 

Transcript


With the new webhooks capability
in Qlik Cloud Services,
you have more control over
how your analytics supply chain
communicates with
enterprise applications,
and that's because webhooks
allow the Qlik platform
to send automated messages, pointing
end users toward a call to action
or directing services to orchestrate
new tasks automatically.
Blendr is Qlik's new application
automation platform, enabling you
to automate any manual application
integration task including Qlik Sense.
Over the next few minutes
I'm going to create a webhook
that sends Qlik Sense app reload statuses
to Microsoft Teams using Blendr.
Let's begin by adding a new blend.
Every blend begins with the start block
and there are a variety of ways
it can be configured.
The webhooks start type
makes a dropdown appear
where I can select Qlik Cloud Services.
I've added an API key from my tenant
so the start block is ready
to listen for events.
Selecting the app reload finished
event enables me
to send a message to Teams
when a reload of a specific app finishes.
When you select an event,
a test payload is provided
so you can craft the blend with variables
without having to run it first.
It's a nice handy dandy feature.
This next part is super cool
because of the way QCs
events are added to Blender.
When I save the blend,
it automatically creates
the webhook entry
in the Qlik management console.
So if I go into the entry,
the URL for the webhook is present
and the event I selected
in the blend editor is checked.
It's a really nice time saver
because it eliminates the extra step of
configuring the webhook manually in QCS.
Next, I'm going to set up some conditions
and variables to control the automation.
Blendr provides a base set of actions
you can use to perform
different processing tasks
in an automation.
In addition to these action blocks,
Blendr includes connectivity
to over 500 different
SaaS applications you can bring together
to automate your work.
I want to run this automation
only when my consumer sales
Qlik Sense app finishes a reload.
So my first block
out is a condition block.
The condition block is your standard
if-then-else statement
in an automation and it's feature rich.
Blendr makes it easy
to substitute message data
by allowing you to pick attributes
from previous blocks.
In this case I'm
adding a condition to evaluate
the app name to be equal
to consumer sales.
I'm going to add
a second condition block inside the first
to evaluate the event status.
Variable blocks in Blendr help store
reusable information during a blend run.
When I drag the variable
out to the editor and click
inside the configuration
I'm prompted to create the variable
because none exists.
I'm creating a string variable
here to store the result
I want to send Teams
through a send message block
that I'm going to set up shortly.
Another cool feature of Blendr is mixing
text with attributes
from the webhook message.
You can add attribute references
by clicking on the name
in the run history.
Now I'll copy the block
and paste in an open area of the editor
and then drag it into the NO path,
changing a quick word like so.
And now we've got success
and failure messages.
Next up
I'm going to add a formatted message
for Microsoft Teams using adaptive cards
and then send the message to a channel.
The first Teams block I want to add takes
a JSON object containing
the adaptive card metadata.
I generated an adaptive card
JSON object earlier,
so I'm just going to paste it
into the card JSON input.
Now if I want to modify
a couple of strings
in the JSON to pick up variables
from earlier in the blend,
I need to toggle the formula parsing,
which enables me
to add the coded representations
of the variables into this JSON string.
Once the variables are added,
I can turn formula parsing back on
and the cool variable
representations reappear.
The last block to add
is the send message block from Teams.
In this block I set the team
I want to send the message to and specify
a channel as well for it to land.
In the content field,
I need to specify the attachment ID
representing the adaptive card
that I created in the previous block
and then I can add the whole block
to the attachment field.
Time to save the configuration
and try it out.
OK, testing out webhooks
with Blendr and Microsoft Teams.
I've got a split screen here
with a Qlik Sense
app using a control 00 script
and Microsoft Teams.
I'm going to press the reload button
on the data load editor
and when the script run finishes,
the formatted message
appears in the teams channel
that I specified.
And there you have it,
Qlik's new webhook capability
combined with its new automation tooling,
provides analytics ops, automations
and connects your analytics
to limitless possibilities
for active intelligence.
Thanks for watching, see you soon.
 
Version history
Revision #:
2 of 2
Last update:
‎2021-03-26 02:50 PM
Updated by:
 
Contributors