Timesheet list

List posted timesheets

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.