Endpoint

Read Custom Fields

Name

get_custom_fields

No description available

Parameter	Label	Required	Options	Description
CustomColumnsRegex	CustomColumnsRegex	NO		Enter regular expression for custom columns which you like to output. Use Pipe to type multiple column names (must use key - internal names for columns e.g. customfield_10004). You can use Regex too (e.g. field_100\d+ ). This filter is only applied for those fields which has flag custom=true.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(120)`	120	`False`
Key	`DT_WSTR`	`nvarchar(120)`	120	`False`
Name	`DT_WSTR`	`nvarchar(250)`	250	`False`
Custom	`DT_BOOL`	`bit`		`False`
Orderable	`DT_BOOL`	`bit`		`False`
Navigable	`DT_BOOL`	`bit`		`False`
Searchable	`DT_BOOL`	`bit`		`False`
ClauseNames	`DT_WSTR`	`nvarchar(900)`	900	`False`
SchemaType	`DT_WSTR`	`nvarchar(200)`	200	`False`
SchemaSystem	`DT_WSTR`	`nvarchar(200)`	200	`False`
UntranslatedName	`DT_WSTR`	`nvarchar(200)`	200	`False`
SchemaItems	`DT_WSTR`	`nvarchar(200)`	200	`False`
SchemaCustom	`DT_WSTR`	`nvarchar(100)`	100	`False`
SchemaCustomId	`DT_I8`	`bigint`		`False`
ScopeType	`DT_WSTR`	`nvarchar(50)`	50	`False`
ScopeProjectId	`DT_WSTR`	`nvarchar(50)`	50	`False`

If the column you are looking for is missing, consider customizing Jira Connector.

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.

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

Jira

Read Custom Fields

Jira

Read Custom Fields

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_custom_fields

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

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

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];