CData Python Connector for Xero

Build 25.0.9454

Currencies

Queries the currencies used in a Xero organization, providing information on the organization's base currency as well as any additional currencies used for multi-currency transactions.

Table Specific Information

The Currencies table allows you to SELECT currencies for a Xero organization.

SELECT

The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.

Note: The Xero API does not support filtering on line items or journal lines.

Columns

Name Type Description
Code [KEY] String The ISO 4217 currency code, which is a three-letter code that uniquely identifies a specific currency (for example, USD for US Dollar, EUR for Euro, GBP for British Pound). This code follows international standards for currency representation.
Description String A user-friendly name or label that identifies the currency. This description typically includes the name of the currency (for example, 'US Dollar', 'Euro') and may also include its symbol (for example, '$', '€') for better recognition.
TenantId String The unique identifier for the tenant, allowing the query to access data specific to a particular tenant rather than using the default connection tenant. This is important in multi-tenant environments where data is isolated between different tenants.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454