Tables
The connector models the data in Xero as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Xero Tables
| Name | 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. |