Reference

Endpoint Read Application Roles

Name

get_applicationroles

Description

No description available

Related Tables

ApplicationRoles

Parameters

Parameter Required Options
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Key DT_WSTR nvarchar(500) 500
Name DT_WSTR nvarchar(500) 500
Groups DT_WSTR nvarchar(2000) 2000
GroupDetails DT_NTEXT nvarchar(MAX)
DefaultGroups DT_WSTR nvarchar(500) 500
DefaultGroupsDetails DT_NTEXT nvarchar(MAX)
SelectedByDefault DT_BOOL bit
Defined DT_BOOL bit
NumberOfSeats DT_I4 int
RemainingSeats DT_I4 int
UserCount DT_I4 int
UserCountDescription DT_WSTR nvarchar(50) 50
HasUnlimitedSeats DT_BOOL bit
Platform DT_BOOL bit
If the column you are looking for is missing, consider customizing Jira 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 Jira Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

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

API Source - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
ApplicationRoles
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the ApplicationRoles table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to read application roles:

API Destination - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
ApplicationRoles
Select
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get ApplicationRoles 

SELECT * FROM ApplicationRoles

get_applicationroles endpoint belongs to ApplicationRoles 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 ApplicationRoles 

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

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

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