Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagehtml/xml
<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 & 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>


 

In case of JSON, it will return an object will have the property rows (which will be an array of objects with n and v properties respectively)

...