Attachments

Delete, and query information regarding attachments.

Table-Specific Information

Select

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

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	Id
AttachmentOwner_Id	String	False	AttachmentOwner Id
AttachmentOwner_FirstName	String	True	AttachmentOwner FirstName
AttachmentOwner_LastName	String	True	AttachmentOwner LastName
AttachmentOwner_Email	String	True	AttachmentOwner Email
AttachmentOwner_Name	String	True	AttachmentOwner Name
ModifiedBy_Id	String	False	ModifiedBy Id
ModifiedBy_FirstName	String	True	ModifiedBy FirstName
ModifiedBy_LastName	String	True	ModifiedBy LastName
ModifiedBy_Email	String	True	ModifiedBy Email
ModifiedBy_Name	String	True	ModifiedBy Name
CreatedBy_Id	String	False	CreatedBy Id
CreatedBy_FirstName	String	True	CreatedBy FirstName
CreatedBy_LastName	String	True	CreatedBy LastName
CreatedBy_Email	String	True	CreatedBy Email
CreatedBy_Name	String	True	CreatedBy Name
CreatedAt	Datetime	True	CreatedAt
ModifiedAt	Datetime	True	ModifiedAt
FileName	String	False	FileName
Size	String	False	Size
ParentID_Id	String	False	ParentID Id
ParentID_Name	String	True	ParentID Name
ModuleName	String	False	ModuleName
Editable	String	False	Editable
FileId	String	False	FileId
Type	String	False	Type
State	String	False	State
LinkUrl	String	False	LinkUrl

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.