API Data Provider - Online Help

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

FreeePM Tables

Name Description
PartnerProjectAsContractors Generated schema file.
PartnerProjectAsOrderers Generated schema file.
Partners Generated schema file.
People Generated schema file.
ProjectBalance Generated schema file.
ProjectConstractors Generated schema file.
ProjectMembers Generated schema file.
ProjectOrderers Generated schema file.
Projects Generated schema file.
ProjectTags Generated schema file.
ProjectWorkloadTagGroups Generated schema file.
TeamMembers Generated schema file.
Teams Generated schema file.
UnitCostRules Generated schema file.
UnitCosts Generated schema file.
UsersMe Generated schema file.
Workloads Generated schema file.
WorkloadSummaries Generated schema file.

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