SSIS Components for Zoho CRM

Build 24.0.9062

Attachments

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

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
DuplicateCheckFields String

Converted Bool

Approved Bool

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062