Skip to main content
Integrate.io ETL can access your Xero data. This article details creating the Xero connection and the process of building a data pipeline to read Xero data in Integrate.io ETL. There are also pre-built templates to read data from Xero. Please see Create a package from a template for instructions on using a template.

​
To create a Xero connection in Integrate.io ETL

1
Click the Connections icon (lightning bolt) on the top left menu.
2
To create a connection, click New connection.
New connection button in the Connections menu
3
Choose Xero.
Selecting Xero from the connection type list
4
Click Authenticate. (If required, sign in to Xero)
5
Click Connect to authorize Integrate.io ETL access to your Xero account.
6
In the new Xero connection window, name the connection and click Create Xero connection.

​
To modify Xero connections in Integrate.io ETL

1
Click the Connections icon (lightning bolt) on the top left menu.
2
Click a connection to re-connect if your password has changed or the token has expired.
3
To delete a Xero connection, click on the three vertical dots on the far right of the connection listing and select the Delete connection option.

​
To build a data pipeline to read Xero account data in Integrate.io ETL

Xero account data pipeline overview in the package designer

​
REST API Component: accounts

  • Authentication - Click Connection and then select your Xero connection. If you haven’t created your Xero connection yet, click + New and follow the instructions found above.
    REST API component authentication with Xero connection selected
  • URL - Enter the URL for the Accounts endpoint of the Xero API: https://api.xero.com/api.xro/2.0/Accounts. Make sure the method is set to GET. Click Add beneath Headers twice to add the following two headers: Accept: application/json, If-Modified-Since: $last_updated_at. Replace the variable $last_updated_at with a timestamp for the minimum age of the updated data.
    Xero Accounts API endpoint URL and custom headers configuration
  • Response - Make sure the JSON response type is selected. Edit the Base record JSON Path Expression field like this: $.Accounts[*].
    JSON response type with base record JSONPath expression
  • Input fields - Click Select all to move all the Available fields over to the Selected fields or pick and choose which fields you would like by clicking on the + icon next to the field name in the Available Fields column. Then click Save.
    Input fields selection with available and selected fields

​
Select Component: parse_account_fields

  • Click Autofill to bring in all the fields from the source component. Convert the UpdatedDateUTC field into a datetime data type using these functions: ToDate((long)REPLACE(REPLACE(UpdatedDateUTC,’\/Date\(’,”),’\+.*’,”)). Click Save.
    Select component converting UpdatedDateUTC to datetime

​
Destination Component: xero_accounts_destination

  • The template shows a Redshift destination component; however, if you’d prefer to use a different destination, delete the Redshift component and select a destination component of your choice.
    Redshift destination component in the pipeline designer
  • Choose target connection - Select your target connection. If you haven’t created your connection yet, click + New.
    Target connection selection dropdown
  • Destination properties - Fill in the values for target schema and table, select an operation type, pre or post-action SQL, and advanced options.
  • Schema mapping - Click Auto-fill to bring in all of the fields. If you’ve selected a Merge operation type, click the Key box next to the merge key field(s). Click Save.
    Schema mapping with auto-filled fields and merge key selection
Last modified on April 20, 2026