Parameter	Mandatory	Description	Examples	More Info
API	Yes	The API area	expensesheets.json
General	Yes	Parameters described in overview	user=user&password=user	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:

http://<SERVER>/jsonapi/expensesheets.json?user=user&password=user&version=4&action=expensesheetlist&expensesheet=[960,962]

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
}
]
}