Tickspot 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.
Tickspot Tables
| Name | Description |
| Clients | Returns all the clients that have opened projects. |
| ClosedProjects | Returns closed projects. |
| ClosedTasks | Returns all closed tasks across all projects. |
| Entries | Returns all time entries that meet the provided parameters. |
| ProjectClosedTasks | Returns all closed tasks for a given project. |
| ProjectEntries | Returns all time entries for a given project. |
| Projects | Returns opened projects. |
| Roles | . |
| TaskEntries | Returns all time entries for a given task. |
| Tasks | Returns all opened tasks for a given project. |
| UserEntries | Returns all time entries for a given user. |
| Users | Returns information about the users on the subscription. Non-administrators will only have visibility of themselves while administrators will see everyone. |