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