Timesheet list

List of posted timesheets

If you wish to access multiple timesheet records you would normally use the timesheetslist 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=timesheetslist
Response	Returned data	See below

Multi-value filters
It's possible to include multiple values for companies & Resources

Example request:

Request for data (list of records using specified model)

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

Example of querying for multiple companies

http://SERVER/jsonapi/time.json?style=modeldata&modelstructure=timesheetslist&user=user&password=user&company=[1,2,3]&version=3.3

Example of querying for multiple resources

http://<SERVER>/jsonapi/time.json?style=modeldata&modelstructure=timesheetslist&user=user&password=user&company=2&resource=["1/MP","1/KW"]&version=3.3

Example response:

{
  "responsecode": 1,
  "responsestatus": "OK",
  "errorcode": 0,
  "errormessage": "",
  "totalrows": 71,
  "totalpages": 1,
  "responsemessage": "",
  "pagerows": 0,
  "pagenumber": 1,
  "success": true,
  "data": [
    {
      "tsUuid": "A8D692ED323F4A468A4EE3737562A343",
      "tsTimestampModified": 1385821353,
      "tsRecordVersionNumber": 0,
      "tsJobAndPhase": "16/1600021.001",
      "tsPhaseDescription": "Wbsite overhaul",
      "tsStageCode": "",
      "tsStageDescription": "",
      "tsTaskDesc": "",
      "tsChargeCode": "16/BRT",
      "tsChargeCodeDescription": "Business Research Time",
      "tsTimeDate": "2012-01-30",
      "tsResourceCode": "16/JSQ",
      "tsResource": "SYN_John",
      "tsSalesInvNo": "1600003",
      "tsHoursTotal": 1,
      "tsHoursNormal": 1,
      "tsHoursOtime1": 0,
      "tsHoursOtime2": 0,
      "tsWorkDone": ""
    },
    {etc. etc.