Get workload insights data in structured JSON format

What are Workload Insights? Workload Insights provides detailed analysis of open task volumes across projects and categories over time. Unlike Project Insights which focuses on completed work (time spent), Workload Insights examines the number of open tickets to answer forward-looking questions: “How much work is still in the system?” and “Is demand for services increasing or decreasing?”

What data is returned: The response includes two “sheets” of data in JSON format (matching the Excel export structure):

• Summary sheet: Simple format with Period Label and Task Count columns. Quick overview of task volumes.
• Detailed sheet: Long format (normalized) with one row per period/breakdown combination. Perfect for detailed analysis and pivot tables.

Supported analysis options:

• Project selection: Analyze single project or compare multiple projects
• Date range: Required for OVER_TIME model, not used for TODAY model
• Model selection:
  • TODAY: Current snapshot of open tasks (similar to dashboard overview). Shows current state without time dimension.
  • OVER_TIME: Historical trend analysis showing how workload has changed over time. Helps identify if more work is coming in than being processed.
• Period granularity: Required for OVER_TIME model - group by months or weeks
• Breakdown options:
  • byProject: Task count breakdown by project
  • byTaskType: Task count breakdown by task category
  • byStatus: Task count breakdown by current status (New, In Progress, Feedback, etc.)
  • byAge: Task count breakdown by age groups (how long tasks have been open)

What counts as “open” tasks: A task is considered “open” when its status type is NOT Closed. This includes:

• New tasks
• Tasks In Progress
• Tasks awaiting Feedback
• Tasks in Backlog
• Resolved tasks (not yet closed)

Only tasks with status type Closed are excluded from the analysis.

Use cases:

• Monitor current workload across projects
• Track workload trends over time to identify bottlenecks
• Analyze task distribution by type, status, or age
• Compare workload across multiple projects
• Identify if demand is increasing faster than capacity
• Export to Excel for capacity planning and resource allocation

Business value: Workload Insights helps managers:

• Understand current capacity utilization
• Identify projects with excessive backlogs
• Plan resource allocation based on workload trends
• Detect early warning signs of capacity issues
• Make data-driven decisions about hiring or project prioritization

curl -X GET "https://leadtime.app/api/public/insights/workload-chart?projectIds=7acff2df-a904-4323-adcc-c2f24a769bde&model=OVER_TIME" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN"

const response = await fetch("https://leadtime.app/api/public/insights/workload-chart?projectIds=7acff2df-a904-4323-adcc-c2f24a769bde&model=OVER_TIME", {
  method: "GET",
  headers: {
    "Authorization": "Bearer YOUR_ACCESS_TOKEN"
  }
});

import requests

response = requests.get(
    "https://leadtime.app/api/public/insights/workload-chart?projectIds=7acff2df-a904-4323-adcc-c2f24a769bde&model=OVER_TIME",
    headers={
        "Authorization": "Bearer YOUR_ACCESS_TOKEN"
    },
)

{
  "detailed": {
    "headers": [
      "Period Label",
      "Tasks"
    ],
    "rows": [
      {
        "Period Label": "Jan 2024",
        "Tasks": 45
      },
      {
        "Period Label": "Feb 2024",
        "Tasks": 52
      }
    ],
    "title": {
      "main": "Workload Insights: Project Name",
      "subtitle": "Over Time, Breakdown by Task Type, Jan 2024 - Dec 2024, By Months"
    }
  },
  "metadata": {
    "hasMoreData": false,
    "periodsGenerated": 12,
    "queryExecutionTime": 234,
    "totalTasksProcessed": 1000
  },
  "summary": {
    "headers": [
      "Period Label",
      "Tasks"
    ],
    "rows": [
      {
        "Period Label": "Jan 2024",
        "Tasks": 45
      },
      {
        "Period Label": "Feb 2024",
        "Tasks": 52
      }
    ],
    "title": {
      "main": "Workload Insights: Project Name",
      "subtitle": "Over Time, Breakdown by Task Type, Jan 2024 - Dec 2024, By Months"
    }
  }
}