Attachments

Handles files attached to CRM records, supporting deletion and queries by record or module.

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.
AttachmentOwner_Id	String	False	Unique identifier of the user who owns the attachment.
AttachmentOwner_FirstName	String	True	First name of the user who owns the attachment.
AttachmentOwner_LastName	String	True	Last name of the user who owns the attachment.
AttachmentOwner_Email	String	True	Email address of the user who owns the attachment.
AttachmentOwner_Name	String	True	Full name of the user who owns the attachment.
ModifiedBy_Id	String	False	Unique identifier of the user who last modified the attachment.
ModifiedBy_FirstName	String	True	First name of the user who last modified the attachment.
ModifiedBy_LastName	String	True	Last name of the user who last modified the attachment.
ModifiedBy_Email	String	True	Email address of the user who last modified the attachment.
ModifiedBy_Name	String	True	Full name of the user who last modified the attachment.
CreatedBy_Id	String	False	Unique identifier of the user who created the attachment.
CreatedBy_FirstName	String	True	First name of the user who created the attachment.
CreatedBy_LastName	String	True	Last name of the user who created the attachment.
CreatedBy_Email	String	True	Email address of the user who created the attachment.
CreatedBy_Name	String	True	Full name of the user who created the attachment.
CreatedAt	Datetime	True	Timestamp when the attachment was created.
ModifiedAt	Datetime	True	Timestamp when the attachment was last updated.
FileName	String	False	Name of the attached file.
Size	String	False	Size of the attachment file, typically in bytes.
ParentID_Id	String	False	Unique identifier of the record to which the attachment is linked.
ParentID_Name	String	True	Name of the record associated with the attachment.
ModuleName	String	False	Name of the module (such as Leads or Contacts) where the attachment is stored.
Editable	String	False	Indicates whether the attachment is editable.
FileId	String	False	Internal file identifier used for reference within the system.
Type	String	False	The type or file format of the attachment.
State	String	False	Current state or status of the attachment.
LinkUrl	String	False	URL link to access or download the attachment.

Pseudo-Columns

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