Expense sheet list

Expense Sheet List

<tr>
  <td>Action</td>
  <td>Expense Sheet List</td>
  <td>&amp;action=expensesheetlist</td>
</tr>

<tr>
  <td>General</td>
  <td>Parameters described in overview</td>
  <td>user=user&amp;password=user&amp;version=3.2</td>
</tr>

<tr>
  <td>
    <input mandatory>Expense ID:
  </td>
  <td>Expense Sheet ID</td>
  <td>&amp;expensesheet=1234</td>
</tr>

<tr>
  <td>OR</td>
</tr>

<tr>
  <td>
    <input mandatory>UUID:
  </td>
  <td>Expense Sheet UUID</td>
  <td>&amp;uuid=1234567489</td>
</tr>

Parameter	Description	Examples
API	The API area	expensesheets.json

Example requests:
Request to list an expense sheet

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

Request to list multiple expense sheets

http://<SERVER>/jsonapi/expensesheets.json?user=user&password=user&version=3.3&action=expensesheetlist&company=1

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