Expense Sheet Lines

Requests to retrieve expense sheet lines.

Expense Sheet Lines

ParameterMandatoryDescriptionExamplesMore Info
APIYesThe API areaexpensesheets.json
GeneralYesParameters described in overviewAuthorization: Bearer <access_token> header — see Synergist API AuthenticationStructure of an API call
ActionYesThe action to performaction=expensesheetlines
IdentifierYesExpense sheet ID or UUIDexpensesheet=2077

Example request (OAuth 2.0):

Authorization: Bearer <access_token>
http://&lt;SERVER&gt;/jsonapi/expensesheets.json?&version=6&action=expensesheetlines&expensesheet=2077

Example request (legacy username/password):

http://&lt;SERVER&gt;/jsonapi/expensesheets.json?&version=6&action=expensesheetlines&expensesheet=2077&user=<username>&password=<password>

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": "",
      "expenselineDeptCode": "1/D2",
      "expenselineDeptName": "Design"
    }
  ]
}