テーブル
本製品 はZoho CRM のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。
一般的には、Zoho CRM テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。
CData JDBC Driver for Zoho CRM テーブル
| 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. |