Retrieves a list of pending timesheets that have been submitted for approval by the user, but are not yet posted to a job.
| Parameter | Mandatory | Description | Examples | More Info |
|---|---|---|---|---|
| API | Yes | The API area | tspending.json | |
| General | Yes | Parameters described in overview | see overview | Structure of an API call |
| Model Structure | Yes | Name of model required | modelstructure=tspendingslist | Using data models |
| View | No | Stored filter applied | Using views | |
| Filters | No | Filter by a key field | Filters | |
| Company | Yes | The company number | company=1 | |
| Status | Yes | Status of timesheet | status=S |
Example request:
For unsubmitted
http://<SERVER>/jsonapi/tspending.json?user=user&password=user&version=3.9&status=W&company=1&modelstructure=tspendingslist
For submitted
http://<SERVER>/jsonapi/tspending.json?user=user&password=user&version=3.9&status=S&company=1&modelstructure=tspendingslist
Example response:
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 359,
"totalpages": 120,
"responsemessage": "",
"pagerows": 3,
"pagenumber": 1,
"success": true,
"synapiversion": 3.8,
"data": [
{
"tspUuid": "6DBC2C52E3A24736913D662CDBE5C155",
"tspTimeStampModified": 1605204840,
"tspRecordVersionNumber": 37,
"tspEntryNo": 794,
"tspJobAndPhase": "1/00001091.001",
"tspStageCode": "",
"tspStageDescription": "",
"tspChargeCode": "1/ART",
"tspChargeCodeDescription": "Junior Design",
"tspResourceCode": "1/KAT",
"tspResourceName": "Katie Heiffer",
"tspMaterialCode": "",
"tspMatQuantity": 0,
"tspHoursNormal": 1.3,
"tspHoursOtime1": 0,
"tspHoursOtime2": 0,
"tspTimeDate": "2006-08-11",
"tspLocalDate": "0000-00-00",
"tspLocalTime": "00:00:00",
"tspLocalTimezone": "",
"tspLocalTimezoneOffset": 0,
"tspStartTimeNormal": "00:00:00",
"tspEndTimeNormal": "00:00:00",
"tspStartTimeOT1": "00:00:00",
"tspEndTimeOT1": "00:00:00",
"tspStartTimeOT2": "00:00:00",
"tspEndTimeOT2": "00:00:00"
},