Attachments
Create, update, delete, and query information regarding attachments.
Table-Specific Information
Select
The 本製品 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 本製品.
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 | |
RecordId | Long | True | |
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 | Long | False | |
ParentID_Id | String | False | |
ParentID_Name | String | False | |
ModuleName | String | False |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Word | String | |
DuplicateCheckFields | String |
The field/s to be used for checking in an upsert. |
Converted | Bool |
To retrieve the list of converted records. Default value is false. |
Approved | Bool |
To retrieve the list of approved records. Default value is true. |
CustomViewId | Long |
The custom view Id to be used for filtering this record. Will work when useCOQL=false. |
Trigger | String |
To trigger the rule while inserting record into CRM account. |