def getProgrammeData(**context):
    token = context.get("ti").xcom_pull(key="token")

    response = requests.get(
        url=f"{dRoW_api_end_url}/api/sheets/63fd698ed6779f0c607a677c?with_records=true&fields=",
        headers={"x-access-token": f"Bearer {token}"}
    )

    sheet = json.loads(response.text)
    records = sheet["record"]

    target_col = "Programme Approval Elapsed Time (days)"

    latest_id = -1
    latest_elapsed_time = None

    for record in records:
        # Build column map for easy access
        col_map = {v["colName"]: v.get("value") for v in record.get("values", [])}

        raw_id = col_map.get("id")
        if raw_id is None:
            continue

        try:
            numeric_id = int(raw_id)
        except ValueError:
            continue

        # If this is the largest id so far → update answer
        if numeric_id > latest_id:
            latest_id = numeric_id
            latest_elapsed_time = col_map.get(target_col)

    print(f"Largest Programme ID = {latest_id}")
    print(f"Elapsed Time = {latest_elapsed_time}")

    context["ti"].xcom_push(key="kpi_1", value=latest_elapsed_time)

    return latest_elapsed_time