Contacts
Retrieves list of all contacts.
Table Specific Information
Select
The 本製品 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 本製品.
- ContactName supports the '=' comparison.
- CompanyName supports the '=' comparison.
- Status supports the '=' comparison.
- FirstName supports the '=' comparison.
- LastName supports the '=' comparison.
- Email supports the '=' comparison.
- Phone supports the '=' comparison.
- Address supports the '=' comparison.
- PlaceOfContact supports the '=' comparison.
SELECT * FROM Contacts WHERE CONTAINS(LastName,'D') SELECT * FROM Contacts WHERE FirstName = 'John' AND Status = 'Active' SELECT * FROM Contacts LIMIT 5
Columns
Name | Type | References | SupportedOperators | Description |
ContactId [KEY] | String | Id of a Contact. | ||
ContactName | String | Name of a Contact. | ||
CustomerName | String | Name of the customer. | ||
VendorName | String | Name of the Vendor. | ||
CompanyName | String | Name of a Company. | ||
Website | String | Website of this contact. | ||
LanguageCode | String | Language of a contact. | ||
ContactType | String | Contact type of the contact. | ||
Status | String | Status of the contact.
使用できる値は次のとおりです。All, Active, Inactive, Duplicate | ||
CustomerSubType | String | Sub type of a customer. | ||
Source | String | Source of the contact. | ||
CurrencyId | String |
Currencies.CurrencyId | Currency ID of the customer's currency. | |
String | Facebook profile account. | |||
CurrencyCode | String | Currency code of the customer's currency. | ||
OutstandingReceivableAmount | Decimal | Outstanding receivable amount of a contact. | ||
OutstandingReceivableAmountBcy | Decimal | Base Currency of Outstanding receivable amount of a contact. | ||
OutstandingPayableAmount | Decimal | Outstanding payable amount of a contact. | ||
OutstandingPayableAmountBcy | Decimal | Base Currency of Outstanding payable amount of a contact. | ||
UnusedCreditsPayableAmount | Decimal | Unused credits payable amount of a contact. | ||
FirstName | String | First name of the contact person. | ||
LastName | String | Last name of the contact person. | ||
String | Email address of the contact person. | |||
Phone | String | Phone number of the contact person. | ||
Mobile | String | Mobile number of the contact person. | ||
PlaceOfContact | String | Code for the place of contact. | ||
AchSupported | Boolean | Check if ACH is supported. | ||
CreatedTime | Datetime | Time at which the contact was created. | ||
GSTTreatment | String | Choose whether the contact is GST registered/unregistered/consumer/overseas. | ||
HasAttachment | Boolean | Check if contacts has attachment. | ||
LastModifiedTime | Datetime | The time of last modification of the contact. |
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 | |
Address | String | Address of a contact. |