Timesheet Pending List

Timesheetpendinglist

ParameterTypeDescription
[IN] Parameters described in Overview
CompanyString[IN] The users default company number for the companies list
ActionString[IN] Identifier for the list requested
ResourceString[IN] Identifier for the resource context
Date [Optional]Date[IN] dd/mm/yyyy date context
ResponseXML/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_timesheetpendingcopy
tspending_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_timesheettimerelapsednormal
tspending_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 &#x00A3;899</variable_jobdescription1stline__tspending_jobandphase>
<variable_phasedescription1stline__tspending_jobandphase>job desc &#x00A3;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 &#x00A3;899",
            "variable_phasedescription1stline__tspending_jobandphase": "job desc &#x00A3;899",
            "variable_stagecurrentdescription__tspending_jobandphase": "On Hold",
            "resources_resourcename__tspending_materialcode": "",
            "workflow_workflowdescription__tspending_workflowcode": ""
        }
    ]
}