acc-reports

ACC Data Reports & Exports

Export ACC project data for:

"$ARGUMENTS"

Prerequisites

• APS credentials configured (see acc-api-setup skill)
• For Issues/RFIs: 3-legged token required
• For Docs/Clash data: 2-legged token is sufficient
• pip install requests openpyxl

Script 1: Export all ACC Issues to CSV

Issues API requires a 3-legged token (user context).

import os, csv, requests
from datetime import datetime

# ── Configuration ─────────────────────────────────────────────────────────────
PROJECT_ID  = os.environ.get("APS_PROJECT_ID_RAW")   # WITHOUT b. prefix
OUTPUT_PATH = r"C:\Reports\acc_issues_export.csv"

BASE_ISSUES = "https://developer.api.autodesk.com/construction/issues/v1"
# ─────────────────────────────────────────────────────────────────────────────

def get_all_issues(client, project_id):
    """Fetch all issues from ACC using pagination."""
    all_issues = []
    offset     = 0
    limit      = 100

    while True:
        url    = f"{BASE_ISSUES}/projects/{project_id}/issues"
        params = {"limit": limit, "offset": offset,
                  "filterType": "all"}   # include all statuses
        data   = client.get(url, params=params)

        issues = data.get("results", [])
        total  = data.get("pagination", {}).get("totalResults", 0)

        all_issues.extend(issues)
        offset += limit

        if offset >= total or not issues:
            break

    return all_issues, total

def issues_to_csv(issues, output_path):
    """Write issues list to CSV."""
    if not issues:
        print("No issues found.")
        return

    os.makedirs(os.path.dirname(output_path), exist_ok=True)

    fieldnames = [
        "Issue Number", "Title", "Status", "Assigned To",
        "Due Date", "Created By", "Created Date",
        "Root Cause", "Type", "Sub-type",
        "Location", "Description", "Closed Date",
    ]

    with open(output_path, "w", newline="", encoding="utf-8") as f:
        writer = csv.DictWriter(f, fieldnames=fieldnames, extrasaction="ignore")
        writer.writeheader()

        for issue in issues:
            attrs = issue.get("attributes", {})
            writer.writerow({
                "Issue Number":  attrs.get("displayId", ""),
                "Title":         attrs.get("title", ""),
                "Status":        attrs.get("status", ""),
                "Assigned To":   (attrs.get("assignedTo", {}) or {}).get("displayName", ""),
                "Due Date":      attrs.get("dueDate", ""),
                "Created By":    (attrs.get("createdBy", {}) or {}).get("displayName", ""),
                "Created Date":  attrs.get("createdAt", ""),
                "Root Cause":    attrs.get("rootCauseLabel", ""),
                "Type":          attrs.get("issueTypeLabel", ""),
                "Sub-type":      attrs.get("issueSubTypeLabel", ""),
                "Location":      attrs.get("locationDetails", ""),
                "Description":   attrs.get("description", "")[:200] if attrs.get("description") else "",
                "Closed Date":   attrs.get("closedAt", ""),
            })

    print(f"Issues exported: {len(issues)} → {output_path}")

if __name__ == "__main__":
    # client must use a 3-legged token
    issues, total = get_all_issues(client, PROJECT_ID)
    print(f"Fetched {len(issues)} of {total} issues")
    issues_to_csv(issues, OUTPUT_PATH)