Expense Sheet Lines

Requests to retrieve expense sheet lines.

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areaexpensesheets.json
GeneralYesParameters described in overviewuser=user&password=user&version=3.7v3.7 Overview
ActionYesThe action to performaction=expensesheetlines
IdentifierYesExpense sheet ID or UUIDexpensesheet=2077

Example request:

http://<SERVER>/jsonapi/expensesheets.json?user=user&password=user&version=3.7&action=expensesheetlines&expensesheet=2077

Example response:

{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 1,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"expenselineApprove": false,
"expenselineApproversNotes": "",
"expenselineAttachmentDelete": false,
"expenselineAttachmentUpload": false,
"expenselineAttachmentView": false,
"expenselineTheClientCode": "16/DHPORTA",
"expenselineClientName": "Ace Electronics",
"expenselineCopy": true,
"expenselineCurrencyCode": "16/EUR",
"expenselineCurrencyDescription": "Euros",
"expenselineCurrencySymbol": "€",
"expenselineCurrencyTotal": 1306.8,
"expenselineCurrencyRate": 39.6,
"expenselineDate": "2020-11-02",
"expenselineDelete": false,
"expenselineDescription": "Electrical Work",
"expenselineEdit": false,
"expenselineExchangeRate": 1.2,
"expenselineHeld": false,
"expenselineInternal": 4030,
"expenselineJobDescription": "Web design",
"expenselineJobAndPhase": "16/0050113.001",
"expenselineJobPhaseSimple": "50113.001",
"expenselineJobPhaseStage": 0,
"expenselineJobPhaseStageDesc": "",
"expenselineJobSimple": "50113",
"expenselineLineNumber": 1,
"expenselinePhaseDescription": "Web design - phase 1",
"expenselineQuantity": 1,
"expenselineQuery": false,
"expenselineReject": false,
"expenselineReSubmit": false,
"expenselineSheetCurrencyGross": 33,
"expenselineSheetCurrencyTax": 2.47,
"expenselineSheetCurrencyUnitCost": 33,
"expenselineStatusCode": "S",
"expenselineStatusDisplay": "Unsubmitted",
"expenselineSubmit": false,
"expenselineSubmitted": false,
"expenselineSubmittersNotes": "",
"expenselineSupplyType": "16/ELE",
"expenselineSupplytypeDesc": "Electrical Work",
"expenselineSupplyTypeMileage": false,
"expenselineTotal": 33,
"expenselineRate": 33,
"expenselineValuesEdit": false,
"expenselineTaxCode": 2,
"expenselineTaxAmount": 2.47,
"expenselineStageCode": "",
"expenselineStageDescription": ""
}
]
}