Attachments

Manages files attached to CRM records, allowing deletion or retrieval based on module, record, or filename.

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.
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 modified the attachment.
ModifiedBy_LastName	String	True	Last name of the user who modified the attachment.
ModifiedBy_Email	String	True	Email address of the user who modified the attachment.
ModifiedBy_Name	String	True	Full name of the user who 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	String	False	Size of the file.
ParentID_Id	String	False	Identifier of the parent record this attachment is linked to.
ParentID_Name	String	True	Name of the parent record this attachment is linked to.
ModuleName	String	False	Name of the module that contains the parent record.
Editable	String	False	Specifies whether the file can be edited.
FileId	String	False	Identifier of the file in storage.
Type	String	False	File type or extension.
State	String	False	Current state or status of the attachment.
LinkUrl	String	False	URL link to access 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.