ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData JDBC Driver for Zoho CRM ビュー
Name | Description |
ActionsPerformed | Query information regarding performed actions. |
CustomFieldHistoryTracking | Query information regarding histories for a particular custom field. |
Fields | To get the field metadata for the specified module. |
InvoiceProductDetails | Query information regarding product details. Not available in free and standard ZohoCRM accounts. |
Layouts | To get the layouts metadata for the specified module. |
ListFields | 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 organizations. |
PriceBookPricingDetails | Query information regarding pricing details. Not available in free and standard ZohoCRM accounts. |
Profiles | Query information regarding profiles. |
PurchaseOrderProductDetails | Query information regarding purchase order product details. Not available in free and standard ZohoCRM accounts. |
QuoteProductDetails | Query information regarding quote 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 roles. |
SalesOrderProductDetails | Query information regarding sales order product details. Not available in free and standard ZohoCRM accounts. |
StageHistories | Query information regarding stage histories for a particular deal. |
Territories | Get the list of territories enabled for your organization. |
Users | Query information regarding users. |
Visits | Query information regarding recent visits. |