API Data Provider - Online Help

Float Tables

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

Float Tables

Name Description
Accounts Returns the list of accounts that have been granted access to this team.
Clients Returns the list of clients.
Departments Returns the list of departments.
Holidays Returns a list of holidays.
LoggedTime Returns a list of logged time for the specified person or project within the specified date range.
Milestones Returns project milestones.
People Search for all people in your organization.
PeopleReports Returns a single person report between two dates.
ProjectReports Returns a single project report between two dates.
Projects Returns the list of the projects.
Tasks Returns the list of the tasks.
Timeoffs Returns the list of the timeoffs.
TimeoffTypes Returns the list of time off types that can be assigned to your team.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839.0