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