Timesheet Details

Retrieve details of posted timesheets

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areatime.json
GeneralYesParameters described in overviewuser=user&password=user&version=3.8v3.8 Overview
Model StructureYesName of model requiredmodelstructure=timesheetdetailsUsing data models
ViewNoStored filter appliedUsing views
SortNoChange the view's default sort ordersort=CLIENTSorting
FiltersNoFilter by a key fieldFilters
CompanyYesThe company numbercompany=1

Example request:

http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetdetails&user=user&password=user&company=1&job=1/00000482&version=3.8

http://192.168.0.239/jsonapi/time.json?style=modeldata&modelstructure=timesheetdetails&user=user&password=user&company=1&job=1/00000482&version=3.8

Example response:

{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 2,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"synversion": "12.8",
"synapiversion": 3.8,
"data": [
{
"tsUuid": "4BC01DB3BFE748C18227991417E22098",
"tsTimestampModified": 1385821328,
"tsRecordVersionNumber": 0,
"tsTimesheetsInternal": 384,
"tsJobAndPhase": "1/00000482.001",
"tsPhaseDescription": "Concept",
"tsStageCode": "",
"tsStageDescription": "",
"tsTaskDesc": "",
"tsChargeCode": "1/PPTDES",
"tsChargeCodeDescription": "Powerpoint Designer",
"tsTimeDate": "2000-12-14",
"tsResourceCode": "1/ATJ",
"tsResource": "Alan Prover",
"tsSalesInvNo": "",
"tsHoursTotal": 8,
"tsHoursNormal": 8,
"tsHoursOtime1": 0,
"tsHoursOtime2": 0,
"tsWorkDone": "Designed the new logo",
"tsChargeType": "",
"tsHoursCharge": 400,
"tsCostType": "",
"tsHoursCost": 160,
"tsApprovalNotes": "",
"tsTransferHistory": "",
"tsTickoffType": "",
"tsTransferredFrom": "",
"tsClientCode": "1/N001",
"tsClientName": "Nike Footwear long name for now1",
"tsJobDescription": "London Special",
"tsLocalDate": "0000-00-00",
"tsLocalTime": "00:00:00",
"tsLocalTimezone": "",
"tsLocalTimezoneOffset": 0,
"tsStartTimeNormal": "00:00:00",
"tsEndTimeNormal": "00:00:00",
"tsStartTimeOT1": "00:00:00",
"tsEndTimeOT1": "00:00:00",
"tsStartTimeOT2": "00:00:00",
"tsEndTimeOT2": "00:00:00"
},