ContactPersons

Read, Insert, Update and Delete Contact Persons.

Table Specific Information

Select

The add-in 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 add-in.

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.