Reference

Endpoint Get Release Details

Name

get_release_details

Description

No description available

Related Tables

Releases

Parameters

Parameter Required Options
Name: ReleaseId

Label: ReleaseId

 YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(100) 100
title DT_WSTR nvarchar(300) 300
template_inactive DT_BOOL bit
template_name DT_WSTR nvarchar(100) 100
template_id DT_WSTR nvarchar(100) 100
display_id_display_value DT_WSTR nvarchar(50) 50
display_id_value DT_WSTR nvarchar(50) 50
emergency DT_BOOL bit
release_requester DT_WSTR nvarchar(1020) 1020
description DT_WSTR nvarchar(1020) 1020
release_engineer DT_WSTR nvarchar(1020) 1020
next_review_on DT_WSTR nvarchar(1020) 1020
urgency DT_WSTR nvarchar(1020) 1020
workflow_instance_details_id DT_WSTR nvarchar(100) 100
workflow_instance_details_status_name DT_WSTR nvarchar(50) 50
workflow_instance_details_status_id DT_WSTR nvarchar(100) 100
group DT_WSTR nvarchar(1020) 1020
reason_for_release DT_WSTR nvarchar(1020) 1020
created_time_display_value DT_WSTR nvarchar(100) 100
created_time DT_DBTIMESTAMP datetime
item DT_WSTR nvarchar(1020) 1020
workflow_validated DT_BOOL bit
workflow_name DT_WSTR nvarchar(100) 100
workflow_id DT_WSTR nvarchar(100) 100
workflow_allowed_stages_config DT_WSTR nvarchar(50) 50
release_manager DT_WSTR nvarchar(1020) 1020
impact DT_WSTR nvarchar(1020) 1020
release_type DT_WSTR nvarchar(1020) 1020
priority DT_WSTR nvarchar(1020) 1020
scheduled_end_time DT_WSTR nvarchar(1020) 1020
site DT_WSTR nvarchar(1020) 1020
completed_time DT_WSTR nvarchar(1020) 1020
stage_internal_name DT_WSTR nvarchar(50) 50
stage_inactive DT_BOOL bit
stage_stage_index DT_I4 int
stage_name DT_WSTR nvarchar(50) 50
stage_id DT_WSTR nvarchar(100) 100
risk DT_WSTR nvarchar(1020) 1020
category DT_WSTR nvarchar(1020) 1020
subcategory DT_WSTR nvarchar(1020) 1020
deleted_time DT_WSTR nvarchar(1020) 1020
notes_present DT_BOOL bit
scheduled_start_time DT_WSTR nvarchar(1020) 1020
status_in_progress DT_BOOL bit
status_internal_name DT_WSTR nvarchar(50) 50
status_stage_id DT_WSTR nvarchar(100) 100
status_name DT_WSTR nvarchar(50) 50
status_id DT_WSTR nvarchar(100) 100
release_engineer_email_id DT_WSTR nvarchar(100) 100
release_engineer_cost_per_hour DT_WSTR nvarchar(50) 50
release_engineer_phone DT_WSTR nvarchar(1020) 1020
release_engineer_name DT_WSTR nvarchar(50) 50
release_engineer_mobile DT_WSTR nvarchar(1020) 1020
release_engineer_last_name DT_WSTR nvarchar(100) 100
release_engineer_id DT_WSTR nvarchar(100) 100
release_engineer_photo_url DT_WSTR nvarchar(500) 500
release_engineer_sms_mail_id DT_WSTR nvarchar(1020) 1020
release_engineer_first_name DT_WSTR nvarchar(50) 50
urgency_name DT_WSTR nvarchar(50) 50
urgency_id DT_WSTR nvarchar(100) 100
reason_for_release_name DT_WSTR nvarchar(500) 500
reason_for_release_id DT_WSTR nvarchar(100) 100
release_type_color DT_WSTR nvarchar(50) 50
release_type_pre_approved DT_BOOL bit
release_type_name DT_WSTR nvarchar(50) 50
release_type_id DT_WSTR nvarchar(100) 100
priority_color DT_WSTR nvarchar(50) 50
priority_name DT_WSTR nvarchar(50) 50
priority_id DT_WSTR nvarchar(100) 100
risk_name DT_WSTR nvarchar(50) 50
risk_id DT_WSTR nvarchar(100) 100
category_deleted DT_BOOL bit
category_name DT_WSTR nvarchar(100) 100
category_id DT_WSTR nvarchar(100) 100
subcategory_name DT_WSTR nvarchar(100) 100
subcategory_id DT_WSTR nvarchar(100) 100
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

This Endpoint belongs to the Releases table, therefore it is better to use it, instead of accessing the endpoint directly:

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)
Releases
Required Parameters
ReleaseId Fill-in the parameter...
Optional Parameters
MetaDetectionOrder Default
ContineOn404Error True
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Releases table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get release details:

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)
Releases
Lookup
Required Parameters
ReleaseId Fill-in the parameter...
Optional Parameters
MetaDetectionOrder Default
ContineOn404Error True
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get release details 

SELECT * FROM Releases
WHERE id = 'abcd-1234-releaseid'

get_release_details endpoint belongs to Releases table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get release details 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Releases
WHERE id = ''abcd-1234-releaseid''';

EXEC (@MyQuery) AT [LS_TO_MANAGEDENGINE_SERVICEDESK_PLUS_ZOHO_IN_GATEWAY];

get_release_details endpoint belongs to Releases table(s), and can therefore be used via those table(s).