Cmdlets for Zoho Books

Build 24.0.8963

TaxGroups

Read, Insert, Update and Delete Tax Groups.

g

Table Specific Information

Select

The 本製品 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 本製品.

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

Name Type ReadOnly References SupportedOperators Description
TaxGroupId [KEY] String True =

Id of the Tax Group.

TaxGroupName String False

Name of the tax group to be created.

TaxGroupPercentage Double False

Tax group percentage.

Taxes String False

Comma Seperated list of tax Ids that are to be associated to the tax group.

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