Using the expense lines API.
| Parameter | Mandatory | Description | Examples | More Info |
|---|---|---|---|---|
| API | Yes | The API area | expensesheets.json | |
| General | Yes | Parameters described in overview | user=user&password=user&version=3.8 | v3.8 Overview |
| Action | Yes | The action to perform | action=companylist | |
| Rows | No | Number of records | rows=1 | |
| Pages | No | Number of pages | page=1 |
Example request:
http://<SERVER>/jsonapi/expenselines.json?user=user&password=user&version=3.8&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"
}
]
}