Tableau Connector for Zoho Books

Build 24.0.9060

RetainerInvoiceDocuments

Get the attachments associated with retainer invoices.

Table Specific Information

Select

The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.

  • RetainerInvoiceId supports the '=,IN' comparisons.
For example:
    SELECT * FROM RetainerInvoiceDocuments WHERE RetainerInvoiceId = '3255827000000101306'

    SELECT * FROM RetainerInvoiceDocuments WHERE RetainerInvoiceId IN ('3255827000000101306', '3255827000000101223')

Columns

Name Type References SupportedOperators Description
DocumentId [KEY] String Id of Document.
RetainerInvoiceId String

RetainerInvoices.RetainerInvoiceId

= Id of a retainer invoice.
FileName String Name of the document attached.
AttachmentOrder Integer Integer denoting the order of attachment.
CanSendInMail Boolean Boolean denoting if the document should be send in mail or not.
FileSize String Size of the file.
FileType String Type of the file.
Source String Source from where file was uploaded.
UploadedBy String The name of the contact who uploaded the file.
UploadedTime Datetime The date and time when file was uploaded.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060