DownloadRetainerInvoiceAttachment
Returns the file attached to the retainer invoice.
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 = comparison. The available columns for DownloadExpenseReceipt are RetainerInvoiceId, DocumentId and FileLocation.
RetainerInvoiceId will be the ID of the Retainer Invoice.
DocumentId will be the ID of the Document.
FileLocation will contain the path where the attachment will get downloaded.
For example:
EXECUTE DownloadRetainerInvoiceAttachment RetainerInvoiceId = '1894553000000085021', DocumentId = '1894553000000099221', FileLocation = 'C:/zohobooks'
Input
Name | Type | Required | Accepts Output Streams | Description |
RetainerInvoiceId | String | True | False | Id of retainer invoice. |
DocumentId | String | True | False | Id of document. |
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. |