Xero

Xero is an accounting app with automatic bank feeds, invoicing, accounts payable, expense claims, fixed asset depreciation, purchase orders, bank reconciliations, and other features.

Data integration: Skyvia supports importing data to and from Xero, exporting Xero data to CSV files, replicating Xero data to relational databases, and synchronizing Xero data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Xero backup.

Query: Skyvia Query supports Xero.

Table of Contents

What Skyvia Can Do for Xero Users

Skyvia consists of several products that can help you working with Xero data.

Data Integration can help you implement different integration scenarios. Data migration from other accounting tools to Xero, integrating Xero with other cloud apps, copying Xero data to a database for data analysis or archiving purposes, syncing Xero data with other cloud apps and databases, designing complex data pipelines including Xero and other data sources, etc.

Query allows you to build quick reports on Xero data by querying it with SQL commands or Visual Query Builder. You can export the result to CSV or PDF formats. Skyvia Query also provides add-ins for Excel and Google Sheets, allowing querying Xero data directly from the corresponding spreadsheet applications. In addition to SELECT, Skyvia Query supports simple DML statements, allowing you to perform mass update and delete operations.

Connect allows publishing Xero data via web API endpoints. You can create OData endpoints and make your Xero data available via OData protocol. You can use the endpoints to connect other tools supporting OData protocol, like Salesforce Connect or Power BI. Additionally, Connect allows you to create SQL endpoints that allow SQL to be executed over the web. Skyvia also provides a ready-to-use ODBC driver, ADO.NET provider, and Looker Studio connector for SQL endpoints.

All Skyvia tools are designed for non-tech users. They allow users to build their custom data flows, and there are no predefined data flows. You can load any Xero data that is available via the Xero API.

Getting Started

To create a connection to Xero in Skyvia, sign in to Xero via OAuth 2.0. Skyvia stores the OAuth authentication token. Skyvia does not store your Xero credentials.

Connection Editor window

  1. In the Connection Editor click Connect to Xero.

  2. In the opened window, enter email and password used when signing up to Xero.

    Signing in to Xero

  3. Click Allow access.

    Authorizing access

  4. The authentication token is generated. Now you need to select Tenant to connect to from the list.

    Signing in to Xero

  5. Use the Test Connection button to make sure that the connection is successful and then click Create Connection.

After you have created a Xero connection, you can start integrating Xero with other sources, querying Xero with the Query tool and publish Xero data via web API endpoints. Please see the following topics of our documentation to know how to use different Skyvia tools:

FAQ

How do I disconnect from Xero?

You can disconnect from Xero on Skyvia side by deleting all the Xero connections you have created together with all the objects that depend from the connections: integrations, endpoints, queries.

Does Skyvia store my data?

Skyvia does not store your Xero login and password. For the details, see the Retention of User Data section in our Security page. Note that Skyvia Backup does not support Xero, and thus, Xero backups cannot be stored on Skyvia.

Will I be notified in case of any data loading errors?

Skyvia has the email notification feature, but it is not enabled by default. Please read the Email Notification topic to find out how to configure it.

Xero Specifics

Object Peculiarities

*Attachment Objects

When importing data to the *Attachments objetcs, don’t use special characters in a file name. The FileName field cannot contain any of the following characters: <, >, :, ", /, \, |, ?, *, \0.

DML Operations Support

Skyvia supports the following DML operations for Xero objects.

Operation Object
INSERT, UPDATE, DELETE Account, ContactGroup, Contact, Employee, Item, LinkedTransaction, ProjectTask, ProjectTime
INSERT, UPDATE BankTransaction, CreditNote, Invoice, ManualJournal, Payment, Project, PurchaseOrder, Quote
INSERT AccountAttachment, BankTransfer, BankTransactionAttachment, BankTransferAttachment, ContactAttachment, CreditNoteAttachment, InvoiceAttachment, ManualJournalAttachment, PurchaseOrderAttachment, QuoteAttachment, RepeatingInvoiceAttachment
UPDATE Overpayment, Prepayment

Incremental Replication

Skyvia supports Incremental Replication for such Xero objects: Account, BankTransaction, BankTransfer, Contact, CreditNote, Employee, Invoice, Item, LinkedTransaction, ManualJournal, Payment, PurchaseOrder, Quote, Overpayment, Prepayment.

Skyvia supports Synchronization for the following Xero objects: Account, BankTransaction, Contact, CreditNote, Employee, Invoice, Item, LinkedTransaction, ManualJournal, Payment, PurchaseOrder, Quote.

Supported Actions and Actions Specifics

Skyvia supports all the common actions for Xero.