Excel Add-In for Zoho Books

Build 24.0.9060

Budgets

Get the list of budgets.

Table Specific Information

Select

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

  • BudgetId supports the '=' comparison.

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

For example:

    SELECT * FROM Budgets WHERE budgetid = 3255827000000081030

Columns

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060