Fields
To get the field metadata for the specified module.
View-Specific Information
Select
The driver uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator.
- ModuleName supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Fields WHERE ModuleName = 'Deals'
Columns
| Name | Type | Description |
| DisplayValue | String | The name of the field. |
| ActualValue | String | The actual name of the field. |
| Id | String | The unique identifier of the field |
| SequenceNumber | Integer | Represents the position of the picklist value field in the layout. |
| ReferenceValue | String | Represents the reference value of the picklist option. |
| ColourCode | String | Represents the hex color code used for the picklist option. |
| Type | String | Represents the type of the picklist option. |
| LayoutAssociations | String | Represents the layout details with which the picklist option is associated. |
| ModuleName | String | The name of the module which the user wants the fields. |