Expense Lines

Using the expense lines API.

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areaexpensesheets.json
GeneralYesParameters described in overviewuser=user&password=user&version=3.7v3.7 Overview
ActionYesThe action to performaction=companylist
RowsNoNumber of recordsrows=1
PagesNoNumber of pagespage=1

Example request:

http://<SERVER>/jsonapi/expenselines.json?user=user&password=user&version=3.7&company=1

Example response:

{
  "responsecode": 1,
  "responsestatus": "OK",
  "errorcode": 0,
  "errormessage": "",
  "totalrows": 1785,
  "totalpages": 893,
  "responsemessage": "",
  "pagerows": 2,
  "pagenumber": 1,
  "success": true,
  "data": [
    {
      "expenselineUuid": "478D08BA8E014F0F8BF3B76C3CE4C5B3",
      "expenselineTimestampModified": 1385820072,
      "expenselineRecordVersionNumber": 0,
      "expenselineStatus": "Approved",
      "expenselineInternal": 19,
      "expenselineDescription": "Mileage to and from Manchester",
      "expenselineSupplyType": "1/MIL",
      "expenselineSupplyTypeDescription": "Mileagex",
      "expenselineDate": "2002-06-18",
      "expenselineJobAndPhase": "1/00000464.000",
      "expenselineTotal": 9.6,
      "expenselineTaxAmount": 1.43,
      "expenselineStatusCode": "A",
      "expenselineJobAndPhaseNumberSimple": "464.000",
      "expenselineClientCode": "1/A001",
      "expenselineClient": "Proton Cars plc"
    },
    {
      "expenselineUuid": "D76BBC64CA394DAF969684464D2AA66E",
      "expenselineTimestampModified": 1385820072,
      "expenselineRecordVersionNumber": 0,
      "expenselineStatus": "Approved",
      "expenselineInternal": 20,
      "expenselineDescription": "Hotel Expenses night in Manchester",
      "expenselineSupplyType": "1/HOT",
      "expenselineSupplyTypeDescription": "Hotel Expenses1",
      "expenselineDate": "2002-06-18",
      "expenselineJobAndPhase": "1/00000464.000",
      "expenselineTotal": 75,
      "expenselineTaxAmount": 11.17,
      "expenselineStatusCode": "A",
      "expenselineJobAndPhaseNumberSimple": "464.000",
      "expenselineClientCode": "1/A001",
      "expenselineClient": "Proton Cars plc"
    }
  ]
}