JDBC Driver for Zoho CRM

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Zoho CRM Views

Name Description
ActionsPerformed Query information regarding performed actions.
CustomFieldHistoryTracking Query information regarding different histories for a particular custom field.
Fields To get the field metadata for the specified module.
InvoiceProductDetails Query information regarding different product details. Not available in free and standard ZohoCRM accounts.
Layouts To get the layouts metadata for the specified module.
ListFields To get the field metadata for the specified module.
ModuleAttachedFiles Retrieves all the files attached to a specified module.
Modules To get the modules metadata for the specified account.
Organizations Query information regarding different organizations.
PriceBookPricingDetails Query information regarding different pricing details. Not available in free and standard ZohoCRM accounts.
Profiles Query information regarding different profiles.
PurchaseOrderProductDetails Query information regarding different product details. Not available in free and standard ZohoCRM accounts.
QuoteProductDetails Query information regarding different product details. Not available in free and standard ZohoCRM accounts.
RecordCount To fetch the total number of records in the module.
Roles Query information regarding different roles.
SalesOrderProductDetails Query information regarding different product details. Not available in free and standard ZohoCRM accounts.
StageHistories Query information regarding different stage histories for a particular deal.
Territories Get the list of territories enabled for your organization.
Users Query information regarding different users.
Visits Query information regarding recent visits.

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