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