Material Sheet Weekly

Display of the weekly material sheets

Parameter	Description	Examples
API	The API area	tspending.json
Action	Material Sheet Weekly	&action=materialsheetweekly
General	Parameters described in overview	user=user&password=user&version=3.3
Company	The company context	&company=1
Resource:	User Code	&resource=1/ME
Date:	Date	&date=2018/01/08
Jobphase	Job Phase	&jobphase=1/00000523.001
Chargecode	Charge Code	&chargecode=1/AA

Example request: Request to show a material sheet

http://<SERVER>/jsonapi/tspending.json?user=user&password=user&version=3.3&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": ""
}
]
}