JDBC Driver for Zoho CRM

Build 22.0.8462

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.

  • CreatedTime supports the '=' operator.
  • ModifiedTime supports the '=' operator.
  • FileName supports the '=, LIKE' operators.
  • Size supports the '=, LIKE' operators.

For example, the following queries are processed server side:

SELECT * FROM Attachments WHERE Id = '3152079000000153079'

SELECT * FROM Attachments WHERE FileName = 'Koala.jpg'

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462