SSIS Components for Zoho CRM

Build 25.0.9434

ModuleAttachedFiles

Retrieves every file attached to records in a chosen module, useful for compliance or bulk-download tasks.

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

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