Tables
The driver models the data in Zoho CRM into a list of tables that can be queried using standard SQL statements.
Generally, querying Zoho CRM 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.
CData JDBC Driver for Zoho CRM Tables
Name | Description |
Accounts | Create, update, delete, and query information regarding accounts. |
Activities | Delete, and query information regarding activities. |
Attachments | Delete, and query information regarding attachments. |
Calls | Create, update, delete, and query information regarding calls. |
Campaigns | Create, update, delete, and query information regarding campaigns. |
Cases | Create, update, delete, and query information regarding cases. |
Contacts | Create, update, delete, and query information regarding contacts. |
Currencies | Get, add or update currencies to your organization. |
Deals | Create, update, delete, and query information regarding deals. |
Events | Create, update, delete, and query information regarding events. |
Invoices | Create, update, delete, and query information regarding invoices. Not available in free and standard ZohoCRM accounts. |
Leads | Create, update, delete, and query information regarding Leads. |
Notes | Create, update, delete, and query information regarding notes. |
Pipeline | To fetch the details of all or a specific pipeline in the Deals module. It works only with ApiVersion=2.1. |
PriceBooks | Create, update, delete, and query information regarding price books. Not available in free and standard ZohoCRM accounts. |
Products | Create, update, delete, and query information regarding products. |
PurchaseOrders | Create, update, delete, and query information regarding purchase orders. Not available in free and standard ZohoCRM accounts. |
Quotes | Create, update, delete, and query information regarding quotes. Not available in free and standard ZohoCRM accounts. |
SalesOrders | Create, update, delete, and query information regarding sales orders. Not available in free and standard ZohoCRM accounts. |
Solutions | Create, update, delete, and query information regarding solutions. |
Tasks | Create, update, delete, and query information regarding tasks. |
Vendors | Create, update, delete, and query information regarding vendors. |