Returns a material sheet.
| 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 | |
| Resource | Yes | Resource code | resource=1/ME | |
| Date | Yes | Date | date=2018/01/08 | |
| Jobphase | Yes | Job and phase | jobphase=1/00000523.001 | |
| Chargecode | Yes | Charge code | chargecode=1/AA | |
| Action | Yes | The action to perform | action=materialsheetweekly |
Example request:
http://<SERVER>/jsonapi/tspending.json?user=user&password=user&version=3.9&action=materialsheetweekly&company=1&date=2017/05/03&resource=1/jon&jobphase=1/00008946.001&chargecode=1/ah
Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 1,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"tspMswApproverNotes": "",
"tspMswChargeCode": "1/ah",
"tspMswEntryno": 12957,
"tspMswJobPhase": "1/00008946.001",
"tspMswMaterial": "1/A2CC",
"tspMswMaterialName": "A2 black and white ",
"tspMswMatsheetInternal": 0,
"tspMswPhaseNumberSimple": "8946.001",
"tspMswQuantity": 1,
"tspMswRelation": "1/00008946.001###1/ah#0",
"tspMswStatus": "U",
"tspMswSubmitterNotes": "",
"tspMswTaskDesc": "",
"tspMswWorkflow": ""
}
]
}