JDBC Driver for Zoho Books

Build 22.0.8479


To get the list of budgets

Table Specific Information


The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • BudgetId supports the '=' comparison.
For example:
    SELECT * FROM Budgets 

    SELECT * FROM Budgets where budgetid=3255827000000081030


Name Type References SupportedOperators Description
BudgetId [KEY] String = Budget Id
BudgetStartDate Integer Budget Start Date
Year Integer Year
Frequency String Frequency
CustomFields String Custom Fields
TagOptionName Date Tag Option Name
ProjectName String Project Name
BudgetEndDate String Budget End Date
EntityType String Entity Type
BranchId String Branch Id
ProjectId String Project Id
BranchName String Branch Name
Name String Name

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479