Retrieve customer details from the Zoho Projects portal.

Select

• Name supports '=,!=,CONTAINS' operators
• City supports '=,!=,CONTAINS' operators
• State supports '=,!=,CONTAINS' operators
• Country supports '=,!=,CONTAINS' operators
• ZipCode supports '=,!=,CONTAINS' operators
• AddressFirst supports '=,!=,CONTAINS' operators
• AddressSecond supports '=,!=,CONTAINS' operators
• WebAddress supports '=,!=,CONTAINS' operators

• Columns that support server-side ORDER BY: Id, Name, City, State, Country, ZipCode, AddressFirst, AddressSecond, WebAddress, AddedTime, UpdatedTime

You can use the below query to get all Portal Customers:

SELECT * FROM PortalCustomers

Insert

To create a new PortalCustomer you can specify the following fields:

• Name
• City
• Country
• State
• AddressFirst
• AddressSecond
• WebAddress
• ZipCode
• CustomerType

INSERT INTO PortalCustomers (Name, WebAddress, AddressFirst, AddressSecond, City, State, Country, ZipCode, CustomerType)
VALUES ('Company12', 'www.example.com', 'Address line 1', 'Address line 2', 'Budapest', 'Hungary', 'Hungary', '1025', '1')

Update

PortalCustomers can be updated by providing the Id and issuing an UPDATE statement. You can use the below query to update a portal customer:

UPDATE PortalCustomers SET Name = 'SQL Inserted Bug #5' WHERE Id = '165818000000042126'

Delete

PortalCustomers can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM PortalCustomers WHERE Id = '123456000000042126' 

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	Customer Id.
Name	String	False	Customer Name.
Type	String	True	Customer Type.
City	String	False	Customer City.
State	String	False	Customer State.
Country	String	False	Customer Country.
ZipCode	String	False	Customer Zip Code.
AddressFirst	String	False	Customer Address First Line.
AddressSecond	String	False	Customer Address Second Line.
AssociatedContactCount	Integer	True	Number of contacts associated with the customer.
AssociatedUserCount	Integer	True	Number of users associated with the customer.
WebAddress	String	False	Customer Web Address.
AddedTime	Datetime	True	Customer Added Time.
UpdatedTime	Datetime	True	Customer Updated Time.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
CustomerType	Integer	Customer Type. Accepted values: 1 (Business), 2 (Individual).