Retrieve details of posted timesheets
Timesheet Details
| Parameter | Mandatory | Description | Examples | More Info |
|---|---|---|---|---|
| API | Yes | The API area | time.json | |
| General | Yes | Parameters described in overview | see overview | Structure of an API call |
| Model Structure | Yes | Name of model required | modelstructure=timesheetdetails | Using data models |
| View | No | Stored filter applied | Using views | |
| Sort | No | Change the view's default sort order | sort=CLIENT | Sorting |
| Filters | No | Filter by a key field | Filters | |
| Company | Yes | The company number | company=1 |
Example request (OAuth 2.0):
Authorization: Bearer <access_token>
http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetdetails&&company=1&job=1/00000482&version=6Example request (legacy username/password):
http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetdetails&&company=1&job=1/00000482&version=6&user=<username>&password=<password>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,
"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",
"tsDeptCode": "1/D2",
"tsDeptName": "Design"
}
]
}