Attachments

Delete, and query information regarding attachments.

Table-Specific Information

Select

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

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	False
AttachmentOwner_Id	String	False
AttachmentOwner_Name	String	False
ModifiedBy_Id	String	False
ModifiedBy_Name	String	False
CreatedBy_Id	String	False
CreatedBy_Name	String	False
CreatedAt	Datetime	False
ModifiedAt	Datetime	False
FileName	String	False
Size	String	False
ParentID_Id	String	False
ParentID_Name	String	False
ModuleName	String	False

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.