Tableau Connector for Zoho Books

Build 24.0.9060

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 Description
ExpenseId String True Id of an expense.
FileLocation String False The folder path to download the file to.
ExportFormat String False The format of the document to download (HTML or markdown).

The default value is html.

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

The allowed values are NONE, BASE64.

The default value is BASE64.

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060