CData Python Connector for QuickBooks Online

Build 25.0.9454

Thresholds

Retrieves threshold values set in QuickBooks Online, such as transaction or limit thresholds used for reporting or validation.

View Specific Information

Select

This view will retrieve the threshold entries for the all the entitlements of the user's account.

SELECT * FROM Thresholds

Columns

Name Type References Description
Name String The display name of the threshold as it appears in QuickBooks Online. This name identifies which feature, entity, or attribute the threshold applies to (for example, number of custom fields, number of recurring transactions).
Limit String The maximum allowed value that QuickBooks Online permits for this threshold. This field defines the upper limit that is enforced or monitored (for example, a maximum of 50 custom fields).
Enforced String Indicates whether this threshold is actively enforced (true) or only monitored (false). When it is enforced, QuickBooks Online prevents operations that will exceed the threshold. When it is not enforced, QuickBooks Online can still display warnings, but it allows the operation to proceed.
CurrentCount String The current measured value of the attribute that is being monitored against this threshold. This field shows how much of the limit has already been consumed (for example, 45 of 50 custom fields used).
AboveThreshold String Indicates whether the current count of the attribute has reached or exceeded the defined limit (true) or remains below it (false). This field enables QuickBooks Online or external integrations to trigger warnings or block actions when limits are breached.

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