DownloadExpenseReceipt
Returns the receipt attached to the expense.
Stored Procedures Specific Information
Process of Download Expense Receipt
Zoho Books allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only the = comparison. The available columns for DownloadExpenseReceipt are ExpenseId and FileLocation.
For example:
EXECUTE DownloadExpenseReceipt ExpenseId = '1894553000000092001', FileLocation = 'C:/zohobooks'
Input
| Name | Type | Required | Accepts Output Streams | Description |
| ExpenseId | String | True | False | Id of an expense. |
| FileLocation | String | False | False | The folder path to download the file to. |
| ExportFormat | String | False | False | The format of the document to download (HTML or markdown).
The default value is html. |
| AsZip | String | False | False | Download the file or folder in a zip format. |
| Encoding | String | False | False | The FileData input encoding type.
The allowed values are NONE, BASE64. The default value is BASE64. |
| FileStream | String | False | True | An instance of an output stream where file data is written to. Only used if FileLocation is not provided. |
Result Set Columns
| Name | Type | Description |
| Status | String | Stored procedure execution status. |
| FileData | String | If the FileLocation and FileStream are not provided, this contains the content of the file. |