topic Re: Send Qlik Straight Table Data to Slack in Qlik Automate

Send Qlik Straight Table Data to Slack

Moo — Thu, 15 Dec 2022 11:35:41 GMT

Hi all,

I am trying to send a Table from a Qliksense sheet to slack with the Qlik Application Automation. I use the "template" called "Send straight table data to Microsoft Teams as a message" that appears when I press New Automation.

Then I add all my info, and switch the MS Teams "function" with a slack "function". However, when the automation runs, an empty message is sent to the slack channel. Can anyone anyone help me understand how to input the right factors so that I get the table as an output.
See a screenshot below of how the code

is set up.

Thanks!

Re: Send Qlik Straight Table Data to Slack

J_Lindberg — Mon, 19 Dec 2022 17:20:03 GMT

Hello Moo,
The first step for troubleshooting would be to print out the value of the straight table item(s) in the automation using the "Output" block, to ensure that selection isn't empty.

Perhaps you want to use the Slack block "Send message" instead of the "Send Text Based File" block?
If not, what file type are you trying to send? How did you build the file? Have you added Qlik Application Automation as an app to the Slack channel?

Re: Send Qlik Straight Table Data to Slack

AfeefaTk — Wed, 21 Dec 2022 06:07:07 GMT

Hi @Moo

If you want to send the straight table data as a message to the slack channel in a specific list format you can replace the "Send Text Based File" block with "Send Message With Blocks".

This is how the slack message looks like

Is this what you are expecting?

A JSON file containing an example automation is attached to this article.

Please follow the steps provided in How to import automation from a JSON file article to import the automation

Let us know your feedback

Thanks!

Re: Send Qlik Straight Table Data to Slack

OmuniBasav — Wed, 21 Dec 2022 06:30:05 GMT

@AfeefaTk I tried to send Straight table data in table format to Slack channel, but it shows as 'Array'.

Will it be possible to paste the table as image in Slack channel, or send table in the same format to Slack channel. Any help is much appreciated. Thank you.

Re: Send Qlik Straight Table Data to Slack

Moo — Mon, 09 Jan 2023 11:18:28 GMT

I am also wondering the same as an alternative to that above. Did you figure this out @OmuniBasav?

Re: Send Qlik Straight Table Data to Slack

OmuniBasav — Mon, 09 Jan 2023 11:33:58 GMT

@Moo Nope, I couldn't figure this out. Hence we have dropped this idea. I would surely paste it here incase I find anything.

Re: Send Qlik Straight Table Data to Slack

PietMichielRappelet — Mon, 09 Jan 2023 11:52:04 GMT

Hi All

We are working on a block that gets a chart out of Qlik Sense that can be pasted to Teams, Slack or other tools.
This will allow to e.g. filter on a table and get that table as chart.

@OmuniBasav - if you get a 'array' as output is probably because you are sending a JSON array where the api/block expects text or html.

Re: Send Qlik Straight Table Data to Slack

OmuniBasav — Mon, 09 Jan 2023 12:52:23 GMT

@PietMichielRappelet Thank for the info 🙂

Re: Send Qlik Straight Table Data to Slack

Moo — Thu, 19 Jan 2023 10:39:10 GMT

That sounds great! Do you have any views of when this could be ready?