Advanced Analytica Advanced Analytica: IBOM
← All connectors
Xero logo

Source connector

Xero

Set up Xero as a source and move its data into your chosen destination.

Version 2.1.6 community beta

Xero

Use this page to set up the Xero source connector and find reference information.

Prerequisites

  • Tenant ID - Your Xero organisation ID (required)
  • Start Date - The date to start replicating data from (UTC format)

For multi-tenant Xero accounts, use the Tenant ID to select the organisation you want to connect. Find your Tenant IDs by following Xero documentation.

Required list of scopes to sync all streams:

  • accounting.attachments.read
  • accounting.budgets.read
  • accounting.contacts.read
  • accounting.journals.read
  • accounting.reports.read
  • accounting.reports.tenninetynine.read
  • accounting.settings.read
  • accounting.transactions.read
  • assets.read
  • offline_access

Authentication

You can authenticate with Xero in two supported ways:

For bearer token authentication, follow instructions to obtain:

  • Client ID

For OAuth client credentials, follow instructions to obtain:

  • Client ID
  • Client Secret

Setup guide

  1. Create an application in Xero development center.
  2. Select your authentication method: bearer token or OAuth client credentials.
  3. Configure the required scopes listed in the Prerequisites section.
  4. For bearer token authentication:
  5. For OAuth client credentials:
    • Make sure you have the Client ID and Client Secret from your Xero application.
  6. Enter your Xero Organisation’s Tenant ID.
  7. Enter a Start Date in UTC format YYYY-MM-DDTHH:mm:ssZ for when you want data replication to begin.

Supported sync modes

The Xero source connector supports these sync modes:

Supported streams

Date transformation

Xero uses .NET, so some record date fields may use .NET JSON date format and look like /Date(1419937200000+0000)/. The connector automatically detects and transforms these dates into ISO 8601 format. This provides consistency and makes data processing easier.

The connector also handles ISO 8601 formatted dates. It gives all datetime fields a consistent format with the UTC timezone.

Incremental sync

You can use incremental sync for every stream. The connector uses the UpdatedDateUTC field as the cursor field to track records. Your first sync fetches all data from your specified start date. Later syncs only fetch records updated since the previous sync.

Error handling

The connector automatically handles common API errors:

  • 401 Unauthorized: The connector attempts to refresh the access token and retry the request.
  • 403 Forbidden: The connector logs the error and skips the affected record.
  • 429 Rate Limit Exceeded: The connector follows the Retry-After header and automatically retries after the specified wait time.

Performance considerations

The following Xero API rate limits restrict the connector:

  • Concurrent Limit: 5 calls in progress at one time
  • Minute Limit: 60 calls per minute per tenant
  • Daily Limit: 5000 calls per day per tenant
  • App Minute Limit: 10,000 calls per minute across all tenants

When rate limits are exceeded, the API returns a 429 HTTP status code. The Retry-After header states how many seconds to wait before retrying.

Pagination

The connector automatically handles pagination for every stream. It uses a page size of 100 records per request.

Migration guide

If you’re upgrading from an earlier connector version, see migration guide for important information about changes between versions.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
2.1.62026-06-3079089Update dependencies
2.1.52026-02-2571340Resolve the generator returned from JsonDecoder into dictionary
2.1.42025-03-0155142Update dependencies
2.1.32025-02-2254526Update dependencies
2.1.22025-02-1554042Update dependencies
2.1.12025-02-0843841Update dependencies
2.1.02024-10-2347264Migrate to Manifest-only
2.0.12025-01-1051034Fix for time part being removed from all datetimes fields
2.0.02024-06-0639316Add OAuth and Bearer strategies
1.0.12024-06-0639264[autopull] Upgrade base image to v1.2.2
1.0.02024-04-3036878Migrate to low code
0.2.62024-05-1738330Updating python dependencies
0.2.52024-01-1134154prepare for airbyte-lib
0.2.42023-11-2432837Handle 403 error
0.2.32023-06-1927471Update CDK to 0.40
0.2.22023-06-0627007Update CDK
0.2.12023-03-2024217Certify to Beta
0.2.02023-03-1424005Enable in Cloud
0.1.02021-11-1118666🎉 New Source - Xero [python cdk]
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.