Time sheets that have been submitted for approval by the user, but are not yet posted to a job
List pending timesheets
Retrieve a list of pending timesheets
Parameter | Description | Examples |
---|---|---|
API | The API area | tspending.json |
Action | Defines the API endpoint | action=timesheetpendinglist |
Parameters described in overview | user=user&password=user&version=3.3 | |
Filter by resource | resource=1/jon | |
Date | Date filter | date=2018-06-26 |
Filtering the list
Key field filters
Example request:
Request to list pending timesheets
Statuses
P – Posted … (if in process of being posted)
A - Approved
Q - Queried
R - rejected
H - held
W – web/pending/default status (not included in this API return data)
http://<SERVER>/jsonAPI/tspending.json?user=user&password=user&version=3.3&company=1&resource=1/jon&action=timesheetpendinglist
Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 14,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"tspUuid": "543EE014124AFF45B8DC97A460B666B8",
"tspTimeStampModified": 1528456578,
"tspRecordVersionNumber": 0,
"tspApprovalStatus": "W",
"tspChargeCode": "1/HK",
"tspComplete": "",
"tspDiaryInternal": 0,
"tspEntryNo": 3608,
"tspHoursNormal": 1,
"tspHoursOtime1": 0,
"tspHoursOtime2": 0,
"tspJobAndPhase": "1/VJH.001",
"tspMaterialCode": "",
"tspMatQuantity": 0,
"tspTaskDescription": "",
"tspTimeDate": "2018-06-07",
"tspWorkDone": "",
"tspStageCode": "",
"tspApprovalStatusName": "Unsubmitted",
"tspChargeCodeDescription": "Creative Design",
"tspApproverNotes": "",
"tspCompleteStages": false,
"tspCopy": "Y",
"tspDelete": "Y",
"tspEdit": "N",
"tspMaterials": 0,
"tspMovestages": false,
"tspSubmit": "Y",
"tspSubmitterNotes": "",
"tspTimerElapsedNormal": 0,
"tspTimerElapsedOt1": 0,
"tspTimerElapsedOt2": 0,
"tspTimerStatusNormal": "",
"tspTimerStatusOt1": "",
"tspTimerStatusOt2": "",
"tspPhaseDescription": "Cancel and write off",
"tspJobPhaseNumberSimple": "VJH.001",
"tspClientCode": "1/BEACHGOL",
"tspJobClientName": "13th Beach Golf Resort (Base)",
"tspPhaseJobDescription1stline": "Cancel and write off",
"tspStageCurrentDescription": "",
"tspMatDescription": "",
"tspStageDescription": ""
}
]
}