Material Sheet Weekly

Returns a material sheet.

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areatspending.json
GeneralYesParameters described in overviewuser=user&password=user&version=3.8v3.8 Overview
CompanyYesThe company numbercompany=1
ResourceYesResource coderesource=1/ME
DateYesDatedate=2018/01/08
JobphaseYesJob and phasejobphase=1/00000523.001
ChargecodeYesCharge codechargecode=1/AA
ActionYesThe action to performaction=materialsheetweekly

Example request:

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