SSIS Components for Jira Service Management

Build 24.0.9060

RequestTypes

This resource represents a request type.

Select

The component will use the Jira Service Management API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

  • ServiceDeskId supports the '=' operator.
  • ID supports the '=' operator.
  • GroupIds supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM RequestTypes WHERE ServiceDeskId = '1'
SELECT * FROM RequestTypes WHERE Id = '10012'
SELECT * FROM RequestTypes WHERE GroupIds = '12'

Columns

Name Type Description
Id [KEY] String The ID of the request type.
ServiceDeskId [KEY] String The Id of the service desk.
GroupIds String The IDs of the groups that this request type is part of.
Name String The Name of the request type.
Description String The description of the request type.
PortalId String The Id of the customer portal associated with the service desk project.
IssueTypeId String The Id of the issue type the request type is based upon.

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
SearchQuery String String to be used to filter the results.

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