Tables
The adapter models the data in Zoho Books into a list of tables that can be queried using standard SQL statements.
Generally, querying Zoho Books tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Zoho Books Adapter Tables
| Name | Description |
| BankAccounts | To list, add, update and delete bank and credit card accounts for your organization. |
| BankRules | To list, add, update and delete specified bank or credit card account ID. |
| BankTransactions | To list, add, update and delete details involved in an account. |
| BaseCurrencyAdjustments | To list, add, update and delete base currency adjustment. |
| BillDetails | To list, add, update and delete details of a bill. |
| ChartOfAccounts | To list, add, update and delete chart of accounts. |
| ContactDetails | To list, add, update and delete a contact. |
| CreditNoteDetails | To list, add, update and delete a Credit Note. |
| Currencies | To list, add, update and delete currencies configured. Also, get the details of a currency. |
| CustomerContacts | Create, Read, Update, Delete contact persons. Also, get the contact person details. |
| CustomerPaymentDetails | To list, add, update and delete details of a payment. |
| EstimateDetails | To list, add, update and delete details of an estimate. |
| ExpenseDetails | To list, add, update and delete details of an Expense. |
| InvoiceDetails | To list, add, update and delete details of an invoice. |
| ItemDetails | To list, add, update and delete details of an existing item. |
| Journals | To list, add, update and delete journals. |
| OpeningBalances | To list, add, update and delete opening balance. |
| Projects | To list, add, update and delete projects. |
| PurchaseOrderDetails | To list, add, update and delete details of a purchase order. |
| RecurringExpenseDetails | To list, add, update and delete details of a recurring expense. |
| RecurringInvoiceDetails | To list, add, update and delete details of a recurring invoice. |
| RetainerInvoiceDetails | To list, add, update and delete of a retainer invoice. |
| SalesOrderDetails | To list, add, update and delete a sales order. |
| Tasks | To list, add, update and delete tasks added to a project. Also, get the details of a task. |
| Taxes | To list, add, update and delete simple and compound taxes. Also, get the details of a simple or compound tax. |
| TimeEntries | To list, add, update and delete time entries. |
| Users | To list, add, update and delete users in the organization. Also, get the details of a user. |
| VendorCreditDetails | To list, add, update and delete details of a vendor credit. |
| VendorPaymentDetails | To list, add, update and delete details of a Vendor Payment. |