ModuleAttachedFiles
Retrieves files that are attached to records within a specific module, such as attachments on deals or contacts.
Table-Specific Information
Select
The driver 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 driver.
- 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 record. |
| FileName | String | Name of the file attached to the module record. |
| AttachmentId [KEY] | String | Unique identifier of the attachment entry. |
| CreatorId | String | Identifier of the user who uploaded the attachment. |
| EntityId | String | Identifier of the module record to which the file is attached. |
| DownloadUrl | String | URL to download the attached file. |
| PreviewUrl | String | URL to preview the attached file without downloading. |
| FileSize | String | Size of the attached file. |
| FileExtension | String | The type of file extension. |
| ModuleName | String | Name of the module to which the file is attached. |