3

I'm trying to send SQL query results via Python Slack bot it should look like a three-column table

Things I tried:

  • Send a raw HTML table to be rendered as a table in Slack.
  • Send a Markdown table to be rendered in Slack.
  • Send an ASCII art table to be displayed in Slack.

None of the above worked, the ASCII one did not align properly and the others did not render at all

I read in the official API docs that there is a way to make a two-column table using section, but I need three or more columns.

Is there any way to send via Python + SlackAPI a nice looking table?

Alon Barad
  • 1,491
  • 1
  • 13
  • 26

2 Answers2

3

As @OneCricketeer said, Slack does not support tables.

You can find alternative ways to display a table here. If you decide to transform a table into an image, you can start here.

rmssoares
  • 175
  • 1
  • 11
1

This is the best way I have found, using prettytable

import requests
from prettytable import PrettyTable
  
x = PrettyTable()
  
x.field_names = ["First name", "Last name", "Salary", "City", "DOB"]
x.add_row(["Shubham", "Chauhan", 60000, "Lucknow", "22 Feb 1999"])
x.add_row(["Saksham", "Chauhan", 50000, "Hardoi", "21 Aug 2000"])
x.add_row(["Preeti", "Singh", 40000, "Unnao", "10 Jan 1995"])
x.add_row(["Ayushi", "Chauhan", 65000, "Haridwar", "30 Jan 2002"])
x.add_row(["Abhishek", "Rai", 70000, "Greater Noida", "16 Jan 1999"])
x.add_row(["Dinesh", "Pratap", 80000, "Delhi", "3 Aug 1998"])
x.add_row(["Chandra", "Kant", 85000, "Ghaziabad", "18 Sept 1997"])
table = x.get_string()
pay={
    "blocks": [
        {
            "type": "section",
            "text": {
                "type": "mrkdwn",
                "text": f"```{table}```"
            }
        }
    ]
}

url="https://hooks.slack.com/services/ajarl/epeich/agromanauer"

requests.post(url, json=pay)
Jose
  • 31
  • 2