Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData ADO.NET Provider for Zoho CRM Views
| Name | Description |
| ActionsPerformed | Returns logs of actions performed on CRM records, including edits, deletions, and automation executions. |
| CustomFieldHistoryTracking | Returns a history of changes made to custom fields across modules, supporting field-level audit trails. |
| Fields | Returns detailed metadata for fields in a specified module, including label, API name, data type, and validation rules. |
| InvoiceProductDetails | Provides detailed product line item information for invoices. This view is not available in free or standard ZohoCRM accounts. |
| Layouts | Returns layout metadata for modules, including field positioning, section groupings, and layout rules. |
| ListFields | Provides metadata about fields used in list views of a given module, including field visibility and display order. |
| ModuleAttachedFiles | Retrieves files that are attached to records within a specific module, such as attachments on deals or contacts. |
| Modules | Returns metadata for all modules enabled in the account, including API names, module types, and customization status. |
| Organizations | Displays details about the organization such as name, website, currency settings, and company profile data. |
| PriceBookPricingDetails | Provides pricing details configured within price books. Not available in free or standard Zoho CRM accounts. |
| Profiles | Retrieves information about CRM user profiles, including permission settings and module-level access control. |
| PurchaseOrderProductDetails | Returns item-level purchase order information, such as quantity and unit price. Not available in free or standard accounts. |
| QuoteProductDetails | Displays product-level details for quotes, including discounts, taxes, and quantity. Not available in free or standard accounts. |
| RecordCount | Returns the total number of records in a given module, useful for data validation or reporting. |
| Roles | Displays the role hierarchy within the CRM organization, including reporting structure and permission scope. |
| SalesOrderProductDetails | Shows line items and pricing for products included in sales orders. Not available in free or standard ZohoCRM accounts. |
| StageHistories | Returns the timeline of stage changes for a deal, including timestamps and stage names. |
| Territories | Returns a list of sales territories used for organizing and assigning CRM records by region or criteria. |
| Users | Lists user accounts along with details like email, profile, role, and login status. |
| Visits | Returns recent visit activity data, such as website visits or CRM record access logs. |