Power BI Connector for Zoho Inventory

Build 24.0.9062

ContactPersons

Read, Insert, Update and Delete Contact Persons.

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 ContactPersons WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the FirstName 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 ContactPersons (FirstName) VALUES ('Test')

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 ContactPersons SET Name = 'test2' WHERE Id = '3285934000000136008'

Delete

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

DELETE FROM ContactPersons WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Id of contact person.

ContactId Long False

Contacts.Id

ID of the contact.

Department String False

department to which the contact person belongs..

Designation String False

designation of the contact person

Email String False

Email ID of the contact person.

EnablePortal String False

Option to enable or disable portal access the contact person.

FirstName String False

First Name of the contact

IsAddedInPortal Boolean True

tells whether the contact person has portal access or not

IsPrimaryContact Boolean True

To mark contact person as primary for communication.

LastName String False

Last Name of the contact.

Mobile String False

Mobile/Cell number of the contact person.

Phone String False

Phone number of the contact person.

Salutation String False

Salutation for the contact.

Skype String False

skype address of the contact person.

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