count slack messages posted to a channel by user

slack-messages-by-user.py

#!/usr/bin/python
'''
Script to count messages by user posted to a channel for a given date range.

Install:
# sudo pip install slackclient

Also you will need to obtain a slack API token:
    https://api.slack.com/docs/oauth-test-tokens

Usage Example:
 
# python SLACK_SEARCH_FROM=2016-11-01 SLACK_SEARCH_TO=2016-12-01 \
         SLACK_CHANNEL_NAME=general SLACK_API_TOKEN=<token> \
         slack-messages-by-user.py
'''

import os
from datetime import datetime
from slackclient import SlackClient

slack_token = os.environ["SLACK_API_TOKEN"]
channel_name = os.environ["SLACK_CHANNEL_NAME"]
date_from = os.environ["SLACK_SEARCH_FROM"]
date_to = os.environ["SLACK_SEARCH_TO"]

oldest = (datetime.strptime(date_from, "%Y-%m-%d") - datetime(1970, 1, 1)).total_seconds()
latest = (datetime.strptime(date_to, "%Y-%m-%d") - datetime(1970, 1, 1)).total_seconds()

sc = SlackClient(slack_token)

users_list = sc.api_call("users.list")
users = {}
for user in users_list['members']:
    users[user['id']] = user['profile']['first_name'] + ' ' + user['profile']['last_name']

channels = sc.api_call("channels.list")
channel_id = None
for channel in channels['channels']:
    if channel['name'] == channel_name:
        channel_id = channel['id']
if channel_id == None:
    raise Exception("cannot find channel " + channel_name)

history = sc.api_call("channels.history", channel=channel_id, oldest=oldest, latest=latest)
posts_by_user = {}

for message in history['messages']:
    if message['user'] in posts_by_user:
        posts_by_user[users[message['user']]] += 1
    else:
        posts_by_user[users[message['user']]] = 1

for user, count in posts_by_user.items():
    print user, 'posted', count, 'messages'

Thanks for the neat code. It is very useful.

Looks like you meant if users[message['user']] in posts_by_user: in place of if message['user'] in posts_by_user:.

Also, at least these days, the API is paginated, and only returns latest 100 messages by default.

The code example is no longer applicable to the current slackclient. It starts with the import statement (should be import slack) and continues with creation of a client (client = slack.WebClient(slack_token)).

Hi , If I want triggered based response then how we can perform the task?

Its shows error in method depreciation