API Data Provider - Online Help

Timely 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.

Timely Tables

Name Description
Accounts Returns all accounts created within one email address.
ChaildLabels Get all child of given tags present in user's account.
Clients Returns the list of all clients details created for one account.
CurrentUser Returns current user.
Events Returns all the events of active projects present in user's account.
Labels Get all the tags present in user's account.
ProjectEvents Returns all the events for a project. Note: Only normal user can get events of other projects of same account. Limited user can only get events of his own project.
Projects Returns all the events of active projects present in user's account.
Reports Returns all the events of active projects present in user's account.
Teams Returns all teams.
UserEvents Returns all the events for a user. Note: Only normal user can get events of other users of same account. Limited user will always get his one events.
Users Returns all the users.

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