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. |