ODBC Driver for Zoho Books

Build 24.0.9060

CustomModules

In Zoho Books, you can create a custom module to record other data when the predefined modules are not sufficient to manage all your business requirements.

Table Specific Information

Select

The driver uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • APIName supports the '=' comparison

The rest of the filter is executed client-side in the driver.

For example:

    SELECT * FROM CustomModules WHERE APIName = 'cm_testing_module'

Insert

INSERT can be executed by specifying the ModuleName, ModulePluralName, and ModuleDescription columns. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.

INSERT INTO CustomModules (ModuleName, ModulePluralName, ModuleDescription) VALUES ('moduletesting', 'codetestings', 'testing insert through code')

Update

UPDATE can be executed by specifying the APIName in the WHERE Clause. The columns that are not read-only can be updated.

UPDATE CustomModules SET ModuleName = 'moduletestings', ModulePluralName = 'codetestingsedit', ModuleDescription = 'testing insert through code' WHERE apiname = 'cm_moduletesting'

Delete


DELETE FROM CustomModules WHERE apiname = 'cm_moduletesting'

Columns

Name Type ReadOnly References SupportedOperators Description
ModuleId [KEY] String True

Id of a module.

ModuleName String False

Name of the module.

ModulePluralName String False

Plural name for the module.

ModuleDescription String False

Description of the custom module to help users understand the purpose of this custom module.

APIName String True

API name of the module.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060