ODBC Driver for Xero

Build 26.0.9655

AutoExpandDetails

Specifies whether the connection should automatically expand and include additional details for complex objects such as BankTransactions, BankTransfers, ContactGroups. Enabling this option retrieves embedded or related data without requiring separate item-level queries.

Data Type

bool

Default Value

false

Remarks

When set to 'true', additional details are automatically included when querying certain object types (such as BankTransactions), causing some columns that are normally NULL to be populated with related data. This simplifies querying, but may significantly increase response times, especially when retrieving large datasets.

When set to 'false' (default), extra details are omitted to improve performance. To retrieve full details in this mode, individual records must be queried explicitly.

Example:

SELECT * FROM BankTransactions WHERE BankTransactionId = '12345';
Note: Use this setting selectively when you need deep insights into records, and be aware of the potential performance impact.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655