RecordCount
Returns the total number of records in a given module, useful for data validation or reporting.
View-Specific Information
Select
The connector uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The module is a mandatory filter for the connector.
Note: It works only with ApiVersion=2.1.
- ModuleName supports the '=' operator.
For example, the following queries are processed server-side:
SELECT * FROM RecordCount WHERE ModuleName = 'Leads'
SELECT * FROM RecordCount WHERE ModuleName IN ('Leads','Invoices')
Columns
| Name | Type | Description |
| Count [KEY] | Integer | Total number of records available in the specified module. |
| ModuleName | String | Name of the module for which the record count is retrieved. |