expensesheetlist
| Parameter | Type |
|---|---|
| Company | String |
| Action | String |
| Supplier | String |
| Datefrom [OPTIONAL] | Date |
| Dateto [OPTIONAL] | Date |
| Input [OPTIONAL] | String |
| View [OPTIONAL] | String |
| Response | XML / JSON |
Description
Calling the expenses API with an action of expensesheetlist retrieves a list of expense sheet entries. If supplier parameter = -1 then all expense sheets for all the users expense accounts will be returned in data.
Return Values
Response – List of expense sheets.
The structure of the response is:
<expensesheets morepages="False" totalpages="1" totalrows="1">
<expensesheet>
<array_expensesheetapprove>false</array_expensesheetapprove>
<array_expensesheetapproved>0</array_expensesheetapproved>
<array_expensesheetcopy>true</array_expensesheetcopy>
<array_expensesheetcreateddatetime>11/12/2013 11:35am</array_expensesheetcreateddatetime>
<array_expensesheetdatetime>12/11/2014 (GMT)</array_expensesheetdatetime>
<expensesheet_sheetdate>2013-12-11</expensesheet_sheetdate>
<array_expensesheetsuppliername>Jo Bloggs</array_expensesheetsuppliername>
<array_expensesheetsuppliercode>1/JB</array_expensesheetsuppliercode>
<array_expensesheetdelete>true</array_expensesheetdelete>
<expensesheet_description/>
<array_expensesheetgross>200</array_expensesheetgross>
<array_expensesheetheld>0</array_expensesheetheld>
<expensesheet_expensesheetinternal>645</expensesheet_expensesheetinternal>
<array_expensesheetlines>1</array_expensesheetlines>
<array_expensesheetlinesapproved>0</array_expensesheetlinesapproved>
<array_expensesheetlinesheld>0</array_expensesheetlinesheld>
<array_expensesheetlinesquery>0</array_expensesheetlinesquery>
<array_expensesheetlinesreject>0</array_expensesheetlinesreject>
<array_expensesheetlinessubmitted>1</array_expensesheetlinessubmitted>
<array_expensesheetpost>false</array_expensesheetpost>
<array_expensesheetprocess>false</array_expensesheetprocess>
<array_expensesheetqueried>0</array_expensesheetqueried>
<array_expensesheetrejected>0</array_expensesheetrejected>
<array_expensesheetreturn>false</array_expensesheetreturn>
<expensesheet_sheetstatuscode>unsubmitted</expensesheet_sheetstatuscode>
<array_expensesheetstatusdatetime>00/00/0000</array_expensesheetstatusdatetime>
<array_expensesheetsubmit>true</array_expensesheetsubmit>
<array_expensesheetsubmitted>200</array_expensesheetsubmitted>
<array_expensesheetunapprove>false</array_expensesheetunapprove>
<array_expensesheetvat>0</array_expensesheetvat>
</expensesheet>
</expensesheets>
{
"errormessage": "",
"responsecode": 1,
"pagerows": 0,
"totalrows": 1,
"responsestatus": "OK",
"success": true,
"responsemessage": "",
"errorcode": 0,
"totalpages": 1,
"pagenumber": 1,
"data": [
{
"array_expensesheetlinesheld": 0,
"array_expensesheetapprove": false,
"array_expensesheetrejected": 0,
"array_expensesheetcreateddatetime": "11/12/2013 11:35am",
"array_expensesheetdatetime": "11/12/2013 (GMT)",
"array_expensesheetprocess": false,
"array_expensesheetlinesapproved": 0,
"array_expensesheetheld": 0,
"expensesheet_expensesheetinternal": "645",
"array_expensesheetapproved": 0,
"array_expensesheetlines": 1,
"array_expensesheetdelete": true,
"array_expensesheetqueried": 0,
"array_expensesheetlinessubmitted": 1,
"expensesheet_sheetdate": "2013-12-11",
"array_expensesheetcopy": true,
"array_expensesheetreturn": false,
"array_expensesheetstatusdatetime": "00/00/0000",
"array_expensesheetlinesreject": 0,
"expensesheet_description": "",
"array_expensesheetgross": 200,
"array_expensesheetpost": false,
"array_expensesheetlinesquery": 0,
"expensesheet_sheetstatuscode": "unsubmitted",
"array_expensesheetsuppliername": "Jo Bloggs",
"array_expensesheetsuppliercode": "1/JB",
"array_expensesheetsubmit": true,
"array_expensesheetsubmitted": 200,
"array_expensesheetunapprove": false,
"array_expensesheetvat": 0
}
]
}