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