Timesheet details

Retrieve details of posted timesheets

Details of a posted timesheet

If you wish to access a single timesheet record you would normally use the timesheetdetails 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=timesheetdetails

Response

Returned data

See below

Example request:

Request for data (list of records using specified model)

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

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,
      "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": ""
    }
  ]
}