ModuleAttachedFiles
Retrieves every file attached to records in a chosen module, useful for compliance or bulk-download tasks.
Table-Specific Information
Select
The connector uses the Zoho CRM 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.
- ModuleName supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM ModuleAttachedFiles WHERE ModuleName = "Leads"
Note: The UploadFile and DownloadFile stored procedures will not work as expected if executed in regards to a custom field. They only upload or download files in the "Attachments" section of the module. Uploading and deleting files from a custom field of type "fileupload" can be done only through the UI.
Columns
| Name | Type | Description |
| FileId | String | Unique identifier of the file attached to the module. |
| FileName | String | The name of the file attached to the module. |
| AttachmentId [KEY] | String | Unique identifier of the attachment. |
| CreatorId | String | Unique identifier of the user who uploaded the attachment. |
| EntityId | String | Unique identifier of the record to which the file is attached. |
| DownloadUrl | String | URL to download the file attachment. |
| PreviewUrl | String | URL to preview the file attachment. |
| FileSize | String | The size of the file attachment. |
| FileExtension | String | The type of file extension. |
| ModuleName | String | Name of the module where the file is attached. |