JDBC Driver for Zoho CRM

Build 22.0.8462

Users

Query information regarding different users.

View-Specific Information

Select

The driver will use the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

  • Id supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '3152079000000150015'

Columns

Name Type Description
Id [KEY] String A unique numeric identifier for the user.
FirstName String The first name of the user.
LastName String The last name of the user.
FullName String The full name of the user.
Email String The email of the user.
RoleName String The name of the role the user has.
RoleId String The Id of the role the user has.
ProfileName String The name of the profile the user has.
ProfileId String The Id of the profile the user has.
Country String The country where the user is situated.
City String The city where the user is situated.
Street String The street where the user is situated.
State String The state where the user is situated.
Zip String The zip where the user is situated.
Alias String The alias of the user.
Signature String The signature of the user.
NameFormat String The format of the name of the user.
PersonalAccount Boolean Whether this user has a personal account or not.
DefaultTabGroup String The default tab group for this user.
CountryLocale String The default country locale of the user.
Fax String The fax of the user.
Website String The website of the user.
Mobile String The mobile phone number of the user.
Phone String The phone number of the user.
Dob String The date of birth of the user.
Status String The status of the user.
Confirm Boolean Whether this user has confirmed his email or not.
Language String The Language of the user.
Locale String The locale of the user.
TimeFormat String The default time format of the user.
DateFormat String The default date format of the user.
DecimalSeparator String The locale of the default decimal separator of the user.
TimeZone String The time zone of the user.
Zuid String The default ZUID of the user.
Territories String A comma separeted string of the user's territories.
CreatedByName String The name of the user who created this user.
CreatedById String The id of the user who created this user.
CreatedAt Datetime The time this user was created.
ModifiedByName String The name of the user who modified this user.
ModifiedById String The id of the user who modified this user.
ModifiedAt Datetime The time this user was last modified.

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
Type String Limit the users returned to the ones of this type

The allowed values are AllUsers, ActiveUsers, DeactiveUsers, ConfirmedUsers, NotConfirmedUsers, DeletedUsers, ActiveConfirmedUsers, AdminUsers, ActiveConfirmedAdmins, CurrentUser.

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