Cases

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_Name	String	True	The 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.
ProductName_Name	String	True	The name 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.
RelatedTo_Name	String	True	The name to what this chase 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.
AccountName_Name	String	True	The name 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.
DealName_Name	String	True	The name 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.
CreatedBy_Name	String	True	The name of the user who created the record.
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.
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.
Comments	String	True	A list of comments regarding this case.

Pseudo-Columns

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.