Attachments

Create, update, 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	Long	False	Size
ParentID_Id	String	False	ParentID Id
ParentID_Name	String	True	ParentID Name
RecordId	Long	True	RecordId
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.