Cases

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

Table-Specific Information

Select

This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.

Insert

INSERT INTO Cases (Email, Priority, Description) VALUES ('[email protected]', 'Medium', 'A simple test case')

Required fields: None.

Any field which is not read-only (ReadOnly = false in the table below) can be inserted.

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Cases WHERE Id = '3152079000000153079'

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE Cases SET Priority = 'Low' WHERE Id = '3152079000000473022'

Required fields: Id.

Any field which is not read-only (ReadOnly = false in the table below) can be updated.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for this record.
CaseOwner_Id	String	False	The Id of the owner of the case.
CaseOwner_FirstName	String	False	The First Name of the owner of the case.
CaseOwner_LastName	String	False	The Last Name of the owner of the case.
CaseNumber	String	False	The number of the case.
Status	String	False	The status of the case.
ProductName_Id	String	False	The Id of the product concerning this case.
Priority	String	False	The priority of the case.
Type	String	False	The type of the case.
CaseReason	String	False	The reason this case was opened.
CaseOrigin	String	False	The origin of this case.
Subject	String	False	The subject of the case.
RelatedTo_Id	String	False	The Id to what this case is related to.
No_ofcomments	Int	True	The number of comments in this case.
AccountName_Id	String	False	The Id of the account of this case.
ReportedBy	String	False	By whom this case was reported.
DealName_Id	String	False	The Id of the deal this case concerns.
Email	String	False	The email of the person opening this case.
Tag	String	False	The tags concerning this case.
Phone	String	False	The phone of the person opening this case.
CreatedBy_Id	String	False	The Id of the User who created the record.
ModifiedBy_Id	String	False	The Id of the User who modified the record.
ModifiedBy_FirstName	String	False	The First Name of the User who modified the record.
ModifiedBy_LastName	String	False	The Last Name of the User who modified the record.
CreatedTime	Datetime	False	The time when the record was created.
ModifiedTime	Datetime	False	The time when the record was modified.
Description	String	False	The description of this case.
InternalComments	String	False	The internal comments of this case.
Solution	String	False	The solution of this case.

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.

JDBC Driver for Zoho CRM