How to get the versions List of a JIRA Project From Confluence??

[Ibrahim Farhan]

In confluence, I want to get a list of versions of a specific JIRA project.

What are the possible API that could be used in this sitaution?

Regards

[Nic Brough -Adaptavist- · Accepted solution]

Use JIRA's REST API to fetch the list. See https://docs.atlassian.com/jira/REST/latest/#api/2/project-getProjectVersions

[Ibrahim Farhan]

Thank you! .

[Bob Swift OSS (Bob Swift Atlassian Apps)]

Here are 2 solutions:

1. JIRA Version List Using the JSON Table Macro - this is available with Advanced Tables for Confluence
2. You can use the CLI Macro (from Run CLI Actions in Confluence) with the following action:

--action getVersionList --project JCLI --outputFormat 2

[Bob Buford]

Hi Bob,

I installed JCLI on Confluence (application linked to our JIRA server instance) and placed the CLI Macro on a Confluence page.  I pasted the action string shown above (project key in JIRA is CRM)

--action getVersionList --project CRM --outputFormat 2

It responds with REMOTE_EXCEPTION

Remote error: User is not authorized to perform the request. Response code: 401.

 That would suggest that I need to authenticate, but I could not find how in your online docs.

Thank you 

[Bob Swift _Appfire_]

You need to provide user and password parameters for practically any CLI action no matter where it is run. So, for instance, you can provide them directly on the action request. Normally when using a command line directly, you hide them away in a initial script file (atlassian, confluence, jira, ... templates provided) so you never need to type them again :). Similarly, when using CLI macro or similar embedded support, you hide them away in a profile so you don't need to repeat them for each use. This also protects them from being seen by others as part of the page source. If you have untrusted users on your site, you will need to protect the usage of the profile using Macro Security. For more information on profiles, see Profiles.

[Bob Buford]

Thanks, Bob - that gives me good direction.  And thanks for the fast response!