ListFields
List field metadata for the specified module.
View-Specific Information
Select
The connector 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 ListFields WHERE ModuleName = 'Deals'
Columns
| Name | Type | Description |
| ApiName | String | The API Name. |
| AssociationDetails | String | The Association Details. |
| BlueprintSupported | Boolean | Is Blueprint Supported. |
| BusinesscardSupported | Boolean | Is Businesscard Supported. |
| ConvertMappingAccounts | String | The Convert Mapping Accounts. |
| ConvertMappingContacts | String | The Convert Mapping Contacts. |
| ConvertMappingDeals | String | The Convert Mapping Deals. |
| CreatedSource | String | The Created Source. |
| Crypt | String | The Crypt. |
| CurrencyPrecision | Integer | The Currency Precision. |
| CurrencyRoundingOption | String | The Currency Rounding Option. |
| CustomField | Boolean | Is Custom Field. |
| DataType | String | The Data Type. |
| DecimalPlace | Integer | The Decimal Place. |
| DisplayField | Boolean | Is Display Field. |
| DisplayLabel | String | The Display Label. |
| DisplayType | Integer | The Display Type. |
| External | String | The External. |
| FieldLabel | String | The Field Label. |
| FieldReadOnly | Boolean | Is Field ReadOnly. |
| Filterable | Boolean | Is Filterable. |
| HistoryTracking | String | The History Tracking. |
| Id | String | The Id. |
| JsonType | String | The JSON Type. |
| Length | Integer | The Length. |
| MassUpdate | Boolean | Is Mass Update. |
| PickListValues | String | The Pick List Values. |
| PickListValuesSortedLexically | Boolean | Are Pick List Values Sorted Lexically. |
| Profiles | String | The Profiles. |
| QuickSequenceNumber | String | The QuickSequenceNumber. |
| ReadOnly | Boolean | Is ReadOnly. |
| Sortable | Boolean | Is Sortable. |
| Sortable | Boolean | Is Sortable. |
| SystemMandatory | Boolean | Is System Mandatory. |
| Tooltip | String | The Tool tip. |
| Type | String | The Type. |
| UiType | Integer | The Ui Type. |
| ViewTypeCreate | Boolean | Is View Type Create. |
| ViewTypeEdit | Boolean | Is View Type Edit. |
| ViewTypeQuickCreate | Boolean | Is View Type Quick Create. |
| ViewTypeView | Boolean | Is View Type View. |
| Visible | Boolean | Is Visible. |
| Webhook | Boolean | Is Webhook. |
| Searchable | Boolean | Represents whether the field is supported in a search. |
| SharingProperties | String | In a lookup field, represents if the user has access to the records that the field looks up to. |
| ModuleName | String | The name of the module which the user wants the fields. |