Material Sheet Weekly

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 (OAuth 2.0):

Authorization: Bearer <access_token>
http://<SERVER>/jsonapi/tspending.json?&version=6&action=materialsheetweekly&company=1&date=2017/05/03&resource=1/jon&jobphase=1/00008946.001&chargecode=1/ah

Example request (legacy username/password):

http://<SERVER>/jsonapi/tspending.json?&version=6&action=materialsheetweekly&company=1&date=2017/05/03&resource=1/jon&jobphase=1/00008946.001&chargecode=1/ah&user=<username>&password=<password>

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": ""
    }
  ]
}