How to get the list of all projects and the related permission scheme in a CSV file

Owned by Satti Sai Satya Raghavendra
Last updated: Apr 19, 2023
2 min read

This article explains how to get the list of all projects and the related permission scheme in a CSV file using the Jira Command Line Interface (CLI) app.

Important Information

Ensure that the Jira Command Line Interface (CLI) app is installed in Jira and Atlassian Command Line is installed on the local machine.

Instructions

 

The support for retrieving the list of all projects and the related permission scheme in a CSV through the action getProjectList. Refer to the CLI action given below:

An example, let us try to get the project list

Execute the following action:

--action getProjectList --outputFormat 999 --columns 1,16 --file "projectwithpermissionscheme.csv"

In this action, --outputFormat, --columns & --file refers to the details mentions below:

outputFormat: Determines what columns are retrieved for the list.
columns: Column selection and ordering when action generates CSV output (Here I have mentioned 1,16 so I will be able to get data of only 1st column which is Project key and 16th column which is Permission Scheme not all the columns).
file: Path to file based content or result output.

If you want all the details, remove --columns 1,16 and execute, and the command will get all the details.

--action getProjectList --outputFormat 999 --file "projectwithpermissionscheme.csv"

Â