Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AutoExpandDetails | Set this property to true automatically include extra details on BankTransfers, ContactGroups, ExpenseClaims, ExpenseClaimPayments, ExpenseClaimReceipts and Receipts. |
| DirectQueryLimit | Limits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| IncludeArchived | Set this property to include archived records. |
| MaximumColumnSize | The maximum column size. |
| MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
| Other | These hidden properties are used only in specific use cases. |
| PseudoColumns | Specify a set of pseudocolumns to expose as columns. |
| Readonly | You can use this property to enforce read-only access to Xero from the provider. |
| RetryDailyLimit | Whether to wait when Xero reports that the provider has hit its daily limit. |
| RetryWaitTime | How long to wait when a request hits the Xero API limit, in milliseconds. |
| RTK | The runtime key used for licensing. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UseOptimizedFiltersOnly | When set to true, this property causes the provider to only push optimized filters to the Xero API. This will ensure stability of queries when querying endpoints with High Volume Thresholds. See Xero API Limits for more info. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |