Extract planned hours from the Workload Balancer using an API?

[_Manish_Singh]

Is it possible extract Planned Hours from Workload Balancer using an API call? or on a report?

Hours in the blue boxes:

[Rafal_Bainie]

hi,

yes, these numbers are available via both API and reporting, but especially with reporting it requires referencing field you will find in API documentation, but not necessarily in fields selector "workPerDate"

displayname=workPerDate
textmode=true
valuefield=workPerDate

if I remember correctly this is available for assignments and tasks.

you can get the same data using API.

Please note that data for the task/assignment, regardless of task duration will come essentially as single value, in this format:

{2023-12-04=240.0, 2023-12-05=60.0, 2023-12-06=0.0, 2023-12-07=0.0}

date=number of minutes allocated for the date.

If you would like to get the aggregated values it get's more tricky, as you cannot just query the number to my knowledge, but it's still doable with Fusion