Extract planned hours from the Workload Balancer using an API? | Community
Skip to main content
_Manish_Singh
_Manish_Singh
Level 9
December 4, 2023
Solved

Extract planned hours from the Workload Balancer using an API?

  • December 4, 2023
  • 1 reply
  • 524 views

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

Hours in the blue boxes:

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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

1 reply

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity AdvisorAccepted solution
Community Advisor
December 4, 2023

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

    Terms & ConditionsAccessibility statement

    Loading footer...