Clients
Returns the list of client companies associated with a specific project Id.
Select
This is a project-level view.- Id supports the following operator: =.
SELECT * FROM Clients WHERE Id = '12345600001'
Columns
Name | Type | Description |
Id [KEY] | String | Client Id. |
Name | String | Client Name. |
City | String | Client City. |
Country | String | Client Country. |
CrmAccountId | String | Client Crm Account Id. |
FirstAddress | String | Client First Address. |
SecondAddress | String | Client Second Address. |
State | String | Client State. |
WebAddress | String | Client Web Address. |
ZipCode | String | Client Zip Code. |
UserId | String | Client User Id. |
UserName | String | Client User Name. |
UserEmail | String | Client User Email. |
UserZpuid | String | Client User ZPUID. |