TDV Adapter for Zoho Projects

Build 22.0.8462

PortalClients

Returns the list of client companies in the portal.

Select

You can use the below query to get all Portal Clients:
SELECT * FROM PortalClients

Insert

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

  • Name
  • City
  • Country
  • State
  • FirstAddress
  • SecondAddress
  • WebAddress
  • ZipCode
  • UserEmail
  • WorkProjects
  • PrimaryClient


INSERT INTO PortalClients (Name, UserEmail, WebAddress, FirstAddress, SecondAddress, City, State, Country, PrimaryClient, ZipCode)
VALUES ('Company12', 'email1@example.com', 'www.example.com', 'Address line 1', 'Address line 2', 'Budapest', 'Hungary', 'Hungary', 'Yes', '1025')

Columns

Name Type ReadOnly Description
Id [KEY] String False

Client Id.

Name String False

Client Name.

City String False

Client City.

Country String False

Client Country.

State String False

Client State.

CrmAccountId String False

Client Crm Account Id.

FirstAddress String False

Client First Address.

SecondAddress String False

Client Second Address.

WebAddress String False

Client Web Address.

ZipCode String False

Client Zip Code.

UserId String False

Client User Id.

UserName String False

Client User Name.

UserEmail String False

Client User Email.

UserZpuid String False

Client User Zpuid.

WorkProjects String False

Client Work Projects.

PrimaryClient String False

Client Primary Client.

The allowed values are Yes, No.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462