Reference

Table Fields

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_fields
INSERT
UPDATE
UPSERT
DELETE
LOOKUP

Examples

SSIS

Use Jira Connector in API Source component to read data or in API Destination component to read/write data:

Read from Fields table using API Source

API Source - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
Fields
Optional Parameters
Filter $.data[*]
SSIS API Source - Read from table or endpoint

Read/write to Fields table using API Destination

API Destination - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
Fields
Select
Optional Parameters
Filter $.data[*]
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List issues (fetch specific fields only rather than all)

Lists all issues and fetch only specified fields rather than all fields (useful to speed up data fetch if you only need handful fields) 

SELECT * FROM Issues WITH(Fields='id,key,summary,status')

List fields

Lists all fields that are used and available in issue entity 

SELECT * FROM Fields

SQL Server

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

List issues (fetch specific fields only rather than all)

Lists all issues and fetch only specified fields rather than all fields (useful to speed up data fetch if you only need handful fields) 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Issues WITH(Fields=''id,key,summary,status'')';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

List fields

Lists all fields that are used and available in issue entity 

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

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];