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
Model Structure	Yes	Name of model required	modelstructure=tspendingslist	Using data models
Filters	No	Filter by a key field		Filters
Company	Yes	The company number	company=1

Example request:

http://<SERVER>/jsonapi/tspending.json?user=user&password=user&version=4&modelstructure=tspendingslist&company=1

Example response:

{
  "responsecode": 1,
  "responsestatus": "OK",
  "errorcode": 0,
  "errormessage": "",
  "totalrows": 366,
  "totalpages": 1,
  "responsemessage": "",
  "pagerows": 0,
  "pagenumber": 1,
  "success": true,
  "synapiversion": 3.8,
  "data": [
    {
      "tspUuid": "6DBC2C52E3A24736913D662CDBE5C155",
      "tspTimeStampModified": 1605204840,
      "tspRecordVersionNumber": 37,
      "tspEntryNo": 794,
      "tspJobAndPhase": "1/00001091.001",
      "tspStageCode": "",
      "tspStageDescription": "",
      "tspChargeCode": "1/ART",
      "tspChargeCodeDescription": "Junior Design",
      "tspResourceCode": "1/KAT",
      "tspResourceName": "Katie Heiffer",
      "tspMaterialCode": "",
      "tspMatQuantity": 0,
      "tspHoursNormal": 1.3,
      "tspHoursOtime1": 0,
      "tspHoursOtime2": 0,
      "tspTimeDate": "2006-08-11",
      "tspLocalDate": "0000-00-00",
      "tspLocalTime": "00:00:00",
      "tspLocalTimezone": "",
      "tspLocalTimezoneOffset": 0,
      "tspStartTimeNormal": "00:00:00",
      "tspEndTimeNormal": "00:00:00",
      "tspStartTimeOT1": "00:00:00",
      "tspEndTimeOT1": "00:00:00",
      "tspStartTimeOT2": "00:00:00",
      "tspEndTimeOT2": "00:00:00"
    }
  ]
}

CSV request:

This call will return the same data as above but as a simple downloaded CSV file

If "modelstructure=view", and a view number also specified, the CSV will contain the columns associated with the view - rather than a standard model

http://<SERVER>/csvapi/tspending.csv?user=user&password=user&version=4&modelstructure=tspendingslist&company=1