Lists expense sheet line.
Parameter | Mandatory | Description | Examples | More Info |
---|---|---|---|---|
API | Yes | The API area | expenselines.json | |
General | Yes | Parameters described in overview | user=user&password=user | Structure of an API call |
Company | Yes | The company number | company=1 | |
Action | Yes | The action to perform | action=expensesheetlines | |
Identifier | Yes | Expense line ID or UUID | expenseline=2093 |
Example request:
http://<SERVER>/jsonapi/expensesheets.json?user=user&password=user&version=3.9&action=expensesheetlines&expensesheet=2093
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,
"expenselineUuid": "7918A8534D5C0F43BF2F1F933A5CED66",
"expenselineValuesEdit": false,
"expenselineTaxCode": 2,
"expenselineTaxAmount": 2.47,
"expenselineStageCode": "",
"expenselineStageDescription": ""
}
]
}