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.