Power BI Connector for Xero

Build 24.0.9060

Tables

The connector models the data in Xero as a list of tables in a relational database that can be queried using standard SQL statements.

CData Power BI Connector for Xero Tables

Name Description
Accounts Query, insert, update and delete accounts for a Xero organisation.
BankTransactions Query, insert and update bank transactions for a Xero organisation.
BankTransfers Usage information for the operation BankTransfers.rsd.
BatchPayments Query and insert BatchPayments for a Xero organisation.
ContactGroups Query, insert, update and delete contact groups for a Xero organisation.
Contacts Query, insert and update contacts for a Xero organisation.
CreditNotes Query, insert and update credit notes for a Xero organisation.
Employees Query, insert and update employees for a Xero organisation.
ExpenseClaims Query, insert and update expense claims for a Xero organisation.
HistoryBankTransactions Query and insert BankTransaction history and notes for a Xero organization.
HistoryBatchPayments Query and insert BatchPayment history and notes for a Xero organization.
HistoryContacts Query and insert Contact history and notes for a Xero organization.
HistoryCreditNotes Query and insert CreditNote history and notes for a Xero organization.
HistoryInvoices Query and insert Invoice history and notes for a Xero organization.
HistoryPurchaseOrders Query and insert PurchaseOrder history and notes for a Xero organization.
Invoices Query, insert and update Invoices for a Xero organisation.
Items Query, insert, update and delete items for a Xero organisation.
LinkedTransactions Query, insert, update and delete LinkedTransactions for a Xero organisation.
ManualJournals Query, insert and update manual journals for a Xero organisation.
Payments Query, insert and delete payments for a Xero organisation.
PurchaseOrders Query, insert and update purchase orders for a Xero organisation.
Quotes Query quotes for a Xero organization
Receipts Query, insert and update receipts for a Xero organisation.
TaxRates Usage information for the operation TaxRates.rsd.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060