API Data Provider - Online Help

ZohoPeople Tables

The provider models the data in API into a list of tables that can be queried using standard SQL statements.

Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

ZohoPeople Tables

Name Description
Clients Returns the list of clients.
Jobs Returns the list of jobs.
Projects Returns the list of projects.
Timelogs Returns the list of time logs.
Timesheet Returns the timesheet details.
Timesheets Returns the list of timesheets.

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