Retrieve details of posted timesheets
Details of a posted timesheet
If you wish to access a single timesheet record you would normally use the timesheetdetails model
For timesheets two models are available:
- timesheetslist
- timesheetdetails
Parameter | Description | Examples |
---|---|---|
API | The API area | time.json |
<General> | Parameters described in overview | user=user&password=user&version=3.3 |
Company | The company context | company=1 |
<filter>Job | Job number | job=1/00000482 |
<filter>Jobphase | Job phase number | job=1/00000482.006 |
<filter>date | timesheet date | date="2018-03-22" |
From date | Date filter | datefrom=2018-07-01 |
To date | Date filter | dateto=2018-12-01 |
<Filters> | Filter by a key field | client=1/F667 |
Style | Output style | style=modeldata |
Structure | Model Structure | modelstructure=timesheetdetails |
Response | Returned data | See below |
Example request:
Request for data (list of records using specified model)
http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetdetails&user=user&password=user&company=1&job=1/00000482&version=3.3
Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 2,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"tsUuid": "4BC01DB3BFE748C18227991417E22098",
"tsTimestampModified": 1385821328,
"tsRecordVersionNumber": 0,
"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": ""
}
]
}