ValidationRules
Retrieve ValidationRules data from Zoho Desk.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the validation rule | |
| FieldName | String | False |
Name of the field to which the validation rule applies | |
| CreatedTime | Datetime | True |
Timestamp when the validation rule was created | |
| ModifiedTime | Datetime | True |
Timestamp when the validation rule was last modified | |
| CreatedBy | String | True |
User who created the validation rule | |
| ExecuteInHelpCentre | String | False |
Indicates if the rule executes in the help center | |
| FieldConditions | String | False |
Conditions that must be met for the validation rule | |
| LayoutId | String | False |
Unique identifier of the associated layout | |
| ModifiedBy | String | True |
User who last modified the validation rule | |
| SystemGenerated | String | True |
Indicates if the rule was system generated | |
| DepartmentId | String | True |
Unique identifier of the department |
Pseudocolumns
Pseudocolumn 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 |
| GetActiveLayouts | Boolean |
Filter to retrieve only active layouts |
| GetActiveRules | Boolean |
Filter to retrieve only active validation rules |
| Include | String |
Additional information related to the rules. Values allowed are: creator and modifier. |
| FetchModule | String |
Name of the module for which you want to fetch the layout rules. Allowed values are tickets, contacts, accounts, tasks, timeEntry, contracts, products, calls, events |
| Searchstring | String |
Get the rules that have this search term |