RecordCount
To fetch the total number of records in the module.
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 | The total number of records in the module. |
ModuleName | String | The name of the module which the user wants the count. |