Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Moo
Contributor II
Contributor II

Send Qlik Straight Table Data to Slack

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.

Moo_2-1671103975890.png

Thanks!

 

 

 

Labels (2)
1 Solution

Accepted Solutions
AfeefaTk
Support
Support

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

slack-message.png

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!

View solution in original post

8 Replies
J_Lindberg
Support
Support

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?

AfeefaTk
Support
Support

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

slack-message.png

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!

OmuniBasav
Contributor III
Contributor III

@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. 

Moo
Contributor II
Contributor II
Author

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

OmuniBasav
Contributor III
Contributor III

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

PietMichielRappelet
Former Employee
Former Employee

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. 

OmuniBasav
Contributor III
Contributor III

@PietMichielRappelet Thank for the info 🙂

Moo
Contributor II
Contributor II
Author

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