SSIS Components for Zoho CRM

Build 25.0.9434

ModuleAttachedFiles

Retrieves every file attached to records within a specified module for review or bulk download.

Table-Specific Information

Select

The component 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 component.

  • 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 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 entity associated with the attachment.
DownloadUrl String Web address used to download the attachment.
PreviewUrl String Web address used to preview the attachment.
FileSize String Size of the attachment file.
FileExtension String File extension indicating the type of attachment.
ModuleName String Name of the module to which the file is attached.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434