JDBC Driver for Zoho CRM

Build 23.0.8839

Attachments

Create, update, delete, and query information regarding campaigns.

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

Converted Bool

Approved Bool

CustomViewId String

Trigger String

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