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.
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.
使用できる値は次のとおりです。NONE, BASE64 デフォルト値は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. |