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

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