md_bot.py

import os
import csv
from dateutil.parser import parse
from slack import WebClient
from slack.errors import SlackApiError

slack_token = os.environ["SLACK_API_TOKEN"]
client = WebClient(token=slack_token)

march_27 = parse('3/27/2022').date()

breach_report = open('breach_report.csv', 'r').read()
csv_obj = csv.DictReader(breach_report)

breaches_to_process = [b for b in csv_obj if parse(b['Breach Submission Date']).date() >= march_27]

for b in breaches_to_process:
    try:
        response = client.chat_postMessage(
            channel="slack-bots",
            text=f"New breach submission: {b['Breach Submission Date']} by {b['Name of Covered Entity']}"
        )

    except SlackApiError as e:
  # You will get a SlackApiError if "ok" is False
        assert e.response["error"]  # str like 'invalid_auth', 'channel_not_found'

# latest_breach = open('breach_report', 'w')