SSIS Components for Jira

Build 24.0.9060

Dashboards

Query the available Dashboards in Jira.

Table Specific Information

Select

The component uses the Jira API to process some of the filters. Jira supports the Id and Filter columns but not both at the same time.

The component processes other filters within the component.

For example, the following queries are processed server side.

SELECT * FROM Dashboards WHERE Id = 10001
You can also filter on the pseudo column Filter:
SELECT * FROM Dashboards WHERE Filter = 'favourite'

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] String = Common The Id of the dashboard.
Name String Common The name of the dashboard
View String Common The view URL of the dashboard.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Filter String This is used to filter data. Valid values include favourite and my.

The allowed values are favourite, my.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060