Timesheet List

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 (OAuth 2.0):

Authorization: Bearer <access_token>
http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetslist&&company=1&job=1/00000482&version=6

Example request (legacy username/password):

http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetslist&&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,
  "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"
    }
  ]
}

CSVrequest:

This call will return the same data as above but as a simple downloaded CSV file

If "modelstructure=view", and a view number also specified, the CSV will contain the columns associated with the view - rather than a standard model

Authorization: Bearer <access_token>
http://<SERVER>/csvapi/time.csv?style=modeldata&modelstructure=timesheetslist&&company=1&job=1/00000482&version=6

Example request (legacy username/password):

http://<SERVER>/csvapi/time.csv?style=modeldata&modelstructure=timesheetslist&&company=1&job=1/00000482&version=6&user=<username>&password=<password>