List posted timesheets
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=timesheetslist | 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:
http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetslist&user=user&password=user&company=1&job=1/00000482&version=3.9
Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 2,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"synapiversion": 3.8,
"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",
"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"
},