Progress API (Power BI)
The progress endpoint exposes completion and progress data for a project. It correspond to the Progress > Tabular (tab) in the SUM-IT web application.
Parameters (template)
These names match the parameters in sum-it-api.pbit. They map to the API as projectId, groupBy, completionDateFrom, and completionDateTo (see the progress query in Power Query).
| Parameter | Required | Description |
|---|---|---|
project_id | Yes | Project id filter used to filter project overview and progress data. |
progress_completion_from_date | No | A task for a unit is returned only when its progress is 100% and the last activity date is on or after this date. This param works only with param 'groupBy' with lowest granularity: ORGANIZATION_ROLE, CONSTRUCTION_STAGE, UNIT_GROUP, TASK, UNIT. Date format: YYYY-MM-DD. Example : 2025-12-01. |
progress_completion_to_date | No | A task for a unit is returned only when its progress is 100% and the last activity date is on or before this date. This param works only with param 'groupBy' with lowest granularity: ORGANIZATION_ROLE, CONSTRUCTION_STAGE, UNIT_GROUP, TASK, UNIT. Date format: YYYY-MM-DD. Example : 2025-12-18. |
progress_group_by | No | Allows to group progress by specific fields. Choose one of the template’s combined values from ORGANIZATION_ROLE, CONSTRUCTION_STAGE, UNIT_GROUP, TASK, UNIT at different levels. Example: ORGANIZATION_ROLE, CONSTRUCTION_STAGE |
Completion date filters (progress_completion_*) behave as intended only when progress_group_by uses the lowest granularity (ORGANIZATION_ROLE, CONSTRUCTION_STAGE, UNIT_GROUP, TASK, UNIT), as defined in the template metadata.
API reference
For more details, please refer to the API documentation: Get progress