Lists multiple expense sheets.
Expense Sheet List Multi
| Parameter | Mandatory | Description | Examples | More Info |
|---|---|---|---|---|
| API | Yes | The API area | expensesheets.json | |
| General | Yes | Parameters described in overview | Authorization: Bearer <access_token> header — see Synergist API Authentication | Structure of an API call |
| Action | Yes | The action to perform | action=expensesheetlist | |
| Identifier | Yes | Expense sheet ID or UUID | expensesheet=[960,962] |
Example request (OAuth 2.0):
Authorization: Bearer <access_token>
http://<SERVER>/jsonapi/expensesheets.json?&version=6&action=expensesheetlist&expensesheet=[960,962]Example request (legacy username/password):
http://<SERVER>/jsonapi/expensesheets.json?&version=6&action=expensesheetlist&expensesheet=[960,962]&user=<username>&password=<password>Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 2,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"expensesheetApprove": false,
"expensesheetApproved": 0,
"expensesheetCopy": true,
"expensesheetCreatedDateTime": "23/09/2020 11:47am",
"expensesheetDate": "2020-09-23",
"expensesheetDateTime": "23/09/2020",
"expensesheetDelete": true,
"expensesheetDescription": "",
"expensesheetGross": 111,
"expensesheetHeld": 0,
"expensesheetInternalRef": "962",
"expensesheetLines": 1,
"expensesheetLinesApproved": 0,
"expensesheetLinesHeld": 0,
"expensesheetLinesQuery": 0,
"expensesheetLinesReject": 0,
"expensesheetLinesSubmitted": 1,
"expensesheetPost": false,
"expensesheetProcess": false,
"expensesheetQueried": 0,
"expensesheetRejected": 0,
"expensesheetReturn": false,
"array_expensesheetscapproved": 0,
"array_expensesheetscgross": 111,
"array_expensesheetscheld": 0,
"array_expensesheetscqueried": 0,
"array_expensesheetscrejected": 0,
"array_expensesheetscsubmitted": 111,
"array_expensesheetscvat": 0,
"expensesheetCurrencyCode": "",
"expensesheetCurrencyExchangeRate": 1,
"expensesheetStatusCode": "unsubmitted",
"expensesheetStatusDateTime": "00/00/0000",
"expensesheetSubmit": true,
"expensesheetSubmitted": 111,
"expensesheetTheSupplierCode": "1/USER",
"expensesheetSupplierName": "User Expenses",
"expensesheetUnApprove": false,
"expensesheetTax": 0
},
{
"expensesheetApprove": false,
"expensesheetApproved": 0,
"expensesheetCopy": true,
"expensesheetCreatedDateTime": "10/06/2020 5:30pm (EST)",
"expensesheetDate": "2020-06-10",
"expensesheetDateTime": "10/06/2020 (EST)",
"expensesheetDelete": true,
"expensesheetDescription": "",
"expensesheetGross": 5,
"expensesheetHeld": 0,
"expensesheetInternalRef": "960",
"expensesheetLines": 1,
"expensesheetLinesApproved": 0,
"expensesheetLinesHeld": 0,
"expensesheetLinesQuery": 0,
"expensesheetLinesReject": 0,
"expensesheetLinesSubmitted": 1,
"expensesheetPost": false,
"expensesheetProcess": false,
"expensesheetQueried": 0,
"expensesheetRejected": 0,
"expensesheetReturn": false,
"array_expensesheetscapproved": 0,
"array_expensesheetscgross": 0,
"array_expensesheetscheld": 0,
"array_expensesheetscqueried": 0,
"array_expensesheetscrejected": 0,
"array_expensesheetscsubmitted": 0,
"array_expensesheetscvat": 0,
"expensesheetCurrencyCode": "",
"expensesheetCurrencyExchangeRate": 1,
"expensesheetStatusCode": "unsubmitted",
"expensesheetStatusDateTime": "00/00/0000",
"expensesheetSubmit": true,
"expensesheetSubmitted": 5,
"expensesheetTheSupplierCode": "1/USER",
"expensesheetSupplierName": "User Expenses",
"expensesheetUnApprove": false,
"expensesheetTax": 0.83
}
]
}