Cases

Handles customer service requests with fields for priority, SLA, and resolution notes.

Table-Specific Information

The Cases table is only accessible when connected to a ZohoCRM Enterprise Edition account. If using a different edition, this table may not be available.

Select

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

Insert

The following example demonstrates a basic insert operation:

-- Insert a new case with an email address, a medium priority, and a subject
INSERT INTO Cases (Email, Priority, Subject) VALUES ('[email protected]', 'Medium', 'A simple test case')

Required fields: Subject is required. It is recommended to also include fields such as Email and Priority to provide additional case context.

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

Delete

You must specify the Id column in the WHERE clause to delete a record. The following example demonstrates a delete operation:

-- Delete a case by its unique ID
DELETE FROM Cases WHERE Id = '3152079000000153079'

Update

You must specify the Id column in the WHERE clause when executing an update against this table. The following example demonstrates an update operation:

-- Update the priority field for a specific case using its ID
UPDATE Cases SET Priority = 'Low' WHERE Id = '3152079000000473022'

Required fields: Id is required. The update must target a specific record.

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

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier for the case.
Case_Reason	String	False	The reason or issue type for the case.
Case_Number	String	True	The assigned case number.
Owner_Id	String	False	Identifier of the user who owns the case.
Owner_FirstName	String	True	First name of the user who owns the case.
Owner_LastName	String	True	Last name of the user who owns the case.
Owner_Email	String	True	Email address of the user who owns the case.
Status	String	False	Current status of the case, such as Open or Closed.
Product_Name_Id	String	False	Identifier of the related product.
Priority	String	False	Priority level of the case.
Type	String	False	Type of the case, such as question or issue.
Case_Origin	String	False	Source from which the case originated, such as phone or email.
Subject	String	False	Subject line describing the case.
Related_To_Id	String	False	Identifier of the related record, such as a contact or lead.
Account_Name_Id	String	False	Identifier of the associated account.
Deal_Name_Id	String	False	Identifier of the related deal.
No_of_comments	Int	True	Number of comments associated with the case.
Reported_By	String	False	Name of the person who reported the case.
Email	String	False	Email address of the person who reported the case.
Phone	String	False	Phone number of the person who reported the case.
Created_By_Id	String	False	Identifier of the user who created the case record.
Modified_By_Id	String	False	Identifier of the user who last modified the case record.
Modified_By_FirstName	String	True	First name of the user who last modified the case record.
Modified_By_LastName	String	True	Last name of the user who last modified the case record.
Modified_By_Email	String	True	Email address of the user who last modified the case record.
Created_Time	Datetime	False	Date and time when the case record was created.
Modified_Time	Datetime	False	Date and time when the case record was last modified.
Tag	String	False	Tags assigned to the case.
Description	String	False	Detailed description of the case.
Internal_Comments	String	False	Internal-only comments about the case.
Solution	String	False	The resolution or solution for the case.
Add_Comment	String	False	Field used to add a new comment to the case.
Id_CustomModule	Long	True	Internal identifier for the record.
Locked__s	Bool	True	Indicates whether the case is locked for editing.
Last_Activity_Time	Datetime	False	Timestamp of the last activity on the case.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
DuplicateCheckFields	String	The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.

ADO.NET Provider for Zoho CRM