Tableau Connector for Zoho Books

Build 22.0.8479

CashFlowReport

Generated schema file.

Table Specific Information

Select

The connector 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 connector.

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
For example:
    SELECT * FROM cashflowreport

    SELECT * FROM cashflowreport WHERE TransactionDate = 'Today'

    SELECT * FROM cashflowreport WHERE ToDate = '2022-10-31'

    SELECT * FROM cashflowreport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'

Columns

Name Type References SupportedOperators Description
Label String Label
Name String Name
AccountName String Account Name
AccountCode String Account Code
AccountId String Account Id
LabelTotal String Label Total
Total String Total
AccountTotal String Account Total
NetTotalForName Double Net Total For Name

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TransactionDate String Filter transaction by any transaction date.

使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate

ToDate Date To Date
FromDate Date From Date

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479