Xero
Xero provides cloud accounting services and includes a cashbook, automated daily bank feeds, invoicing, debtors, creditors, sales tax and reporting.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCOUNT, BANK_TRANSACTION, CONTACT, INVOICE, MANUAL_JOURNALS, PAYMENTS, and TAX STATUS tables. Child tables support deletes through weak primary keys. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Xero setup guide to connect Xero with your destination using Fivetran connectors.
Sync overview
We re-import the following tables during every sync:
ASSETASSET_TYPEBRANDING_THEMECURRENCYORGANIZATIONSETTINGSTAX_RATETAX_RATE_COMPONENTTRACKING_CATEGORYTRACKING_CATEGORY_HAS_OPTIONTRACKING_CATEGORY_OPTION
We re-import the following tables once a day:
CONTACTCONTACT_ADDRESSCONTACT_GROUP_MEMBER
Schema information
This schema applies to all Xero connections.
To zoom, open the ERD in a new window.Sync note
Xero limits the number of active connections to 25 for an uncertified app. We recommend that you don't have more than 24 active connections per uncertified app to avoid connection limit exceeded errors while re-authorizing the connection.
UTC conversion
We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Xero account's time zone to store the data in your destination.