Expense Sheet List Single

Lists a single expense sheet.

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areaexpensesheets.json
GeneralYesParameters described in overviewSee overviewStructure of an API call
ActionYesThe action to performaction=expensesheetlist
IdentifierYesExpense sheet ID or UUIDexpensesheet=1234

Example request:

http://<SERVER>/jsonapi/expensesheets.json?user=user&password=user&version=3.9&action=expensesheetlist&expensesheet=1234

Example response:

{
  "responsecode": 1,
  "responsestatus": "OK",
  "errorcode": 0,
  "errormessage": "",
  "totalrows": 1,
  "totalpages": 1,
  "responsemessage": "",
  "pagerows": 0,
  "pagenumber": 1,
  "success": true,
  "data": [
    {
      "expensesheetApprove": false,
      "expensesheetApproved": 0,
      "expensesheetCopy": true,
      "expensesheetCreatedDateTime": "14/10/2014 1:46pm",
      "expensesheetDate": "2014-10-14",
      "expensesheetDateTime": "14/10/2014",
      "expensesheetDelete": true,
      "expensesheetDescription": "",
      "expensesheetGross": 249.09,
      "expensesheetHeld": 0,
      "expensesheetInternalRef": "1234",
      "expensesheetLines": 1,
      "expensesheetLinesApproved": 0,
      "expensesheetLinesHeld": 0,
      "expensesheetLinesQuery": 0,
      "expensesheetLinesReject": 0,
      "expensesheetLinesSubmitted": 1,
      "expensesheetPost": false,
      "expensesheetProcess": false,
      "expensesheetQueried": 0,
      "expensesheetRejected": 0,
      "expensesheetReturn": false,
      "expensesheetStatusCode": "unsubmitted",
      "expensesheetStatusDateTime": "00/00/0000",
      "expensesheetSubmit": false,
      "expensesheetSubmitted": 249.09,
      "expensesheetTheSupplierCode": "1/jg",
      "expensesheetSupplierName": "Josephine Grantx",
      "expensesheetUnApprove": false,
      "array_expensesheetvat": 32.49
    }
  ]
}