Top 10 Asana Tasks

asana.py

import os
import asana
from pathlib import Path
from tqdm import tqdm
import pandas as pd

import warnings
warnings.filterwarnings("ignore")

# @icaoberg Read secrets. assumes file exists in ~/.ASANA_SECRETS
# get personal access token here https://developers.asana.com/docs/personal-access-token
file = str(Path.home()) + os.sep + '.ASANA_SECRETS'
exec(open(file).read())

client = asana.Client.access_token(PERSONAL_ACCESS_TOKEN)
client.options['client_name'] = 'Jupyter Lab'

me = client.users.get_user("me")
workspaces = me['workspaces']

tasks = client.tasks.find_all(workspace=workspaces[1]['gid'], assignee='icaoberg@psc.edu')

todo = []
for task in tqdm(tasks):
    tid = task['gid']
    tmetadata = client.tasks.find_by_id(task=tid)
    todo.append({'due_on':tmetadata['due_on'], \
                 'completed':tmetadata['completed'], \
                'description':tmetadata['name']})

df = pd.DataFrame(todo)

print('\n# Top 10 Asana Tasks')
df = df[df['completed']==False].sort_values('due_on')
print(df[0:11][['due_on','description']].to_markdown(index=False,tablefmt="github"))