JDBC Driver for Zoho CRM

Build 24.0.9175

Organizations

Query information regarding organizations.

View-Specific Information

Select

The driver processes filters client-side within the driver.

Columns

Name Type Description
Id [KEY] String A unique numeric identifier for the organization.
CompanyName String The name of the company for this organization.
PrimaryEmail String The primary email of the organization.
Phone String The phone number of the organization.
Mobile String The mobile phone number of the organization.
IsoCode String The ISO code of the organization.
Description String The description of the organization.
Country String The country where this organization is situated.
City String The city where this organization is situated.
State String The state where this organization is situated.
Street String The street where this organization is situated.
Zip String The zip where this organization is situated.
CountryCode String The country code of the organization.
Alias String The alias of the organization.
Fax String The fax of the organization.
EmployeeCount Int The number of employees this organization has.
Website String The website of the organization.
CurrencySymbol String The default currency symbol for the organization.
CurrencyLocale String The default currency locale for the organization.
PrimaryZuid String The primary ZUID for the organization.
TimeZone String The time zone for the organization.
Zgid String The zgid for the organization.
MCStatus Boolean Whether this organization has MC status or not.
GappsEnabled Boolean Whether this organization has gapps enabled or not.
LicenseDetailsPaidExpiry Datetime The date and time the subscription expires for this organization.
LicenseDetailsTrialType String The trial type of subscription the organization has.
LicenseDetailsTrialExpiry Datetime The date and time the trial subscription expires for this organization.
LicenseDetailsPaid Boolean Whether the organization has a paid subscription.
LicenseDetailsPaidType String The type of subscription the organization has.
LicenseDetailsUsersLicensePurchased Integer The number of licenses purchased by the organization.
PhotoId String Represents the unique ID of the organization photo file.
DomainName String Represents the domain name of the organization. For instance, org694902300.
TranslationEnabled Boolean Represents if translation is enabled for the organization.
Currency String Represents the base/home currency details of the organization.
ZiaPortalId String Represents Zia portal ID of the organization, if configured.
PrivacySettings String Represents if the privacy settings are enabled for the organization.
HipaaComplianceEnabled Boolean Represents if HIPAA compliance is enabled for the organization.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175