ODBC Driver for Zoho Books

Build 26.0.9770

BillComments

Get the list of comments for a bill.

View Specific Information

Select

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

  • BillId supports the '=' comparison.

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

For example:

    SELECT * FROM BillComments WHERE BillId = '460000000098765'

Columns

Name Type References SupportedOperators Description
CommentId [KEY] String Id of the comment.
BillId String

Bills.BillId

Id of the bill.
Description String Description of the comment.
CommentedById String Id of the user who made the comment.
CommentedBy String Name of the user who made the comment.
CommentType String Type of the comment, either system-generated or user-added.
Date Date Date of the comment.
DateDescription String Relative description of the date, such as '2 days ago'.
Time Time Time of the comment.
OperationType String Type of operation performed, such as Added or Updated.
TransactionId String Id of the associated transaction.
TransactionType String Type of the associated transaction.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770