Attachments

Stores and manages files attached to any CRM record, supporting uploads, deletions, and queries.

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.

SELECT * FROM Attachments

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Attachments WHERE Id = '3152079000000431011'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier for the attachment record.
Owner_Id	String	True	Identifier of the user who owns the attachment.
Modified_By_Id	String	True	Identifier of the user who last modified the attachment.
Created_By_Id	String	True	Identifier of the user who created the attachment.
Created_Time	Datetime	True	Date and time when the attachment was created.
Modified_Time	Datetime	True	Date and time when the attachment was last modified.
File_Name	String	True	Name of the attached file.
Size	Long	True	Size of the file in bytes.
Parent_Id	Long	True	Identifier of the parent record to which the attachment is linked.
Id_CustomModule	Long	True	Internal identifier for the attachment record.
ModuleName	String	True	Name of the module where the attachment is stored.
Editable	String	True	Indicates whether the attachment can be edited.
FileId	String	True	Unique file identifier.
Type	String	True	Type of the file attached.
State	String	True	Current state of the attachment.
LinkUrl	String	True	Direct URL link to the attachment file.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.