Overview

This section shows the available API objects and provides more information on executing SQL to Jira Service Management APIs.

Key Features

• The cmdlet models Jira Service Management entities like documents, folders, and groups as relational views, allowing you to write SQL to query Jira Service Management data.
• Stored procedures allow you to execute operations to Jira Service Management
• Live connectivity to these objects means any changes to your Jira Service Management account are immediately reflected when using the cmdlet.

Tables

Tables describes the available tables. Tables are statically defined to model Jira Service Management entities such as RequestApprovals, RequestComments, and RequestParticipants.

Views

Views describes the available views. Views are statically defined to model Jira Service Management entities such as Users, Organizations, and ServiceDesks.

Stored Procedures

Stored Procedures are function-like interfaces to Jira Service Management. Stored procedures allow you to execute operations to Jira Service Management, including downloading documents and moving envelopes.