Endpoint Get Project Members
Name
get_project_members
Description
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: ProjectId |
YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| id |
DT_WSTR
|
nvarchar(100)
|
100 | |
| user_email_id |
DT_WSTR
|
nvarchar(100)
|
100 | |
| project_title |
DT_WSTR
|
nvarchar(50)
|
50 | |
| role_name |
DT_WSTR
|
nvarchar(50)
|
50 | |
| role_id |
DT_WSTR
|
nvarchar(100)
|
100 | |
| is_active |
DT_BOOL
|
bit
|
||
| project_code |
DT_WSTR
|
nvarchar(100)
|
100 | |
| project_id |
DT_WSTR
|
nvarchar(100)
|
100 | |
| project_display_id_display_value |
DT_WSTR
|
nvarchar(50)
|
50 | |
| project_display_id_value |
DT_WSTR
|
nvarchar(50)
|
50 | |
| user_is_technician |
DT_BOOL
|
bit
|
||
| user_sms_mail |
DT_WSTR
|
nvarchar(100)
|
100 | |
| user_phone |
DT_WSTR
|
nvarchar(100)
|
100 | |
| user_name |
DT_WSTR
|
nvarchar(50)
|
50 | |
| user_mobile |
DT_WSTR
|
nvarchar(50)
|
50 | |
| user_id |
DT_WSTR
|
nvarchar(100)
|
100 | |
| user_photo_url |
DT_WSTR
|
nvarchar(500)
|
500 | |
| user_is_vip_user |
DT_BOOL
|
bit
|
||
| user_department |
DT_WSTR
|
nvarchar(1020)
|
1020 |
If the column you are looking for is missing, consider customizing ManagedEngine ServiceDesk Plus (Zoho) Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use ManagedEngine ServiceDesk Plus (Zoho) Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - ManagedEngine ServiceDesk Plus (Zoho)
ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items.
ManagedEngine ServiceDesk Plus (Zoho)
Get Project Members
| Required Parameters | |
|---|---|
| ProjectId | Fill-in the parameter... |
| Optional Parameters | |
| ContineOn404Error | True |
API Destination
API Destination - ManagedEngine ServiceDesk Plus (Zoho)
ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items.
ManagedEngine ServiceDesk Plus (Zoho)
Get Project Members
| Required Parameters | |
|---|---|
| ProjectId | Fill-in the parameter... |
| Optional Parameters | |
| ContineOn404Error | True |
ODBC application
Use these SQL queries in your ODBC application data source:
Get project members
SELECT * FROM get_project_members
WITH
(
"ProjectId" = 'abcd-1234-projectid'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get project members
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_project_members
WITH
(
"ProjectId" = ''abcd-1234-projectid''
)';
EXEC (@MyQuery) AT [LS_TO_MANAGEDENGINE_SERVICEDESK_PLUS_ZOHO_IN_GATEWAY];