I want to extract all the jira rules

[ishanu.chatterjee]

I know I can export in JSON. But I do not want the contents of the rules. I just want to export the tabular view of the rule names, owners, scopes etc.

[Bill Sheboy]

Hi @ishanu.chatterjee -- Welcome to the Atlassian Community!

There is nothing built-in which can do that.

For some workarounds, depending upon the number of rules you have, the output format you want the output, and the technical skills of your team:

• Navigate to the global rule list, set the count limit to 200, and use a scrolling page capture the list
• Export the list and find (or build) a parser for the JSON file
• Review this article by @Darryl Lee which includes a script to convert the full export to a CSV list.  It will require some modifications to add the fields you note wanting.  https://community.atlassian.com/t5/Automation-articles/Hacking-Parsing-Automation-Rules-with-JSON-for-Fun-and-Profit/ba-p/1984033

Kind regards,
Bill

[Darryl Lee]

Thanks for tagging me @Bill Sheboy (and editing it to point to the correct account!).

Ah yeah, that was a fun article to write.

But now that I look back on it... because I was a little too wordy as usual, let me try to summarize and add a bit.

You'll need to

• Export your rules as JSON
• Export your Projects and Project IDs (because JSON export only contains IDs) to create a mapping table
• Export your list of Users and User IDs (because JSON export only contains IDs) to create a mapping table
• Parse the JSON to just extract the fields you want: Names, Owners, Scopes

After obtaining the mapping tables (and yes, you'll need to have a way to keep them up to date), it's just a matter of finding a tool to parse JSON and map IDs appropriately. I used Perl because I'm old.

Kids today would probably use Python or node or something. :-P

But there are even ways to import JSON into Google Sheets or Excel (as @Aron Gombas _Midori_ points out) and then mapping Projects/Owners would be a straightforward VLOOKUP.

[Aron Gombas _Midori_]

I think your best option is:

1. try to convert the JSON to Excel
2. in Excel, delete the unwanted columns

Step 1 is a rather common problem. Although I am not familiar with any of the tools developed for this, there are many available. This one comes from a well-respected software company. But do your Google research.