JDBC Driver for Zoho Books

Build 22.0.8479


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.

ExpenseId will be ID of an Expense.

FileLocation will be containing the path where the attachment will get downloaded. For example:

EXECUTE DownloadExpenseReceipt ExpenseId = '1894553000000092001', FileLocation = 'C:/zohobooks'


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).


AsZip String False False Download the file or folder in a zip format.
Encoding String False False The FileData input encoding type.

使用できる値は次のとおりです。NONE, 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479