JDBC Driver for Zoho CRM

Build 23.0.8839

Attachments

Delete, and query information regarding attachments.

Table-Specific Information

Select

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

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

The unique identifier for this record.

AttachmentOwner_Id String False

The Id of the attachment owner.

AttachmentOwner_Name String True

The name of the attachment owner.

ModifiedBy_Id String False

The Id of the User who modified the record.

ModifiedBy_Name String True

The name of the User who modified the record.

CreatedBy_Id String False

The Id of the User who created the record.

CreatedBy_Name String True

The name of the user who created the record.

CreatedAt Datetime False

The time when the record was created.

ModifiedAt Datetime False

The time when the record was modified.

FileName String False

The name of the file of the attachment.

Size String False

The size of the attachment.

ParentID_Id String False

The Id of the parent of the attachment.

ParentID_Name String True

The name of the parent of the attachment.

ModuleName String False

The name of the module this attachment belongs to.

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.

Name Type Description
Word String

Used to search for a specific word in records.

DuplicateCheckFields String

The field/s to be used for checking in an upsert.

Converted Boolean

Set to true to return only converted records.

Approved Boolean

Set to true to return only approved records.

CustomViewId String

The custom view Id to be used for filtering this record.

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