Have wrote a small python script to send results to MS teams , when am try to sending it coming as string format.
My Code:
Syntax: Select all
import pymsteams
import pandas as pd
import numpy as np
import pyodbc
from tabulate import tabulate
server = ‘ServerName’
database = ‘DBName’
username = ‘username’
password = ‘pasword’
conn = pyodbc.connect(‘DRIVER={ODBC Driver 17 for SQL Server};SERVER=’+server+’;DATABASE=’+database+’;UID=’+username+’;PWD=’+ password)
cursor = conn.cursor()
sql_query = “select * from bookingStatusEnum”
df = pd.read_sql(sql_query, conn)
#print(tabulate(sql_query))
def sleeve(df):
df.to_html()
myTeamsMessage = pymsteams.connectorcard("my webhook url ")
myTeamsMessage.title(“List Of Booking Status”)
#myTeamsMessage.text(“Test Mail”)
myTeamsMessage.text(df.to_string())
myTeamsMessage.send()
Results are attached.
I need results in table format. Please help on ASAP
Thanks