Xero
Read accounting records and reports from Xero into a Strata flow. Oplema can't write to Xero.
Before you start
- A Xero login with access to the organization.
- Read permissions Oplema asks for:
offline_access, plus read access to contacts, invoices, payments, bank transactions, settings, manual journals, budgets and reports (balance sheet, profit and loss, trial balance, aged). - Xero journals, payroll, projects and assets aren't available.
- Requests to Xero come from Oplema's servers, not your browser. Oplema doesn't promise a fixed IP address; contact us if you need to allowlist.
Connect
- In Strata, select an Input block.
- Set Source to Connectors.
- In the connector dropdown below it, choose Xero.
- Open the Connection dropdown and choose Create new connection.
- Set Name (optional). Without a name, the connection is labeled
xeroplus the date and time. - Select Connect to Xero. Xero's own sign-in opens in a popup. Approve access there.
The popup closes, the new connection is selected and the pickers below it load. If access later expires or you need more permissions, select the connection, then select Reconnect to Xero.
Read
| Setting | What it does |
|---|---|
| Organisation | Any organization your login can reach. |
| Object | Contacts, Invoices, Payments, Bank Transactions, Accounts, Credit Notes, Prepayments, Overpayments, Batch Payments, Bank Transfers, Quotes, Purchase Orders, Repeating Invoices, Linked Transactions, Manual Journals, Items, Tax Rates, Tracking Categories, Contact Groups, Currencies, Organisation, Branding Themes, Users, Budgets, Balance Sheet, Profit and Loss, Trial Balance, Aged Receivables by Contact or Aged Payables by Contact. |
| Options for the object | Shown for the object you chose: Type for invoices, Status for contacts and accounts, From and To for dated objects (required for Profit and Loss), As of date for other reports, Accounting basis for Balance Sheet, Profit and Loss and Trial Balance, Contact for aged reports, and Rows (Records or Line items) where lines exist. |
Select Refresh data to read again. Line items omit parent totals. Use Parse → JSON for nested details.
Limits and billing
- Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. Failed reads aren't charged, and a read stops when your usage runs out.
See Billing for who pays and how usage works.
Troubleshooting
| Message | What to do |
|---|---|
Xero: HTTP 401. Reconnect to grant the required read permissions. | Select Reconnect to Xero. |
Xero: HTTP 403. Your Xero user or app cannot access this data. | Check your role in Xero. |
Xero: select the report dates | Fill in As of date, or both From and To. |
Xero: cash basis is unavailable for this object | Use Accrual. |
Xero: select a contact only for an aged report | Set Contact on aged reports, and clear it otherwise. |
Xero: inconsistent pagination; refresh data | Select Refresh data. |
Xero: repeated records; the organisation may have changed during this read. Refresh data. | Select Refresh data. |
This transfer exceeds the free 50 MB and the available usage credits | The read passed 50 MB and your usage ran out. Add usage, or read less data. |
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.