Power BI Connector for Jira Service Management

Build 23.0.8839


This resource represents a request.


Set IncludeCustomFields to true in order to retrieve fields and custom fields that are specific to a request type. By default, only the columns mentioned below will be pushed. Note that setting IncludeCustomFields to true will decrease performance.

The 本製品 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 本製品.

  • RequestID supports the '=' operator.
  • RequestTypeID supports the '=' operator.
  • ServiceDeskID supports the '=' operator.
  • RequestOwnership supports the '=' operator.
  • RequestStatus supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM Requests WHERE RequestID = '10001'
SELECT * FROM Requests WHERE RequestTypeID = '12'
SELECT * FROM Requests WHERE ServiceDeskID = '2'
SELECT * FROM Requests WHERE RequestOwnership = 'admin'
SELECT * FROM Requests WHERE RequestStatus = 'OPEN_REQUESTS'


Name Type Description
RequestId [KEY] String The ID of the request.
RequestKey [KEY] String The Key of the request.
RequestTypeId String The ID of the request type.
ServiceDeskId String The Id of the service desk.
CreatedDate String The date when the request is created.
ReporterKey String The key of the reporter.
ReporterDisplayName String The display name of the reporter.
ReporterEmail String The email of the reporter.
ReporterName String The name of the reporter.
ReporterTimeZone String The time zone of the reporter.
CurrentStatus String The current status of the request.
RequestParticipants String The participants of the request.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
RequestOwnership String The owner of the request.


RequestStatus String The status of the request.


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