How to Enrich Clay & n8n Outbound Tables with Live ATS Job Postings (2026 Blueprint)

import requests

API_KEY = "jp_live_your_api_key"
BASE_URL = "https://api.jobpostingsapi.com/v1"

def enrich_account_hiring_signals(company_domain: str, role_keyword: str = "engineer") -> dict:
    """
    Query active ATS job postings for a specific company domain or slug
    and return ready-to-merge outbound personalization variables.
    """
    resp = requests.get(
        f"{BASE_URL}/companies/{company_domain}/jobs",
        headers={"x-api-key": API_KEY},
        params={"limit": 10, "refresh": "false"},
        timeout=15,
    )
    if resp.status_code == 404:
        return {"hiring_active": False, "open_roles_count": 0}
    resp.raise_for_status()
    payload = resp.json()
    jobs = payload.get("data", [])

    matching = [
        j for j in jobs
        if role_keyword.lower() in j.get("title", "").lower()
    ] or jobs[:3]

    if not matching:
        return {"hiring_active": False, "open_roles_count": 0}

    top_job = matching[0]
    salary = top_job.get("salary") or {}
    return {
        "hiring_active": True,
        "open_roles_count": len(jobs),
        "featured_role_title": top_job.get("title"),
        "featured_role_url": top_job.get("url"),
        "featured_role_ats": (top_job.get("source") or {}).get("name"),
        "salary_range_usd": f"${salary.get('min', 'N/A')} - ${salary.get('max', 'N/A')}",
        "detected_tech_stack": ", ".join(top_job.get("skills") or []),
    }

if __name__ == "__main__":
    signal = enrich_account_hiring_signals("anthropic.com", role_keyword="security")
    print(signal)