How to Setup Xero Integration

This integration will allow you to connect with Xero and start collecting your data. Our Blendo – Xero connector queries the accounting data for your Xero organizations and syncs it to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Xero
  2. Set the Replication Frequency
  3. Load your Xero data into your data warehouse
  4. Xero expected Data Model and schema
  5. Xero Integration FAQ

In order to setup this integration, you will need to create a connection through the Xero Developer Centre. We will see that bellow step-by-step. For now, let’s add this integration to Blendo.

Getting Started – Setup Xero integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source and click on Xero icon.

2. Next, you will be prompted to Setup your Xero source.

3. You will notice a boxed window containing your X509 Certificate and Consumer Key and they are both needed to connect to Xero.

Import your Xero data into your data warehouse - Blendo.co

Settings you need from Xero

4. If you do not have an account in Xero Developer Center then create one here and log in.

5. Click New App.

Click "Add Application".

6. Select Private.

Select "Private" Application.

7. Provide an Application Name and select your Organization from the drop-down menu.

Xero Developer Centre Interface: Provide an "Application Name" and select your "Organization" from the drop down menu.

8. Now we will need to copy the Certificate from Blendo (select the whole text)

Import your Xero data into your data warehouse - Blendo.co9. and paste it in the X509 Public Key Certificate box in the Paste from Clipboard tab.

Copy the Certificate from Blendo (select the whole text) and paste it in the "X509 Public Key Certificate" box

10. Read the Terms and Conditions and if you agree, check the checkbox.

11. Click Create App.

12. In the new window, click your new app.

Setup Private Xero app

13. you will see your App Credentials. We will need the Consumer Key. Click Copy.

Setup Private Xero app

14. Go back to Blendo modal and paste the key into the Consumer Key.

Import your Xero data into your data warehouse - Blendo.co15. Next please choose the Earliest Report Year you want us to sync in.

16. Add a Table Prefix and choose your Database Schema if needed other than public and click Validate.

17. Then you will return back to the home dashboard. Click on your new Xero data source.

Initial sync and Historical data

For a new integration, Blendo will schedule an initial sync job. That will include the historical data and may take some time to complete.

Set the Replication Frequency

This configuration controls how often Blendo will pull data from your Xero integration. Loading to your data warehouse could take a little bit longer.

18. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

19. In the next pop-up select one of the options available and click Apply.

To help prevent overages, consider setting the integration to replicate less frequently. Ask us for help or recommendations.

Xero Data Model & Schema Information

When Blendo first connects to Xero Data source, will schedule an initial sync job. That will include the historical data and may take some time to complete.

Expected Xero Data Model & Schema Information >>

Xero Integration Troubleshooting FAQ

I get Import error message "Sorry, Please enable order management site setting to use this API"

If during the Xero sync you see a message that your Import Failed with “Sorry, Please enable order management site setting to use this API“, that means that we are not able to sync your Orders resource.

This is because you will need to enable the Enable Order Management in Xero’s UI first so Blendo can have access to your Orders resource from the API.

For more details please check the documentation from Xero.

Questions? Contact us!

in Connecting SaaS Data Sources