ODBC Driver for Zoho Books

Build 23.0.8839

DownloadAttachment

Returns the file attached to the invoice.

Stored Procedures Specific Information

Process of Download Attachment

Zoho Books allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. For example:

EXECUTE DownloadAttachment SourceId = '1894553000000091007', SourceType = 'invoices', FileLocation = 'C:/zohobooks'

Input

Name Type Required Description
SourceId String True Id of categories like Invoices, Purchase Orders, Bills, SalesOrders.
SourceType String True Type of source

使用できる値は次のとおりです。invoices, purchaseorders, bills, salesorders

FileLocation String False The folder path to download the file to.
Encoding String False The FileData input encoding type.

使用できる値は次のとおりです。NONE, BASE64

デフォルト値は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 23.0.8839