SSIS Components for Zoho Books

Build 22.0.8509

ContactAddresses

Get addresses of a contact including its Shipping Address, Billing Address.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

  • ContactId supports the '=' comparison.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM ContactAddresses WHERE ContactId = '1894952000000071009'

Columns

Name Type References SupportedOperators Description
AddressId [KEY] String Id of an address.
ContactId String

Contacts.ContactId

ID of a contact.
Attention String Name of a person in billing address.
Address String Address of a contact.
Street2 String Street two of a billing address.
City String City of a billing address.
State String State of a billing address.
Zip String ZIP code of a billing address.
Country String Country of a billing address.
Phone String Phone number of a billing address.
Fax String Fax of a billing address.

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