Timesheetpendinglist
Parameter | Type | Description |
---|---|---|
[IN] Parameters described in Overview | ||
Company | String | [IN] The users default company number for the companies list |
Action | String | [IN] Identifier for the list requested |
Resource | String | [IN] Identifier for the resource context |
Date [Optional] | Date | [IN] dd/mm/yyyy date context |
Response | XML/JSON | [OUT] An XML tree / JSON string containing the list of pending timesheet entries for the resource |
Description
Calling the timesheets API with an action of timesheetpendinglist retrieves a list of timesheet entries.
Entries which can be edited will have variable_timesheetpendingedittspending_entryno =Y
Entries which can be copied will have variable_timesheetpendingcopytspending_entryno =Y
Entries which can be deleted will have variable_timesheetpendingdelete__tspending_entryno=Y
If an entry cannot be copied, edited or deleted then the corresponding variable name will have value of “N”
Entries which can be submitted will have have tspending_approvalstatus=”W”
variable_timesheettimerstatusnormaltspending_entryno denotes whether a time can be started on this entry for normal time. variable_timesheettimerstatusot1tspending_entryno and variable_timesheettimerstatusot2tspending_entryno denote whether timers can be started on this entry for overtime.
variable_timesheettimerelapsednormaltspending_entryno and the equivalent overtime attributes contain the elapsed time from a paused timer.
Return Values
Response – List of pending timesheet entries for the resource context.
The structure of the response is:
<timesheetpendings morepages="False" totalpages="1" totalrows="1">
<timesheetpending tspending_uuid="1DA89261D900A349A24C100D7386997C">
<tspending_approvalstatus>W</tspending_approvalstatus>
<tspending_chargecode>1/SB</tspending_chargecode>
<tspending_complete/>
<tspending_entryno>9767</tspending_entryno>
<tspending_hoursnormal>6.25</tspending_hoursnormal>
<tspending_hoursotime1>0</tspending_hoursotime1>
<tspending_hoursotime2>0</tspending_hoursotime2>
<tspending_jobandphase>1/00000539.005</tspending_jobandphase
tspending_materialcode/>
<tspending_matquantity>0</tspending_matquantity>
<tspending_taskdesc/>
<tspending_timedate>2015-01-22</tspending_timedate>
<tspending_workdone>test note</tspending_workdone>
<tspending_workflowcode/>
<variable_approvalstatusname__tspending_approvalstatus>Unsubmitted</variable_approvalstatusname__tspending_approvalstatus>
<chargecodes_description__tspending_chargecode>Pre Sales </chargecodes_description__tspending_chargecode>
<variable_timesheetpendingapprovernotes__tspending_entryno/>
<variable_timesheetpendingcompletestages__tspending_entryno>true</variable_timesheetpendingcompletestages__tspending_entryno>
<variable_timesheetpendingcopy__tspending_entryno>Y</variable_timesheetpendingcopy__tspending_entryno>
<variable_timesheetpendingdelete__tspending_entryno>Y</variable_timesheetpendingdelete__tspending_entryno>
<variable_timesheetpendingedit__tspending_entryno>Y</variable_timesheetpendingedit__tspending_entryno>
<variable_timesheetpendingmaterials__tspending_entryno>0</variable_timesheetpendingmaterials__tspending_entryno>
<variable_timesheetpendingmovestages__tspending_entryno>true</variable_timesheetpendingmovestages__tspending_entryno>
<variable_timesheetpendingsubmit__tspending_entryno>Y</variable_timesheetpendingsubmit__tspending_entryno>
<variable_timesheetpendingsubmitternotes__tspending_entryno>Material removed</variable_timesheetpendingsubmitternotes__tspending_entryno>
<variable_timesheettimerelapsednormal__tspending_entryno>0</variable_timesheettimerelapsednormal__tspending_entryno>
<variable_timesheettimerelapsedot1__tspending_entryno>0</variable_timesheettimerelapsedot1__tspending_entryno>
<variable_timesheettimerelapsedot2__tspending_entryno>0</variable_timesheettimerelapsedot2__tspending_entryno>
<variable_timesheettimerstatusnormal__tspending_entryno/><variable_timesheettimerstatusot1__tspending_entryno/>
<variable_timesheettimerstatusot2__tspending_entryno/>
<variable_phasenumbersimple__tspending_jobandphase>539.005</variable_phasenumbersimple__tspending_jobandphase>
<variable_clientcode__tspending_jobandphase>1/BASS</variable_clientcode__tspending_jobandphase>
<variable_clientname__tspending_jobandphase>Bass Brewers</variable_clientname__tspending_jobandphase>
<variable_jobdescription1stline__tspending_jobandphase>job desc £899</variable_jobdescription1stline__tspending_jobandphase>
<variable_phasedescription1stline__tspending_jobandphase>job desc £899</variable_phasedescription1stline__tspending_jobandphase>
<variable_stagecurrentdescription__tspending_jobandphase>On Hold</variable_stagecurrentdescription__tspending_jobandphase>
<resources_resourcename__tspending_materialcode/>
<workflow_workflowdescription__tspending_workflowcode/>
</timesheetpending>
</timesheetpendings>
{
"errormessage": "",
"responsecode": 1,
"pagerows": 0,
"totalrows": 1,
"responsestatus": "OK",
"success": true,
"responsemessage": "",
"errorcode": 0,
"totalpages": 1,
"pagenumber": 1,
"data": [
{
"tspending_uuid": "1DA89261D900A349A24C100D7386997C",
"tspending_approvalstatus": "W",
"tspending_chargecode": "1/SB",
"tspending_complete": "",
"tspending_entryno": 9767,
"tspending_hoursnormal": 6.25,
"tspending_hoursotime1": 0,
"tspending_hoursotime2": 0,
"tspending_jobandphase": "1/00000539.005",
"tspending_materialcode": "",
"tspending_matquantity": 0,
"tspending_taskdesc": "",
"tspending_timedate": "2015-01-22",
"tspending_workdone": "test note",
"tspending_workflowcode": "",
"variable_approvalstatusname__tspending_approvalstatus": "Unsubmitted",
"chargecodes_description__tspending_chargecode": "Pre Sales ",
"variable_timesheetpendingapprovernotes__tspending_entryno": "",
"variable_timesheetpendingcompletestages__tspending_entryno": true,
"variable_timesheetpendingcopy__tspending_entryno": "Y",
"variable_timesheetpendingdelete__tspending_entryno": "Y",
"variable_timesheetpendingedit__tspending_entryno": "Y",
"variable_timesheetpendingmaterials__tspending_entryno": 1,
"variable_timesheetpendingmovestages__tspending_entryno": true,
"variable_timesheetpendingsubmit__tspending_entryno": "Y",
"variable_timesheetpendingsubmitternotes__tspending_entryno": "Material removed",
"variable_timesheettimerelapsednormal__tspending_entryno": 0,
"variable_timesheettimerelapsedot1__tspending_entryno": 0,
"variable_timesheettimerelapsedot2__tspending_entryno": 0,
"variable_timesheettimerstatusnormal__tspending_entryno": "",
"variable_timesheettimerstatusot1__tspending_entryno": "",
"variable_timesheettimerstatusot2__tspending_entryno": "",
"variable_phasenumbersimple__tspending_jobandphase": "539.005",
"variable_clientcode__tspending_jobandphase": "1/BASS",
"variable_clientname__tspending_jobandphase": "Bass Brewers",
"variable_jobdescription1stline__tspending_jobandphase": "job desc £899",
"variable_phasedescription1stline__tspending_jobandphase": "job desc £899",
"variable_stagecurrentdescription__tspending_jobandphase": "On Hold",
"resources_resourcename__tspending_materialcode": "",
"workflow_workflowdescription__tspending_workflowcode": ""
}
]
}