Everhour 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.
Everhour Tables
| Name | Description |
| Assignments | Returns all assignments |
| Clients | Returns all clients |
| Expenses | Returns all expenses |
| ExpensesCategories | Returns all expenses categories |
| Invoices | Returns all invoices |
| Me | Returns info about your profile |
| Projects | Returns all projects |
| ProjectSections | Returns all project sections of a given project |
| ProjectTasks | Returns all project tasks of a given project |
| Tasks | Returns all tasks that meet search query criteria or a specific task by Id. |
| TaskTimeRecords | Returns task time records |
| TeamTimeRecords | Returns team time records |
| Users | Returns team users. |
| UserTimeRecords | Returns user time records |