Excel Add-In for Zoho CRM

Build 25.0.9539

Fields

To get the field metadata for the specified module.

View-Specific Information

Select

The add-in 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539