Power BI Connector for Zoho Books

Build 20.0.7654


Get criterions of a specific bank rule.

Table Specific Information


The {i will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the {i.

  • RuleAccountId supports the '=' comparison.
For example:
    SELECT * FROM BankRuleCriterions WHERE RuleAccountId = '1894553000000085382


Name Type References SupportedOperators Description
CriteriaId [KEY] String Id of a criteria.
RuleAccountId String


ID of the Bank Account.
Comparator String Operator for comparing criteria.
Field String Field of a criteria.
Value String Value of a criteria.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654