Power BI Connector for Zoho Books

Build 20.0.7654


Retrieves list of all users in the organization. Also, get the details of a user.

Table Specific Information


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 本製品.

  • UserId supports the '=' comparison.
  • Status supports the '=' comparison.
For example:
    SELECT * FROM Users WHERE Status = 'All'



Name Type References SupportedOperators Description
UserId [KEY] String Id of a user.
UserRole String Role of a user.
UserType String Type of a user.
CreatedTime Datetime Time at which the user was created.
Email String Email ID of a user.
IsAssociatedForApproval Boolean Check if the user is associated for the approval.
IsClaimant Boolean Check if the user is claimant.
IsCustomerSegmented Boolean Check if the user is customer segmented.
IsEmployee Boolean Check if the user is an employee.
Name String Name of the user.
PhotoUrl String Photo URL of the user.
RoleId String Role ID of a user.
Status String Status of the user.

使用できる値は次のとおりです。All, Active, Inactive, Invited, Deleted

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654