SSIS Components for Zoho Books

Build 22.0.8509


Retrieves list of all the payments made to your vendor.

Table Specific Information


The component uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • VendorId supports the '=' comparison.
  • VendorName supports the '=' comparison.
  • Amount supports the '=,<,<=,>,>=' comparisons.
  • Date supports the '=,<,>' comparisons.
  • Description supports the '=' comparison.
  • LastModifiedTime supports the '=' comparison.
  • PaymentMode supports the '=' comparison.
  • PaymentNumber supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • VendorPaymentFilter supports the '=' comparison.
  • Notes supports the '=' comparison.

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

For example:

    SELECT * FROM VendorPayments WHERE Amount >= 98 AND Date < '2019-07-07'

    SELECT * FROM VendorPayments WHERE PaymentNumber = 1;

    SELECT * FROM VendorPayments WHERE CONTAINS(PaymentMode,'sh')


Name Type References SupportedOperators Description
PaymentId [KEY] String ID of a payment.
VendorId String ID of the vendor the vendor payment has been made. Search payments by vendor id.
VendorName String Name of the vendor the vendor payment has been made. Search payments by vendor name.
AchGwTransactionId String ID of a ACH GW Transaction.
Amount Decimal =,<,<=,>,>= Payment amount made to the vendor. Search payments by payment amount.
Balance Decimal Balance of vendor payment.
BcyAmount Decimal Amount of Base Currency.
BcyBalance Decimal Balance of Base Currency.
CheckDetailsCheckId String ID of a check.
CheckDetailsCheckNumber String Number of a check.
Date Date =,<,> Date the payment is made. Search payments by payment made date.
Description String Description of a vendor payment.
HasAttachment Boolean Check if a vendor payment has attachment.
LastModifiedTime Datetime Last Modified Time of the Vendor Payment.
PaymentMode String Mode through which payment is made. Search payments by payment mode.
PaymentNumber Integer Number through which payment is made. Search with Payment Number.
ReferenceNumber String Reference number of a a bill.


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
VendorPaymentFilter String Filter payments by mode.

The allowed values are PaymentMode.All, PaymentMode.Check, PaymentMode.Cash, PaymentMode.BankTransfer, PaymentMode.Paypal, PaymentMode.CreditCard, PaymentMode.GoogleCheckout, PaymentMode.Credit, PaymentMode.Authorizenet, PaymentMode.BankRemittance, PaymentMode.Payflowpro, PaymentMode.Others..

Notes String Notes of vendor payments..

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