Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
KingsleyJH
Partner - Contributor III
Partner - Contributor III

How to send Dashboard as an image to MS Teams in QS SAAS

Hi.

 

Is it possible to loop through all the sheets in a QS SAAS app, export it as an image and then send via teams?

 

I can only see an option for PDFs but it would be nice to have it sent as an image instead.

 

Many thanks

 

Labels (5)
3 Solutions

Accepted Solutions
Shai_E
Support
Support

Hi Kingsley,

With the reporting blocks you can include a sheet as part of a report, so you could export a sheet as a PDF.
But you need the sheets as images, i don't think that is currently possible.

View solution in original post

paulcalvet
Partner - Specialist
Partner - Specialist

Hello,

With this code, I achieve to store the image on OneDrive or S3. But how did you send this image with the teams connector ?

Thanks for your help.

..qlikcloud.com/api/v1/sharing-tasks/{monitorinhubid}/executions/latest/files/image-small?status=successful via the open file HTTP block. 
You need to pass two headers with HTTP block.
API key -- > Bearer {Your api key}
Content-Type --> image/png
+ set encoding to base64

View solution in original post

rlesage
Partner - Contributor III
Partner - Contributor III

Hi

First you want to encode the image to a base64 string with the Base64 encode function:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/working-with-...

Next, you can use this tutorial to send the image to teams
https://community.qlik.com/t5/Qlik-Application-Automation/How-to-use-the-quot-Send-structured-messag...

Beware that the API endpoint of  monitor in hub snapshots is not a publicly supported API endpoint by Qlik (check on qlik.dev). Therefore, it could be that Qlik stops supporting this over time as it "competes" with their reporting API solution (which is limited by your license).

View solution in original post

14 Replies
Shai_E
Support
Support

Hi Kingsley,

Can you share the automations workspace json? so that we can get an idea of what you currently have set up?

From the 'qlik cloud services' connector i only see the option to loop through the sheet objects in json format for a specific app.

I do see different options in 'Microsoft Teams' connector to send a message with an image.

Thanks

KingsleyJH
Partner - Contributor III
Partner - Contributor III
Author

Hi there.

 

I currently don't have anything set up as I don't know what the solution would look like.

I can see that MS Teams can send an image, the part I don't know is how to turn a QS Sheet into an image.

 

Many thanks

Shai_E
Support
Support

Hi Kingsley,

With the reporting blocks you can include a sheet as part of a report, so you could export a sheet as a PDF.
But you need the sheets as images, i don't think that is currently possible.
KingsleyJH
Partner - Contributor III
Partner - Contributor III
Author

Hi,

Thanks for your reply. At this stage, we would like an image to be shown within a message. With a PDF, you would have to click into it and open it up which isn't ideal for the customers requirement.

But if its not possible yet, is this in the pipeline? If so, when can we expect this to be available?

 

Many thanks

Shai_E
Support
Support

Hi Kingsley,

This feature is being worked on, it will be a new block in the reporting connector. No timing I can give atm.
 
Best Regards
p_verkooijen
Partner - Specialist II
Partner - Specialist II

@Shai_E 

Any news, I have found this post https://community.qlik.com/t5/Qlik-Application-Automation/Get-Chart-Image-block-does-not-appear/td-p...mentioning a Chart to Image block.

So it seems possible, only still not released / available after several months.

MikkoL
Contributor II
Contributor II

Would be a great feature and much needed. 

p_verkooijen
Partner - Specialist II
Partner - Specialist II

rlesage
Partner - Contributor III
Partner - Contributor III

I will also post this here, only working for charts and not for sheets:

If you set the chart as monitor in hub, you can fetch the underlying image from ...qlikcloud.com/api/v1/sharing-tasks/{monitorinhubid}/executions/latest/files/image-small?status=successful via the open file HTTP block. 
You need to pass two headers with HTTP block.
API key -- > Bearer {Your api key}
Content-Type --> image/png
+ set encoding to base64

Next you can copy the image to the cloud storage of choice.