Projects Data Model
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Xero account.
The tables include:
| Table | Description |
| Projects | Manages projects in Xero, allowing you to query, insert, and update project data. Projects can be tracked for revenue, expenses, and time entries, allowing you to manage workflows and budgets. |
| Tasks | Stores and manages tasks associated with projects in Xero. You can query, insert, update, and delete tasks, which include details like task name, description, assigned personnel, and deadlines. |
| Time | Stores and manages time entries logged against projects and tasks. It allows for querying, inserting, updating, and deleting time records, which are essential for billing and resource management. |
| Tenants | Queries the list of organizations connected to your Xero account. It helps retrieve tenant details associated with project management and tracking. |
| Users | Queries the users associated with a specific project in Xero. It helps track who is working on a project and their roles, providing insights into team management and collaboration. |
API limitations and requirements are documented in each table.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard create, read, update, delete (CRUD) operations, including managing OAuth tokens.