SSIS Components for Xero

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
AutoExpandDetailsSet this property to true automatically include extra details on BankTransfers, ContactGroups, ExpenseClaims, ExpenseClaimPayments, ExpenseClaimReceipts and Receipts.
IncludeArchivedSet this property to include archived records.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
OtherThese hidden properties are used only in specific use cases.
PseudoColumnsSpecify a set of pseudocolumns to expose as columns.
ReadonlyYou can use this property to enforce read-only access to Xero from the provider.
RetryDailyLimitWhether to wait when Xero reports that the provider has hit its daily limit.
RetryWaitTimeHow long to wait when a request hits the Xero API limit, in milliseconds.
RTKThe runtime key used for licensing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseOptimizedFiltersOnlyWhen 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.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

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