JDBC Driver for Zoho Books

Build 22.0.8479


To list, add, update and delete details of a bill.

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

  • VendorId supports the '=' comparison.
  • VendorName supports the '=, Contains' comparisons.
  • RecurrenceName supports the '=' comparison.
  • Status supports the '=' comparison.
  • StartDate supports the '=,<,>' comparisons.
  • EndDate supports the '=' comparison.
For example:
    Select * FROM RecurringBills

    Select * FROM RecurringBills where vendorid='3255827000000081003'

    Select * FROM RecurringBills where contains(vendorname,'c')
    Select * FROM RecurringBills where startdate > '2023-03-3'


Name Type References SupportedOperators Description
RecurringBillId [KEY] String ID of a Bill.
VendorId String = ID of the vendor the bill has been made.
VendorName String = Name of the vendor the bill has been made.
Status String = Status of the bill.
RecurrenceName String = Frequency at which recurring bill will be sent.
RecurrenceFrequency String Search recurring bills by recurrence number.
RepeatEvery Integer Integer value denoting the frequency of bill.
StartDate Date =,>,< Date when bill was created.
LastSentDate Date Date when recurring bill was last sent.
NextBillDate Date Date when bill will be sent next.
EndDate Date = Date when the payment is expected.
CreatedTime Datetime Time at which the bill was created.
LastModifiedTime Datetime The time of last modification of the bill.
Total Integer Total of the bill.

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