Attachments

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

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.

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	Identifier of the user who owns the attachment.
AttachmentOwner_FirstName	String	True	First name of the attachment owner.
AttachmentOwner_LastName	String	True	Last name of the attachment owner.
AttachmentOwner_Email	String	True	Email address of the attachment owner.
AttachmentOwner_Name	String	True	Full name of the attachment owner.
ModifiedBy_Id	String	False	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	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	Date and time when the attachment was created.
ModifiedAt	Datetime	True	Date and time when the attachment was last modified.
FileName	String	False	Name of the attached file.
Size	Long	False	Size of the file in bytes.
ParentID_Id	String	False	Identifier of the parent record to which the attachment is linked.
ParentID_Name	String	True	Name of the parent record to which the attachment is linked.
RecordId	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 a more granular control over the tuples that are returned from the data source.