JDBC Driver for Zoho CRM

Build 22.0.8462

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.

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