EndPoint Get Change Worklogs
Parameters
| Parameter | Label | Required | Options | Description |
|---|---|---|---|---|
| ChangeId | ChangeId | YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| id |
DT_WSTR
|
nvarchar(180)
|
180 | False |
|
| description |
DT_WSTR
|
nvarchar(64)
|
64 | False |
|
| other_charge |
DT_R8
|
float
|
False |
||
| total_charge |
DT_R8
|
float
|
False |
||
| tech_charge |
DT_R8
|
float
|
False |
||
| time_spent_hours |
DT_I8
|
bigint
|
False |
||
| time_spent_minutes |
DT_I8
|
bigint
|
False |
||
| start_time_display_value |
DT_WSTR
|
nvarchar(84)
|
84 | False |
|
| start_time |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| end_time_display_value |
DT_WSTR
|
nvarchar(84)
|
84 | False |
|
| end_time |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| worklog_type_name |
DT_WSTR
|
nvarchar(36)
|
36 | False |
|
| worklog_type_id |
DT_WSTR
|
nvarchar(64)
|
64 | False |
|
| recorded_time_display_value |
DT_WSTR
|
nvarchar(84)
|
84 | False |
|
| recorded_time |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| include_nonoperational_hours |
DT_BOOL
|
bit
|
False |
||
| mark_first_response |
DT_BOOL
|
bit
|
False |
||
| created_time_display_value |
DT_WSTR
|
nvarchar(210)
|
210 | False |
|
| created_time |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| last_updated_time_display_value |
DT_WSTR
|
nvarchar(210)
|
210 | False |
|
| last_updated_time |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| created_by_email_id |
DT_WSTR
|
nvarchar(180)
|
180 | False |
|
| created_by_is_technician |
DT_BOOL
|
bit
|
False |
||
| created_by_sms_mail |
DT_WSTR
|
nvarchar(2550)
|
2550 | False |
|
| created_by_mobile |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| created_by_last_name |
DT_WSTR
|
nvarchar(40)
|
40 | False |
|
| created_by_user_scope |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
| created_by_phone |
DT_WSTR
|
nvarchar(120)
|
120 | False |
|
| created_by_name |
DT_WSTR
|
nvarchar(130)
|
130 | False |
|
| created_by_id |
DT_WSTR
|
nvarchar(180)
|
180 | False |
|
| created_by_photo_url |
DT_WSTR
|
nvarchar(750)
|
750 | False |
|
| created_by_is_vip_user |
DT_BOOL
|
bit
|
False |
||
| created_by_department |
DT_WSTR
|
nvarchar(2550)
|
2550 | False |
|
| created_by_first_name |
DT_WSTR
|
nvarchar(80)
|
80 | False |
|
| created_by_job_title |
DT_WSTR
|
nvarchar(2550)
|
2550 | False |
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 | Raw | 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 component to read data or in API Destination component to read/write data:
Get Change Worklogs using API Source
ManagedEngine ServiceDesk Plus (Zoho)
Get Change Worklogs
Get Change Worklogs using API Destination
ManagedEngine ServiceDesk Plus (Zoho)
Get Change Worklogs
