Attachments

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

Table-Specific Information

Select

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

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	False	Identifier of the user who owns the attachment.
Modified_By_Id	String	False	Identifier of the user who last modified the attachment.
Created_By_Id	String	False	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	False	Name of the attached file.
Size	Long	False	Size of the file in bytes.
Parent_Id	Long	False	Identifier of the parent record to which the attachment is linked.
Id_CustomModule	Long	True	Internal identifier for the attachment record.
ModuleName	String	False	Name of the module where the attachment is stored.
Editable	String	False	Indicates whether the attachment can be edited.
FileId	String	False	Unique file identifier.
Type	String	False	Type of the file attached.
State	String	False	Current state of the attachment.
LinkUrl	String	False	Direct URL link to the attachment file.

Pseudo-Columns

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