Jira Connector
Documentation
Version: 11
Documentation
Endpoint

Read Groups


Name

get_groups

Description

No description available

Related Tables

Groups

Parameters

Parameter Label Required Options Description
Query Query NO
UserName UserName NO
Exclude Exclude NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
GroupId DT_WSTR nvarchar(50) 50 False
Name DT_WSTR nvarchar(200) 200 False
Html DT_WSTR nvarchar(4000) 4000 False
Labels DT_WSTR nvarchar(4000) 4000 False
If the column you are looking for is missing, consider customizing Jira 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 Jira Connector in API Source component to read data or in API Destination component to read/write data:

Read from Groups table using API Destination

This Endpoint belongs to Groups table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Jira
Groups
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read groups

SELECT * FROM get_groups

get_groups endpoint belongs to Groups 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:

Read groups

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_groups';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

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