SSIS Components for Zoho Books

Build 22.0.8389

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. The available columns for DownloadAttachment are SourceId, SourceType and FileLocation.

SourceId will be the ID of different categories such as Invoices, Purchase Orders, Bills, SalesOrders.

SourceType will be the category types such as Invoices, Purchase Orders, Bills, SalesOrders.

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

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

Input

Name Type Required Accepts Output Streams Description
SourceId String True False ID of categories like Invoices, Purchase Orders, Bills, SalesOrders.
SourceType String True False Type of source

The allowed values are invoices, purchaseorders, bills, salesorders.

FileLocation String False False The folder path to download the file to.
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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8389