ContactDocuments
Get the attachments associated with contacts.
Table Specific Information
Select
The add-in 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 add-in.
- ContactId supports the '=,IN' comparisons.
SELECT * FROM ContactDocuments WHERE contactid = '3255827000000101306'
SELECT * FROM ContactDocuments WHERE contactid IN ('3255827000000101306', '3255827000000101223')
Columns
| Name | Type | References | SupportedOperators | Description |
| DocumentId [KEY] | String | Id of Document. | ||
| ContactId | String |
Contacts.ContactId | = | Id of a Contact. |
| FileName | String | Name of the document attached. | ||
| AttachmentOrder | Integer | Integer denoting the order of attachment. | ||
| CanShowInPortal | Boolean | Boolean denoting if the document should be shown in portal 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. |