The CData Python Connector for Xero models five Xero APIs as easy-to-use SQL databases: Accounting, Australian Payroll, Files, Fixed Assets, and Projects. Set the Schema property and use the information in each section to select the proper API based on your project needs.

Using the Accounting API

The Accounting Data Model contains the company's financial information, such as contacts, invoices and reporting. It also contains history tables which records changes to most kinds of entities.

INSERTs to specific tables which model line items in the Accounting API have batch support enabled. The recommended BatchSize setting for maximum performance is 50.

Using the Australian Payroll API

The Australian Payroll Data Model contains information on the company's employees, such as timesheets, leave and tax declarations.

INSERTs to specific tables which model line items in the Australian Payroll API have batch support enabled. The recommended BatchSize setting for maximum performance is 50.

Using the Files API

The Files Data Model contains information on the files and attachments managed by Xero. It can be used to upload and download files, and attach them to accounting entities.

Using the Fixed Assets API

The Fixed Assets Data Model contains information on the company's fixed assets, such as registration, depreciation and resale.

Using the Projects API

The Projects Data Model contains information on the company's projects, such as billing and time tracking.