Overview

This section shows the available API objects and provides more information on executing SQL to the Zoho Projects API.

Key Features

• The driver models Zoho Projects entities like projects, events, and users as relational views, allowing you to write SQL to query Zoho Projects data.
• Stored procedures allow you to execute operations to Zoho Projects.
• Live connectivity to these objects means any changes to your Zoho Projects account are immediately reflected when using the driver.

Tables

Tables describes the available tables. Tables are statically defined to model projects, events, users, etc.

Views

Views describes the available views. Views are statically defined to model Clients, Documents, Activities, etc.

Stored Procedures

Stored Procedures are function-like interfaces to Zoho Projects. Stored procedures allow you to execute operations to Zoho Projects, including approving timelogs and reordering tasks.