Power BI Connector for Zoho Inventory

Build 24.0.9062

Users

Read, Insert, Update and Delete Users.

Table Specific Information

Select

The 本製品 will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.

  • Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the Name and email column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Users (name, email, userrole) VALUES ('Test', '[email protected]', 'admin')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Users SET Name = 'test2', Email = '[email protected]' WHERE Id = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM Users WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Id of the user

Email String False

email address of the user

IsCurrentUser Boolean True

check if user is activated or not

Name String False

name of the user

PhotoUrl String True

PhotoUrl

RoleId String True

RoleId

Status String True

Status

UserRole String False

UserRole

UserType String True

Usertype

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
UserFilter String

Criteria used to filter

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062