Submitted pending timesheets list

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": ""
    }
  ]
}