Read, Insert, Update and Delete Tax Groups.

g

Table Specific Information

Select

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

• TaxGroupId supports the '=' comparison.

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

For example:

    SELECT * FROM TaxGroups WHERE TaxGroupId = '3255827000000076031'

Insert

INSERT can be executed by specifying the TaxGroupName, Taxes column. 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 TaxGroups (TaxGroupName, TAXES) VALUES ('groupinsert', '3255827000000076025, 3255827000000076013, 3255827000000076007') 

Update

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

UPDATE Taxgroups SET TaxGroupName = 'TaxUpdated' WHERE taxgroupid = 3255827000000077002

Delete

DELETE can be executed by specifying the TaxGroupId in the WHERE Clause For example:

DELETE FROM TaxGroups WHERE TaxGroupId = '3255827000000077002'

Columns