...
query-utilization
Parameters
- from (Required). Date from which utilization is required.
- to (Required). Date till which utilization is required.
- project_phase_id (Optional). Only include data for projects with these phase ids.
- zoom (Optional). Groups utilization data by day, week or month (the default). Valid values: 5 for Day, 3 for Week and 2 for Month.
- user_id (Optional). You can mention the user ID, email address or name here.
| Info |
|---|
|
Return values
In case of XML data format, you will be returned an XML string with two elements: count (the number of rows) and rows (this will contain multiple row elements). For instance,
| Code Block | ||
|---|---|---|
| ||
<result>
<rows>
<row>
<f>
<v>62237</v><!--ID of the resource-->
<n>resource_id</n>
</f>
<f>
<v>Martha Young</v> <!-- Name of the resource-->
<n>resource_name</n>
</f>
<f>
<v>3502553</v><!-- ID of the task-->
<n>task_id</n>
</f>
<f>
<v>Start production of commercial product quantities</v> <!-- Name of the task-->
<n>task_name</n>
</f>
<f>
<v>35</v> <!-- %Complete of the task-->
<n>task_pc</n>
</f>
<f>
<v>86780</v> <!-- ID of the project-->
<n>project_id</n>
</f>
<f>
<v>Build v89.986 Register</v> <!-- Name of the project-->
<n>project_name</n>
</f>
<f>
<v>0</v> <!-- % Complete of the project-->
<n>project_pc</n>
</f>
<f>
<v>In Progress</v> <!-- Phase of the project-->
<n>project_phase_name</n>
</f>
<f>
<v>Risk Management</v> <!-- Category of the project-->
<n>project_category_name</n>
</f>
<f>
<v>DAGS</v> <!-- Client of the Project-->
<n>client_root_name</n>
</f>
<f>
<v>12690</v> <!-- Available minutes for this resource in this period taking into account holidays &and vacations-->
<n>availability</n>
</f>
<f>
<v>480</v> <!-- Planned minutes for this task for this period for this resource -->
<n>planned</n>
</f>
<f>
<v>2000</v><!--Estimated billing for this task for this period for this resource-->
<n>estimated_labour_billing</n>
</f>
<f>
<v>600</v><!--Estimated labor cost for this task for this period for this resource-->
<n>estimated_labour_cost</n>
</f>
<f>
<v>2013-01-01T00:00:00</v> <!--start date of the period--><--This is important when the Zoom is day so that you see the planned minutes on the task for that date-->
<n>period_start</n>
</f>
<f>
<v>65</v> <!-- Actual minutes for this task for this period for this resource-->
<n>actual</n>
</f>
<f>
<v>650</v> <!-- Actual cost for this task for this period for this resource-->
<n>actual_time_cost</n>
</f>
<f>
<v>0</v> <!-- Actual billable amount for this task for this period for this resource-->
<n>actual_time_billable_amount</n>
</f>
<f>
<v>0</v><!-- Actual expense amount for this task for this period for this resource-->
<n>actual_expense_cost</n>
</f>
<f>
<v>0</v><!-- Actual billable expense amount for this task for this period for this resource-->
<n>actual_expense_billable_amount</n>
</f>
</row>
</rows>
</result>
|
...