| Parameter | Mandatory | Description | Examples | More Info |
|---|---|---|---|---|
| API | Yes | The API area | tspending.json | |
| General | Yes | Parameters described in overview | see overview | Structure of an API call |
| Company | Yes | The company number | company=1 | |
| Action | Yes | The action to perform | action=timesheetweekly | |
| Date | Yes | Date | date=2019-07-23 | |
| Resource | Yes | Resource code | resource=1/ME | |
| Chargecode | No | Charge code | chargecode=1/AA | |
| Jobphase | No | Job and phase | jobphase=1/00008321.001 |
Example request:
http://<SERVER>/jsonapi/tspending.json?user=user&password=user&version=3.9&action=timesheetweekly&company=1&date=2018-03-08&resource=1/jon
Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 3,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"tspTswChargeCode": "1/Artwo",
"tspTswChargeName": "Artwork & Director",
"tspTswclientCode": "1/BLOGGS",
"tspTswclientName": "Barclaycard Merchant 3",
"tspTswDay0": 0,
"tspTswDay0Date": "2018-03-05",
"tspTswDay0Edittable": false,
"tspTswDay0Entryno": 0,
"tspTswDay0Materials": "",
"tspTswDay0Ot1": 0,
"tspTswDay0Ot2": 0,
"tspTswDay0Status": "X",
"tspTswDay0WorkDone": "",
"tspTswDay1": 0,
"tspTswDay1Date": "2018-03-06",
"tspTswDay1Edittable": false,
"tspTswDay1Entryno": 0,
"tspTswDay1Materials": "",
"tspTswDay1Ot1": 0,
"tspTswDay1Ot2": 0,
"tspTswDay1Status": "X",
"tspTswDay1WorkDone": "",
"tspTswDay2": 0,
"tspTswDay2Date": "2018-03-07",
"tspTswDay2Edittable": false,
"tspTswDay2Entryno": 0,
"tspTswDay2Materials": "",
"tspTswDay2Ot1": 0,
"tspTswDay2Ot2": 0,
"tspTswDay2Status": "X",
"tspTswDay2WorkDone": "",
"tspTswDay3": 0,
"tspTswDay3Date": "2018-03-08",
"tspTswDay3Edittable": false,
"tspTswDay3Entryno": 0,
"tspTswDay3Materials": "",
"tspTswDay3Ot1": 0,
"tspTswDay3Ot2": 0,
"tspTswDay3Status": "X",
"tspTswDay3WorkDone": "",
"tspTswDay4": 0,
"tspTswDay4Date": "2018-03-09",
"tspTswDay4Edittable": false,
"tspTswDay4Entryno": 0,
"tspTswDay4Materials": "",
"tspTswDay4Ot1": 0,
"tspTswDay4Ot2": 0,
"tspTswDay4Status": "X",
"tspTswDay4WorkDone": "",
"tspTswDay5": 0,
"tspTswDay5Date": "2018-03-10",
"tspTswDay5Edittable": false,
"tspTswDay5Entryno": 0,
"tspTswDay5Materials": "",
"tspTswDay5Ot1": 0,
"tspTswDay5Ot2": 0,
"tspTswDay5Status": "X",
"tspTswDay5WorkDone": "",
"tspTswDay6": 0,
"tspTswDay6Date": "2018-03-11",
"tspTswDay6Edittable": false,
"tspTswDay6Entryno": 0,
"tspTswDay6Materials": "",
"tspTswDay6Ot1": 0,
"tspTswDay6Ot2": 0,
"tspTswDay6Status": "X",
"tspTswDay6WorkDone": "",
"tspTswEdittable": false,
"tspTswJobPhase": "1/00000051.027",
"tspTswJobPhaseDescription": "Wizzy Wizzy line 1 - This is a global description. 1 ",
"tspTswNormalShow": true,
"tspTswOt1Show": true,
"tspTswOt2Show": true,
"tspTswRemovable": true,
"tspTswTaskDesc": "",
"tspTswTimerDateNormal": "0000-00-00",
"tspTswTimerDateOt1": "0000-00-00",
"tspTswTimerDateOt2": "0000-00-00",
"tspTswTimerEntrynoNormal": 0,
"tspTswTimerEntrynoOt1": 0,
"tspTswTimerEntrynoOt2": 0,
"tspTswTimerStatusNormal": "",
"tspTswTimerStatusOt1": "",
"tspTswTimerStatusOt2": "",
"tspTswTimerTimeNormal": 0,
"tspTswTimerTimeOt1": 0,
"tspTswTimerTimeOt2": 0,
"tspTswTotal": 0,
"tspTswTotalOt1": 0,
"tspTswTotalOt2": 0,
"tspTswUnique": "1/00000051.027###1/Artwo",
"tspTswUnique0Edittable": false,
"tspTswUnique1Edittable": false,
"tspTswUnique2Edittable": false,
"tspTswUnique3Edittable": false,
"tspTswUnique4Edittable": false,
"tspTswUnique5Edittable": false,
"tspTswUnique6Edittable": false,
"tspTswuserJobuuid": "DAB2A466DCE9AA44A4147CEB0500D791",
"tspTswWorkflow": "",
"tspTswWorkflowDescription": "",
"tspTswWorkflowIntegrated": false
},
{ etc. etc.