Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Kingsley,
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
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).
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
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
Hi Kingsley,
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
Hi Kingsley,
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.
Would be a great feature and much needed.
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.