Collect new job listings in Airtable and post them to Telegram

from clickruntime import on_trigger, credentials, http

BASE_ID, CHANNEL, TAG = "appXXXXXXXXXXXXXX", "@remote_dev_jobs", "dev"

@on_trigger
def run(event):
    jobs = [j for j in http.get("https://remoteok.com/api", headers={"User-Agent": "clickruntime"}).json()[1:]
            if TAG in (j.get("tags") or [])][:50]
    api = f"https://api.airtable.com/v0/{BASE_ID}/Jobs"
    headers = {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    tg = f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage"
    posted = 0
    for j in jobs:
        if posted >= 15:
            break
        found = http.get(api, headers=headers, params={"filterByFormula": f"{{Job ID}}='{j['id']}'", "maxRecords": 1}).json()["records"]
        if found:
            continue
        http.post(api, headers=headers, json={"typecast": True, "records": [{"fields": {"Job ID": str(j["id"]),
                  "Company": j.get("company"), "Title": j.get("position"), "Tags": ", ".join(j.get("tags") or []),
                  "Link": j.get("url")}}]}).raise_for_status()
        http.post(tg, json={"chat_id": CHANNEL, "text": f"{j.get('position')} at {j.get('company')}\n{j.get('url')}"})
        posted += 1
    return {"posted": posted}