JDBC Driver for Xero

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Xero Views

Name Description
AgedPayablesByContact Query Aged Payables for a Contact.
AgedReceivablesByContact Query Aged Receivables for a Contact.
BalanceSheet Query a monthly Balance Sheet.
BankStatement Query the transactions listed on the account.
BankSummary Query the balances and cash movements for each bank account.
BrandingThemes Query the Branding Themes defined for the Xero organisation.
BudgetLines Query Budget line items for a Xero organisation
Budgets Query Budgets for a Xero organisation
BudgetSummary Query a monthly Budget Summary.
ContactCISSettings Query CIS settings for contacts in a Xero organisation.
CreditNoteAllocations Query credit note allocations for a Xero organisation.
Currencies Query the Currencies for a Xero organisation.
ExecutiveSummary Query a summary of changes between a month and the previous month
ExpenseClaimPayments Query payments for a Xero organisation.
ExpenseClaimReceipts Query claimed receipts for a Xero organisation.
HistoryBankTransfers Query BankTransfer history and notes for a Xero organization.
HistoryExpenseClaims Query ExpenseClaim history and notes for a Xero organization.
HistoryItems Query Item history and notes for a Xero organization.
HistoryOverpayments Query Overpayment history and notes for a Xero organization.
HistoryPayments Query Payment history and notes for a Xero organization.
HistoryPrepayments Query Prepayment history and notes for a Xero organization.
HistoryReceipts Query Receipt history and notes for a Xero organization.
HistoryRepeatingInvoices Query RepeatingInvoice history and notes for a Xero organization.
Journals Query the line items in journals for a Xero organisation.
Organisation Query organisation data for a Xero organisation.
OrganisationActions Query organisation data for a Xero organisation.
OverpaymentAllocations Query overpayment allocations for a Xero organisation.
Overpayments Query Overpayments for a Xero organisation.
PrepaymentAllocations Query prepayment allocations for a Xero organisation.
Prepayments Query Prepayments for a Xero organisation.
ProfitAndLoss Query a Profit and Loss report over a date range.
Quotes Query quotes for a Xero organization
RepeatingInvoices Query Repeating Invoice templates.
Tenants Query the list of organizations connected to your Xero account.
TrackingCategories Query Tracking Categories for a Xero organisation.
TrialBalance Query a monthly Trial Balance.
Users Query users for a Xero organisation.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462