JDBC Driver for Zoho CRM

Build 22.0.8462

RecordCount

To fetch the total number of records in the module.

View-Specific Information

Select

The driver 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 driver.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462