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=tspendingdetails	Using data models
Filters	No	Filter by a key field		Filters
TsPending	No	Pending timesheet ID	tspending=794
Company	Yes	The company number	company=1

Example request:

http://<SERVER>/jsonAPI/tspending.json?user=user&password=user&version=4&company=1&tspending=794&modelstructure=tspendingdetails

Example response:

{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 1,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"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,
"tspApprovalStatus": "W",
"tspApprovalNotes": "",
"tspApprovalNotesReSubmit": "",
"tspWorkDone": "",
"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"
}
]
}