Excel Add-In for Zoho Books

Build 24.0.9060

BankAccountLastImportedStatement

Get the details of previously imported statement for the account.

Table Specific Information

Select

The add-in uses the Zoho Books API to process WHERE clause conditions built with the AccountId column, which supports '=,IN' comparisons.

The rest of the filter is executed client-side in the add-in.

For example:

    SELECT * FROM BankAccountLastImportedStatement WHERE accountid = '3255827000000101306'

    SELECT * FROM BankAccountLastImportedStatement WHERE accountid IN ('3255827000000101306', '3255827000000101223')

Columns

Name Type References SupportedOperators Description
StatementId [KEY] Long The Statement Id.
AccountId String

BankAccounts.AccountId

= The Id of the Bank/Credit Card account.
FromDate Date From Date.
Source String Source.
ToDate Date To Date.
Transactions String Transactions.

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