JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all estimates.

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

  • CustomerId supports the '=' comparison.
  • CustomerName supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • EstimateNumber supports the '=' comparison.
  • ExpiryDate supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • Status supports the '=' comparison.
  • Total supports the '=,<,<=,>,>=' comparisons.
  • ItemId supports the '=' comparison.
  • ItemName supports the '=' comparison.
  • ItemDescription supports the '=' comparison.
For example:
    SELECT * FROM Estimates WHERE Total >= 500 AND Total <= 600

    SELECT * FROM Estimates WHERE Date <= '2019-02-26'

    SELECT * FROM Estimates ORDER BY CustomerName

    SELECT * FROM Estimates WHERE CONTAINS(EstimateNumber,'006')


Name Type References SupportedOperators Description
EstimateId [KEY] String ID of an estimate.
AcceptedDate Date Accepted date of an estimate.
ClientViewedTime Datetime Time when client viewed the estimate.
ColorCode String Color code of estimates.
CompanyName String Name of the company.
CreatedTime Datetime Time at which the estimate was created.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String


Currency ID of the customer's currency.
CustomerId String


ID of the customer or vendor. Search estimates by customer id..
CustomerName String Name of the customer or vendor. Search estimates by customer name.
Date Date =,<,> Date of an estimate.
DeclinedDate Date Declined date of the estimate.
EstimateNumber String Number of the estimate.
ExpiryDate Date The date of expiration of the estimates.
HasAttachment Boolean Check if the estimate has attachment.
IsEmailed Boolean Check if the estimate is emailed.
ReferenceNumber String Reference number of the estimate.
Status String Status of the estimate.

使用できる値は次のとおりです。draft, sent, invoiced, accepted, declined, expired

Total Decimal =,<,<=,>,>= Total of estimates. Search estimates by estimate total.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ItemId String ID of the item.
ItemName String Name of an item.
ItemDescription String Description of an item.
EstimateFilter String Filter estimates by status.

使用できる値は次のとおりです。Status.All, Status.Sent, Status.Draft, Status.Invoiced, Status.Accepted, Status.Declined, Status.Expired

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